"...if you do not specify a value." Of course - so I could just as easily
enter in DateAdd("d",'#form.days#',Now()) or something to specify no of
days, yes?
Will
Lukrative Media Ltd - Berkshire, UK
----- Original Message -----
From: "Fred T. Sanders" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 07, 2000 9:36 PM
Subject: Re: Changing default date in Access Database
> 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.
>
------------------------------------------------------------------------------
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.
