Re: Missing date function (Access 2K)

That sort of message almost always indicates a missing reference of some sort. I presume you don't have missing for any of the references listed, but are you by chance using Word, Excel or Outlook since you have OLE Automation referenced?

Re: Missing date function (Access 2K)

I often do integrate both excel and word into my work, sending access reports to either, merging docs, etc. I also have Missing:utility, but selecting it and browsing to the location (1033 directory), will fix the "missing" but seems only temporarily, and doesn't seem to help my reference problem. Why is it being listed as missing when the file is there? Might accessing from different computers cause this? The utility.mda is located on each computer. Does the utility.mda contain the reference I need? is Date() not a VBA function?

Re: Missing date function (Access 2K)

As Hans indicates, any missing reference tends to cause VBA functions to fail, though the symptoms often vary in terms of what fails and what doesn't. We deploy an MDA file with many of our applications, and insist that it be put into a common folder on each workstation, usually on the local C: drive in a root level folder.

Re: Missing date function (Access 2K)

Welcome to the Lounge and to the Access forum - we hope your visit is fruitful.

I presume you are trying to use it in VBA - if that's the case you don't need to reference it as a function - just use the word Date. If on the other hand you are trying to use it in a SQL string (a query), then you should use it like this: Date(). If you are still getting a NULL returned, try the Now() function and see if it gives you the date and the time. Let us know if this solves the problem.

Re: Missing date function (Access 2K)

Interesting...
Thanks for your quick responses both Wendell AND Hans!
I DID have a FIELD named "Date," and so I changed the name of it to eliminate confusion. However that only produced a different error. Then, per Wendell's suggestion, I used the Now function and that was recognized.

Re: Missing date function (Access 2K)

Apparently, the name Date still confuses Access. Without seeing the database it's hard to say what exactly causes this. If you wish, you can post a stripped down copy of your database so that Loungers can investigate the problem; see <post#=401925>post 401925</post#> for instructions.