Date and Textbox - Help!

[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

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!

 

[Kunjal]

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

 

[PC Datasheet]

Bridget,

Open to the code behind one of your forms. Go to Tools - References and see if a
reference is labelled "Missing".

 

[Bridget]

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!!!

 

[Greg Kraushaar]

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!