Could not find Field

[harpreett.singhh@gmail.co]

Hi,



I am trying to do Compact and repair my database

This freaking msg Could not Find Field 'Today's Date' appearing and driving me crazy since last 3 hours.

It was working fine upto yesterday.

Could you please advise how to find this Today's Date field in the database ? I have manually checked the default values, queries, forms, reports, table and headers and footers. everywhere. even in the module and and the VBA codes and could not find this field.


I am clueless.

[trevor40]

From the display ~ Today's Date ~ That looks like a Comment for an object that shows the date for today eg date() , it could be in one of your form/forms properties, default value or filter or control source. Check your queries for paramaters. try and compile the db it may point you to it, or try the find text option in the vba window. If all else fails create a new DB and copy each object into it one at a time till you find it.

[John_G]

You will get an error like that (on Compact and repair) if the code does not compile properly. Open a code module (any one will do), then from the menu select Debug - Compile.

That will find the error right away.

It is good practice to do a compile any time you make changes to code.

HTH

John

[harpreett.singhh@gmail.co]

I have done that and Debug - Compile option is now not active.

Did not find any errors.

Regards