Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone

I have a database that has run quite successfully for about 18 months. We do
have several different operating systems ie windows nt, windows 2000 &
windows xp.

Over the weekend the database has moved to a different server and now when i
open the database there are several different forms that have a date and time
automatically displayed, only the windows xp users can see the date & times.

No-one has actually touched the database at all?

Its driving me absolutely nuts! and i have no idea what could be the matter!

Thanks for any help you can offer

Carol
 
Over the weekend the database has moved to a different server and now when i
open the database there are several different forms that have a date and time
automatically displayed, only the windows xp users can see the date & times.

No-one has actually touched the database at all?

Its driving me absolutely nuts! and i have no idea what could be the matter!

Thanks for any help you can offer
Click to expand...

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]
 
Hi John

Thanks for your post. I've had a look at the references menu and cant see
anything that says missing. I then started to look for a ANY REFERENCE
checkbox but cant find anything, the only thing i can see is a browse button.

I'm wording on access 97 if that would make a difference.

Thanks again for your help

Carol
 
Hi John

Thanks for your post. I've had a look at the references menu and cant see
anything that says missing. I then started to look for a ANY REFERENCE
checkbox but cant find anything, the only thing i can see is a browse button.
Click to expand...

<g> That's like "Press Any Key" - there's no "Any" key on the
keyboard.

I simply meant to pick some arbitrary unchecked checkbox from the
list, check it, close and open Access, and then uncheck it. This
forces Access to reexamine its program links; it doesn't matter which
box you check - you can check "any" of them!

John W. Vinson[MVP]
 
oh, okay sorry i see what you mean

Thanks, i'll give it a try in the morning

Thanks again for your patience

Carolx
 
Hi John

Gave it a try this morning and still no joy :(

All the xp users are all fine and can see dates and times, its just the
windows nt and windows 2000 users that cant see it.

Can't believe i was quite so stupid about the any key though!!, my apologies
for that.
 
Hi John

Gave it a try this morning and still no joy :(

All the xp users are all fine and can see dates and times, its just the
windows nt and windows 2000 users that cant see it.
Click to expand...

It may be a Windows problem - I have no idea! If you type Ctrl-G and
type

?Date()

in the Immediate window, do you get an error? Do you have any fields
or controls named Date? If so rename them, Access may be getting
confused.

I'm leaving shortly for the rest of the week - if you can't get it
working start a new thread, making it clear that it's not the date
*format* but the date *function* that's not working.

John W. Vinson[MVP]
 
Hi John

I've tried it on my pc which is xp and it works absolutely fine.

I've tried it on the windows 2000 pc and this is the message that comes up
when i use the Ctrl G

2
FormGarment Tracking Details (2) a
Not me isGarment Tracking Details (2)a
FormSwitchboard

When i put in the ?Date() after it i get a compile error cant find project
or library

Strange!

Carolx
 
I've tried it on the windows 2000 pc and this is the message that comes up
when i use the Ctrl G

2
FormGarment Tracking Details (2) a
Not me isGarment Tracking Details (2)a
FormSwitchboard

When i put in the ?Date() after it i get a compile error cant find project
or library
Click to expand...

Well, that's why you're getting the error: somehow, the Date()
function is not being found. Again, the most likely problem is that
*ON THIS COMPUTER* the link to the DLL file containing Date() is
missing or damaged; to repost my boilerplate on the subject:

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.

Note that this is not specifically a problem with an individual
database, or with an individual machine - it's *this* database on
*this* machine, and needs to be fixed on the machine which is showing
the problem.

John W. Vinson[MVP]
 
Back
Top