Date Error with Windows 7
in [General]
|
Prev: Icons in tab pages
Next: Save Button
From: Bob Vance on 27 Apr 2010 19:31 "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message news:Xns9D67C35A6D881f99a49ed1d0c49c5bbb2(a)74.209.136.82... > John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in > news:47ect5pl2847oab7egs341s8pivrqm8qp6(a)4ax.com: > >> On Tue, 27 Apr 2010 10:58:53 +1200, "Bob Vance" >> <rjvance(a)ihug.co.nz> wrote: >> >>>Going by my friends screen shoots of my db, It is erroring >>>Function is not available in Expressions in query expression >>>Format([HorseDate],"dd-mmm-yy". >>>12 errors and they all finish with a dot and not a bracket is this >>>normal??? Regards Bob >> >> I have no idea; I don't have Win7 and have no immediate intention >> to install it. > > Windows 7 does not cause any more reference problems than any other > version of Windows. > > If everyone would avoid adding any references other than the base > three (Access, VBA and DAO), they'd not run into these problems. > Late binding allows the use of all sorts of external libraries > without exposing the app to the broken reference problem. > > I can't see why anyone would ever add references to anything other > than those basic three, except perhaps naivete, or laziness. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/ Ok my Coder not me as I dont have enough experience with References Changed Visual Basic For Application Microsoft Access 12.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Microsoft DAO 3.6 Object Library For these: Visual Basic For Application Microsoft Access 12.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Microsoft Visual Basic for Application Extensilbilty 5.3 Microsoft Outlook 12 Object Library Microsoft Office 12.0 Access database engine Object Library I have added a email code to outlook and I suspect one of these 3 new references is not liked by Win7 !! I am currently testing with my friend with Win7 which one it is Regards Bob
From: Douglas J. Steele on 27 Apr 2010 22:09 "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:OVMb6Gm5KHA.5476(a)TK2MSFTNGP06.phx.gbl... >> >> If everyone would avoid adding any references other than the base >> three (Access, VBA and DAO), they'd not run into these problems. >> Late binding allows the use of all sorts of external libraries >> without exposing the app to the broken reference problem. >> > Ok my Coder not me as I dont have enough experience with References > Changed > > Visual Basic For Application > Microsoft Access 12.0 Object Library > OLE Automation > Microsoft ActiveX Data Objects 2.1 Library > Microsoft DAO 3.6 Object Library > > For these: > > Visual Basic For Application > Microsoft Access 12.0 Object Library > OLE Automation > Microsoft ActiveX Data Objects 2.1 Library > Microsoft Visual Basic for Application Extensilbilty 5.3 > Microsoft Outlook 12 Object Library > Microsoft Office 12.0 Access database engine Object Library > > I have added a email code to outlook and I suspect one of these 3 new > references is not liked by Win7 !! > I am currently testing with my friend with Win7 which one it is As David suggests, try using just - Visual Basic For Application - Microsoft Access 12.0 Object Library - Microsoft Office 12.0 Access database engine Object Library Use Late Binding rather than setting a reference to Microsoft Outlook 12 Object Library. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
From: Douglas J. Steele on 28 Apr 2010 10:04 "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:%23bt941p5KHA.420(a)TK2MSFTNGP02.phx.gbl... > >> >> As David suggests, try using just >> >> - Visual Basic For Application >> - Microsoft Access 12.0 Object Library >> - Microsoft Office 12.0 Access database engine Object Library >> >> Use Late Binding rather than setting a reference to Microsoft Outlook 12 >> Object Library. >> > I tried that thanks Douglas but now erroring on: Dim recHorseID As New > ADODB.Recordset Is there a specific reason you're using ADO? (DAO is better when dealing with Jet databases) If you feel you must use ADO, add a reference to Microsoft ActiveX Data Objects 2.1 Library. If you're not using DAO, you can remove the reference to Microsoft Office 12.0 Access database engine Object Library -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
From: David W. Fenton on 28 Apr 2010 20:30 "Bob Vance" <rjvance(a)ihug.co.nz> wrote in news:#bt941p5KHA.420(a)TK2MSFTNGP02.phx.gbl: > I tried that thanks Douglas but now erroring on: Dim recHorseID > As New ADODB.Recordset You are using ADO for that function, but aren't doing anything with ADo that's not trivially converted to DAO. DAO is preferred and you should use ADO only for things that DAO *cannot* do. And in that case, I'd use late binding, and use the Connection object of the Application object so I didn't need to even use CreateObject. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: David W. Fenton on 28 Apr 2010 20:34
"Bob Vance" <rjvance(a)ihug.co.nz> wrote in news:OVMb6Gm5KHA.5476(a)TK2MSFTNGP06.phx.gbl: > Visual Basic For Application > Microsoft Access 12.0 Object Library > OLE Automation Have you looked at this library's content in the object viewer? It offers virtually nothing useful, and I don't understand why MS has made it one of the default references starting at least in A2003 (I always remove it immediately). > Microsoft ActiveX Data Objects 2.1 Library I've discussed this in another reply, but I would say to avoid it because it duplicateds 99% of the functionality of ADO. Also, 2.1 is an old version. > Microsoft DAO 3.6 Object Library > > For these: > > Visual Basic For Application > Microsoft Access 12.0 Object Library > OLE Automation > Microsoft ActiveX Data Objects 2.1 Library > Microsoft Visual Basic for Application Extensilbilty 5.3 Why do you think you need this one? > Microsoft Outlook 12 Object Library Use late binding with Outlook to avoid needing a reference. If you do that, all your non-Outlook code will run on machines without Outlook installed. > Microsoft Office 12.0 Access database engine Object Library This last is just DAO for A2007. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |