#error when using GetDate()

  • Thread starter Thread starter Geraldine Hobley
  • Start date Start date
G

Geraldine Hobley

Hello,
I'm having a problem binding a default value of
Today's date into a field on a form. It works fine on my
computer (office xp sp 1), but on some computers the field
has a value of #error on loading.

The default value of the field is

CDate(left(GetTodaysDate(), 10))

where the querie in GetTodays date is as below
sql = "select getdate() as todaysdate"

Also using Now() as the default for the text field also
causes a problem on some pcs.

Any idea why this may be a problem on some pcs, or anyone
know any other ways of getting todays date apart from
GetDate() and now().

Thanx in Advance

Geraldine
 
Geralldine,

Ade files still require references and can have missing references because
they are not really executeables as they require Access.exe to run.

Josh
 
Back
Top