PC Review


Reply
Thread Tools Rate Thread

Bound Date/Time field to automatically display the current date

 
 
Billiam
Guest
Posts: n/a
 
      20th Sep 2009
I have a bound form which has a field called WorkDate which I would like to
default to todays date...it also still needs to be able to be changed to a
different date. I have tried inserting =Date() in the On Load event of the
Bound Worked Date field, but no luck...the picker is still just sitting there
with nothing in the field.

Thank you for any help!
Best Regards,
Billiam
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      20th Sep 2009
Set the DefaultValue of the field in the table to Date.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Billiam" <(E-Mail Removed)> wrote in message
news6F53F87-B9C0-49BC-917E-(E-Mail Removed)...
>I have a bound form which has a field called WorkDate which I would like to
> default to todays date...it also still needs to be able to be changed to a
> different date. I have tried inserting =Date() in the On Load event of the
> Bound Worked Date field, but no luck...the picker is still just sitting
> there
> with nothing in the field.
>
> Thank you for any help!
> Best Regards,
> Billiam



 
Reply With Quote
 
Billiam
Guest
Posts: n/a
 
      20th Sep 2009
You are the MAN! Thank you, Doug. It's people like you that make the world
worthwhile! Have a wonderful day...
Billiam

"Douglas J. Steele" wrote:

> Set the DefaultValue of the field in the table to Date.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Billiam" <(E-Mail Removed)> wrote in message
> news6F53F87-B9C0-49BC-917E-(E-Mail Removed)...
> >I have a bound form which has a field called WorkDate which I would like to
> > default to todays date...it also still needs to be able to be changed to a
> > different date. I have tried inserting =Date() in the On Load event of the
> > Bound Worked Date field, but no luck...the picker is still just sitting
> > there
> > with nothing in the field.
> >
> > Thank you for any help!
> > Best Regards,
> > Billiam

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
click date/time field display calendar and validation of date /tim Smithskenpo Microsoft Outlook Form Programming 0 4th Mar 2010 08:20 PM
RE: Getting Date field to automatically input current date =?Utf-8?B?TWFydmlu?= Microsoft Access Form Coding 0 10th Dec 2005 03:34 AM
Getting Date field to automatically input current date Charlie Klein Microsoft Access Form Coding 0 11th Aug 2004 10:45 PM
Re: Getting Date field to automatically input current date Ken Snell Microsoft Access Form Coding 0 11th Aug 2004 07:29 PM
Re: Getting Date field to automatically input current date PC Datasheet Microsoft Access Form Coding 0 11th Aug 2004 07:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:41 AM.