Problem with Date & Time fields in forms

[PTDAccess]

Hi,

Im having a problem adding the date and time to a new record using a form. The 1st method i used was by inserting the default value set to Date() & Time() functions, this worked fine for over a year, but now on some computers on the network the following error pops up "function is not available in expressions in table-level validation expression".

The 2nd method I tried was to add a macro with 'setvalue' commands to the After Update event of one of the first field's that was entered, this entered the same information into the Time & Date field once the first field was updated. This now brings up the macro fault screen and the 'Halt' button has to be pressed to clear the error.

This only happens on the older computers that access the database, the new computers don't bring up any errors.

Can anyone help me with this problem??!

PTDAccess

 

[boblarson]

Sounds like they may have a problem with references. This can happen and not show in the References as MISSING, so you can try this to fix it if no References show as MISSING.

Open the Tools / References in the code IDE window. Then, click the Browse button and go find MSCOMCTL.ocx (normally in C:\Windows\System32 folder in WinXP, but could be different in other Windows versions). Select it and click OPEN.

Try this out on each of the computers with which you are having a problem.

 

[PTDAccess]

Sounds like they may have a problem with references. This can happen and not show in the References as MISSING, so you can try this to fix it if no References show as MISSING.

Open the Tools / References in the code IDE window. Then, click the Browse button and go find MSCOMCTL.ocx (normally in C:\Windows\System32 folder in WinXP, but could be different in other Windows versions). Select it and click OPEN.

Try this out on each of the computers with which you are having a problem.

What can I say? You're a Guru.....Thanks a million!

 

[boblarson]

My pleasure. I learned that one a LONG time ago when we were moving from Windows 95 to Windows 98 at Boeing.