system date.

[Madhup Thakur]

WIN XP OFFICE XP

Hello.
My office has upgarded from WIN 98 Office 2000 to XP ver of both. The
problem that I am facing is that some of tricks do not work anymore.Like:
Like Ctrl+; does put not put current system date.
=Today() ior =date() in forms shows error instead of system date. I can not
use =Now() which puts in time as well. My wish is to put in current date
only.
Some of the keys seems to be remapped as well.
Any help would be greatly appreciated.
Madhup Thakur

 

[strive4peace]

these things should work... have you checked your library references and
compiled the database?

'~~~~~~~~~~ References ~~~~~~~~~
from a module window, from the menu -->

Tools, References...

is anything MISSING?

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[John Vinson]

My office has upgarded from WIN 98 Office 2000 to XP ver of both. The
problem that I am facing is that some of tricks do not work anymore.Like:
Like Ctrl+; does put not put current system date.
=Today() ior =date() in forms shows error instead of system date.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]