Access VBA: Date function not working

Question

I have a button on a form that displays the current date. Very simple code:

MsgBox DATE

This worked for several months, but after some seemingly unrelated changes this stopped working and I get the error: run-time error '2465': Can't find the field "DATE' referred to in your expression.

Clearly, Access stopped recognizing DATE as a function, and is trying to find it as an object that doesn't exist. DATE() is immediately replaced by DATE by Access in the VBA code.

None of the objects in the form are named Date and none of the fields in the control source table have the name Date so I don't know why Access is confused.

When I create a new form with a button and the same code it works. Any ideas?

mielk · Accepted Answer · 2015-07-22 23:01:13Z

6

Try this:

MsgBox VBA.Date

It should point Access to the VBA built-in function instead of some field called DATE.

answered Jul 22, 2015 at 23:01

mielk

3,94014 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Carl Over a year ago

Thank you this worked perfectly. I don't understand why my code worked before, but I'm glad it works now

Andrew Grinder Over a year ago

@Carl, there must have been an issue with some VBA library over written by another library with the same function calls. eg. Date, Without specifying VBA.Date, code could be compromised.

Marc Johnston · Accepted Answer · 2015-07-22 22:57:47Z

0

Date is a data type ... use the Now method

answered Jul 22, 2015 at 22:57

Marc Johnston

1,2961 gold badge7 silver badges17 bronze badges

Collectives™ on Stack Overflow

Access VBA: Date function not working

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related