Ctrl + Semicolon for current date

Question

I am distributing an .mde file made with access 2003, and running it with 2007 runtime and/or 2010 runtime. I asked on the boards here and was told that should work fine. I know there will be a few things to work out...here is one:

When testing the app.mde in the 2007 runtime environment, I press Ctrl+;  (semicolon) to enter the date, it gives me the message: 

"The function you entered can't be used in this expression."

I did some searching and found this suggestion:

Open any code module (or open the debug window using Ctrl-G). Select 

Tools | References from the menu bar. Examine all of the checked 

references: uncheck any that have "MISSING:" in front. You should be 

okay after that (although you might have to go back into the references 

and recheck any you unchecked if you really did need them) 

But none of my checked references say MISSING in front.

Thank you for any help.

Answer 1

Glad you got it working, but I'd have been a bit more comfortable going with the newer versions of the .dll files rather than the older.

But if that's what MS tech support recommended and it works, more power to ya!

Answer 2

Woo hoo!!!!!!!!!!!!! I figured it out for myself!!!!!!!!! Oh happy day!!!!!!!!!!!!

I put this code in a module:

Sub ListReferences()

Dim refCurr As Reference

  For Each refCurr In Application.References

    Debug.Print refCurr.Name & ": " & refCurr.FullPath

  Next

End Sub

I ran it with Ctrl-G to open the immediate window.

I got a list of the references in use.

I compared these files AND DATES with those on the target computer.

I found that although the target computer had the files, the dates were more recent.

I renamed the target files, and copied my earlier versions of those files to the target computer.

I restarted the target computer.

MY ERRORS WENT AWAY!

I got guidance to do this through this article: http://support.microsoft.com/kb/310803

Thank you Microsoft!

Answer 3

Hmm, I just tried using Ctrl+; to enter the current date into a date control on an Access 2010 app and it worked fine. So it would appear to be a built in shortcut.

Answer 4

Thank you so much. These are great troubleshooting questions. My replies are in bold:

Is there any code or macro on the control (or on the form) where you're trying to enter the date?

No, there is no code on the form at all.

If you open the VBA error and select Debug... Compile <your project name> do you get any error messages?

Yes, it compiles without error.

Do you have error trapping in all of your VBA modules?

Yes.

Does the code work with the 2007 production environment but fail only in the runtime? 

No, it fails in both.

Answer 5

Well, a missing Reference is one possible cause of this error message, but far from the only one. Is there any code or macro on the control (or on the form) where you're trying to enter the date? If you open the VBA error and select Debug... Compile <your project name> do you get any error messages? Do you have error trapping in all of your VBA modules? Does the code work with the 2007 production environment but fail only in the runtime?