Default value

[Adam Whitehouse]

I have linked tables in Access 2002 where the master table
has the default value in a date field set to '=date()'.
Today's date appears in this table, but not in the linked
table in another database (#NAME? appears). I've
refershed the link, but without it making any difference.
Can anyone shed some light on this?
Thanks
Adam

 

[Jeff Boyce]

Adam

I'm not sure I understand. What is it that you expect to happen?

From your description, it sounds like you expect a linked table to "receive"
the value you've set as a default in your "master table". There's no
built-in mechanism for that, and duplicating data across tables isn't
necessary nor a good idea in a relational table structure.

 

[Adam Whitehouse]

Hi Jeff



Basically I can't get todays date to come up in a table,
whether it's linked or not. I have field called DATE in a
table named 'PickData', the design for it is shown below:



Format Short Date

Caption Date

Default value Date()

Required Yes

Indexed No

IME control No

IME sentence None



However if I try to close and save this table in Access
97, 2000 or 2002 then the following error message appears:



Unknown function 'Date' in validation expression or
default value on 'PickData.DATE'



If I type Now() into the default value then I have no
problems saving it, but then the time also appears even
when the format option is set to short date! Very
confusing.



Hope you can help.



Thanks



Adam

 

[Jeff Boyce]

Adam

The word "Date" is a reserved word in Access. Perhaps Access is confused by
your use of that word as the caption. What happens if you change the
caption to a more intention-revealing name, like "DatePicked"?

 

[Guest]

I just had the same problem, but by using

Input Mask: 99.99.9999
Default Value: =Now(

the date only will be displayed

Sissil

 

[dsfielding]

*I have linked tables in Access 2002 where the master table
has the default value in a date field set to '=date()'.
Today's date appears in this table, but not in the linked
table in another database (#NAME? appears). I've
refershed the link, but without it making any difference.
Can anyone shed some light on this?
Thanks
Adam *

The last time I experienced this it was because the References neede
to be updated. Someone had bound to the Microsoft Office 9.0 Objec
library and the Access database was now being used on a machine tha
didn't have that version of the Office library.

The only way I found to fix the references was to get into a Modul
either a standalone or in a Form's code. In the Visual Basic cod
editor click Tools - References. You might find that one of them i
checked and has the word "MISSING:" in front of it. That's the nast
bugger that the Date function used to be coming from and now it can'
be found. Scroll the list of choices and find either another versio
by the same name, or you might have to find a different Microsof
Object Libray altogher.


Davi


-
dsfieldin

 

[oceanpsy]

I was having the same exact problem.
I went into the visual basic editor. Went to the tools/references pag
and clicked the one marked "TIME". This fixed my problem


-
oceanps