#name? showing in place of date

[just_some_guy]

Hello,

I'm sure it' a simple problem, but I can't seem to get it fixed. I have a database with multiple reports. On each of these reports I have a text box with "=date()" in the field. This is in a short date format.

Up until today, the date was showing up fine. Now, for some reason, it is asking for me to put in the parameter amount for the "date", and on the report itself, it shows "#Name?"

Any ideas how to fix this?

Thanks!

 

[Trevor G]

Has someone been tinkering with your report? If you are receiving a parameter value it maybe because someone has deleted a field in the report so you get prompted.

Where it shows you the #Name? you should look at the field properties to see what it says, my thoughts are someone has deleted something.

Your date field would be =Date()

 

[rainman89]

try creating another textbox on your report with the =Date() and see what happens...

Do you have the same result?

 

[just_some_guy]

Trevor G,

Thanks for the reply. After the initial post, I noticed that this is messed up on all of my reports, as well as the few forms where I've got it displaying in the footer. Unless someone really went to town, I'm not sure what they could have done.

 

[Trevor G]

I agree with Rays suggestion,

Create another textbox and add the =Date() to see what happens. I would then consider adding some traps, logs etc to see who is doing what in your database. Its a cruel world sometimes at work when a little knowledge is being tested.

 

[just_some_guy]

Ray and Trevor,

Thanks for the suggestion. I tried putting in the new text box with the =date() in it, and I'm meeting with the same result. I'm wondering if someone installed an activeX control that's messing with it at this point. Do you all know of any that might have that effect?

Thanks again

 

[rainman89]

found this article... have anything to do with your situation?
http://www.eggheadcafe.com/software/aspnet/35012807/access-2007-date-name.aspx

Also check your references
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[JamesMcS]

Does =now() as the control source have the same problem?

 

[rainman89]

As James said check now(). It will probably work according to this thread
http://www.accessforums.net/programming/access-2003-date-function-returns-name-1138.html

if that is the case, then you almost definitely have a reference issue

 

[just_some_guy]

Ray,

The articles fixed it. There was a missing reference to a .dll file. I disconnected that link, and sure enough, everything is showing up fine again.

Thanks guys for all your help. I'm off to figure out how to set up the logs to see who is doing what. This has been enough of a head ache for one morning.

 

[rainman89]

Glad that fixed it for you