Date and Textbox - Help!

  • Thread starter Thread starter Bridget
  • Start date Start date
B

Bridget

I have a bizarre problem.
I also have a form that contains an unbound textbox that
uses the default value of Date(). Works fine for 4 PCs,
but the others give "#Name?" in the box.

I also have a query that uses this criteria for field
Print Date:
=Date()-1
Click to expand...

On 4 PCs this is no problem...but on 3 it gives the error
Undefined function 'Date' in expression.


What am I missing?

I'm having to create workarounds and it's becoming a mess!
 
Check if there are any broken references to any libraries
on the 3 machines. I have had this problem when there was
a missing reference which led to the default libraries not
being loaded.

Hope this helps!

Kunjal
 
Bridget,

Open to the code behind one of your forms. Go to Tools - References and see if a
reference is labelled "Missing".
 
Ok...I see it...it's missing mscomct2.ocx library file...I
can get it off one of the other PCs.

Many thanks for the quick response...you saved the day!!!
 
Check your references in any module

I have a bizarre problem.
I also have a form that contains an unbound textbox that
uses the default value of Date(). Works fine for 4 PCs,
but the others give "#Name?" in the box.

I also have a query that uses this criteria for field
Print Date:


On 4 PCs this is no problem...but on 3 it gives the error
Undefined function 'Date' in expression.


What am I missing?

I'm having to create workarounds and it's becoming a mess!
Click to expand...
 
Back
Top