Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Default Value in Table

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  Win.XP -Win.7 dual boot  
Author Message
Cora

External


Since: Feb 22, 2010
Posts: 1



(Msg. 1) Posted: Mon Feb 22, 2010 7:33 am
Post subject: Default Value in Table
Archived from groups: microsoft>public>access (more info?)

I need a default value in my table to be the date value of another field in
the table + 25 days. When I try to place this in the default value box, it
says there is a type mismatch.

="ANLDate" + 25

Both fields are short date format.

Any help is greatly appreciated.

 >> Stay informed about: Default Value in Table 
Back to top
Login to vote
KARL DEWEY

External


Since: Jan 22, 2009
Posts: 16



(Msg. 2) Posted: Mon Feb 22, 2010 7:54 am
Post subject: RE: Default Value in Table
Archived from groups: per prev. post (more info?)

When you use ="ANLDate" + 25 you are trying to add a number to a text string
and that don't work. It would be =[ANLDate] + 25 but that will not work as
the default is used when a new record is created and [ANLDate] is null upon
creation of a new record.

There is no reason to store the calculation as you can always do it in a
query or report.

 >> Stay informed about: Default Value in Table 
Back to top
Login to vote
Gina Whipp

External


Since: Dec 4, 2008
Posts: 34



(Msg. 3) Posted: Mon Feb 22, 2010 10:53 am
Post subject: Re: Default Value in Table
Archived from groups: per prev. post (more info?)

Cora,

What you are trying to do cannot be done at the table level. You will need
to do that on the form level. Is there any particular reason you are doing
this in a table?
 >> Stay informed about: Default Value in Table 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
setting a default year in a table with multiple years - I have a table that contains a list of fiscal years - like "2008-09". It also has a YearID field, and a IsCurrentYear field of type "Yes/No". As we enter a new year I want them to be able to specify a new current year. After some...

swap tables when more than one table is linked to primary .. - I am using office 2007 and have linked a few tables to my primary master table, and is working fine. Only problem is, that now I need to swap back to a previious table that is still linked to the primary table, and i cant seem to find any where on my...

Default editing language - The MS Office Language Settings work on all components (e.g. MS Excel, MS Word) but MS Access. I set the default edit language to English, however, it switches to Chinese every time when I open MS Access. My computer setting is English and is with bot...

picture buikder default icons lost??? - Dear all, I have a big problem on my pc. Using access 2003, I put a button on a form, in properties, I click on the .... near Picture property, and the available pictures list (icons) is empty. On same computer, access 2K, this list is OK. How do I..

Assign Default Filter In Access Form - Hi, I am Having a TABLE with USER ID,. DATE, PROCESS STATUS, TYPE & PERSON NAME like that, based on that I have created a FORM in design view with USER ID, DATE & PROCESS STATUS. USER ID is a TEXT BOX and i have assigned primary key for User...
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]