Search results

BobLarsen & dbDamo -- I removed the some Modules that I had been testing and now the Date() and Now() works. Thanks for you assistance, much appreciated.....

The attached doc contains a screen print of those references with a "check". There are no references containing "Missing". I also noticed that Now() doesn't work on my reports as well.

Yes, I originally was attempting to use <Date()-365.

Ok, I think that worked.....

I haven't been able to paste a screen print to this message. Is there a certain way to do it? When I paste it is all blank.

I checked off the box for "Microsoft Visual basic For Applications 5.5" but that didn't change the error. The error message reads "There was an error compiling this function. The Visual Basic module contains a syntax error. Check the code, and then recompile it." This is puzzling sine it...

I doubled checked and there are no other objects named Date. This is the first time I've been using MS-Access on this PC. I do recall that there was a need to uncheck a box within Tools but I don't recall where. I reviewed all the "Options" but didn't see any regarding Date.. Thanks.....

There is a setting I believe that is needed to allow Access to recognize and use Date() but I seem to have misplaced my notes regarding where to make the change. Can anyone assist? Thanks...