Date() not working...

[gpetrona46]

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...

 

[boblarson]

Date() should work for you unless at any time you may have had a field or object named DATE. If so, you might need to make sure that there are no objects or fields named Date and then import all into a blank database file to reset things.

 

[dbDamo]

Open one of your forms in design view and open up VB Editor. Go to Tools>References. You will see a list of references. If Microsoft Visual basic For Applications extensibility 5.3 is checked then change it to 5.5

 

[boblarson]

Open one of your forms in design view and open up VB Editor. Go to Tools>References. You will see a list of references. If Microsoft Visual basic For Applications extensibility 5.3 is checked then change it to 5.5

However that reference does not have anything to do with the DATE function. All of my databases do not use that reference. If you experienced something around that, it was a coincidence.

 

[gpetrona46]

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.....

 

[dbDamo]

Ok, try scrollling through the references and unchecking any that say MISSING

 

[gpetrona46]

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 is just a simple query.

 

[Brianwarnock]

Why not show us the query, it might help.

Brian

 

[dbDamo]

Good idea, it would be useful to see how you are attempting to use it

 

[gpetrona46]

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.

 

[boblarson]

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.

You can't paste it. You have to upload it. You can paste it into a Word Document and then upload that.

 

[dbDamo]

Can't you just paste it into paint, save it and then and upload the image?

EDIT - beat me to it Bob

 

[boblarson]

Can't you just paste it into paint, save it and then and upload the image?

And that would be another good way.

 

[gpetrona46]

Ok, I think that worked.....

 

[dbDamo]

Have you tried =Date()

 

[gpetrona46]

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

 

[Brianwarnock]

It would default to = and if Date() is recocognised it would automatically capitalise the d, so it looks correctly coded but ?? I ain't got a clue.

Brian

 

[Brianwarnock]

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

You should use DateAdd for that.

Brian

 

[dbDamo]

I've just checked in my 2000 Database and works fine. Have you checked in the references to see if any are MISSING?

 

[boblarson]

Ok, I think that worked.....

If you get the lower case date() like that instead of Date() when you move out of the criteria then it is probably due to at some time having a date field named date. You should try importing everything into a blank database file like I suggested and see if that resets it for you.