If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use of date/time
I am using MS Office 2007. I have a query using Now() for the date/time. When
I generate the run-time version on my machine, it worked fine. However, when the same application is generated on another machine with Office 2003, the application failed with a run-time error when the query is executed. Am I missing certain library which I need to include when generating the run-time package? -- Anthony |
#2
|
|||
|
|||
Use of date/time
On Mon, 28 Dec 2009 18:07:01 -0800, Anthony Ching
wrote: I am using MS Office 2007. I have a query using Now() for the date/time. When I generate the run-time version on my machine, it worked fine. However, when the same application is generated on another machine with Office 2003, the application failed with a run-time error when the query is executed. Am I missing certain library which I need to include when generating the run-time package? This appears to be the very common References bug. Open any module in design view, or open the VBA editor by typing Ctrl-G. Select Tools... References from the menu. One of the ..DLL files required by Access will probably be marked MISSING. Uncheck it, recheck it, close and open Access. If none are MISSING, check any reference; close and open Access; then uncheck it again. This will force Access to relink the libraries. The Date() and Now() functions are very vulnerable to this error; if *ANY* library is missing, they may well fail. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|