A default is exactly that. It's just what will be inserted
if you do not specify a value.
Fred
----- Original Message -----
From: "WL" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 07, 2000 3:28 PM
Subject: Re: Changing default date in Access Database
> Cool thanks guys. One other question - if I need to
dynamically change the
> entry of this for one instance, can I do this? So is it
possible for me to
> override the default 30 days and change it to 15,60 or
90 - or can't the
> default be over-ridden?
>
> Thanks,
>
> Will
> Lukrative Media Ltd - Berkshire, UK
> ----- Original Message -----
> From: "Fred T. Sanders" <[EMAIL PROTECTED]>
> Newsgroups: cf-talk
> Sent: Sunday, May 07, 2000 9:25 PM
> Subject: Re: Changing default date in Access Database
>
>
> > yes you said that already in a previous post. He'll use
> > your way if he needs exactly 30 days from the time its
> > entered he'll use my way if he really meant that he
needs
> > the date to be exactly one month away from the date
entered.
> > Both answers are right in their own way. Chill
> >
> > ----- Original Message -----
> > From: "Howie Hamlin" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, May 07, 2000 3:13 PM
> > Subject: Re: Changing default date in Access Database
> >
> >
> > > That will only work if the month has 30 days.
Otherwise
> > you would use
> > > DateAdd("d",30,Now())
> > >
> > > Howie
> > >
> > > ----- Original Message -----
> > > From: Fred T. Sanders <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Sunday, May 07, 2000 4:04 PM
> > > Subject: Re: Changing default date in Access Database
> > >
> > >
> > > > In the default value on the database for your
date/time
> > > > field change from now() to
> > > >
> > > > DateAdd("m",1,Now())
> > > >
> > > > ----- Original Message -----
> > > > From: "WL" <[EMAIL PROTECTED]>
> > > > To: "Cold Fusion Talk" <[EMAIL PROTECTED]>
> > > > Sent: Sunday, May 07, 2000 2:36 PM
> > > > Subject: Changing default date in Access Database
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > > I need to change the default for a date field - at
the
> > > > moment it
> > > > > automatically enters todays' date, but I need it
to
> > enter
> > > > 30 days ahead of
> > > > > todays date. Can this be done in Access?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Will
> > > > >
> > >
> > >
> >
> ----------------------------------------------------------
> > --------------------
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
> > sts/cf_talk or send a message to
> > [EMAIL PROTECTED] with 'unsubscribe' in
the
> > body.
> >
>
> ----------------------------------------------------------
----------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or
> send a message to [EMAIL PROTECTED] with
'unsubscribe' in
> the body.
>
> ----------------------------------------------------------
--------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
