#error when using GetDate()

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
 
J

Joshua A. Booker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update checkbox when date greater than current. 4
SQL Upsizing: Invalid use of "getdate" within a function 4
dafault value for date not working with Date() but Now() is workin 5
Why and I getting this error message, "This record has been changed by another user since you starte 3
Synchronization problems while moving folders to new email 1
Problem using Date() for default value in my Date/Time field 4
Error "Field can not be updated" when entering data in a subform 3
Today's Date 8

Top