database engine doesnt recognise field name

[Anth]

error message "the database engine does not recognise a field name in either
validation expression or the default value in table"
Tring to use DateAdd expression to set a default value by refering to Date()
in another fiedl form same table.

 

[Douglas J Steele]

Are you saying that you put a reference to another field in a field's
Default Value? I don't believe that's possible.

 

[Anth]

Really ? I thought the examples indicated that DateAdd("m",3,[fieldname1])
(where fieldname1's default value is Date() ) would work ok. Essentially,
I'm trying to add a 3 month default expiry date from the date of entry. Do
you know any way to work around it ?
Thnx
Anth.

 

[Douglas J Steele]

I believe you can do that in a form, but not in a table.

Of course, you shouldn't be entering data directly into tables anyhow:
that's what forms are for.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Really ? I thought the examples indicated that DateAdd("m",3,[fieldname1])
(where fieldname1's default value is Date() ) would work ok. Essentially,
I'm trying to add a 3 month default expiry date from the date of entry. Do
you know any way to work around it ?
Thnx
Anth.

Are you saying that you put a reference to another field in a field's
Default Value? I don't believe that's possible.

 

[Anth]

Ok, many thnx. Will do it that way.

I believe you can do that in a form, but not in a table.

Of course, you shouldn't be entering data directly into tables anyhow:
that's what forms are for.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Really ? I thought the examples indicated that DateAdd("m",3,[fieldname1])
(where fieldname1's default value is Date() ) would work ok. Essentially,
I'm trying to add a 3 month default expiry date from the date of entry. Do
you know any way to work around it ?
Thnx
Anth.

Are you saying that you put a reference to another field in a field's
Default Value? I don't believe that's possible.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


error message "the database engine does not recognise a field name in
either
validation expression or the default value in table"
Tring to use DateAdd expression to set a default value by refering to
Date()
in another fiedl form same table.