By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Code to append dtpicker 3 date to a table??

P: 1
I'm creating a simple form in Access, and I've added a couple of drop-down calendars, but I don't know how to have the user-selected date append to the table with the rest of the form data.

I'm guessing I need to select "Code Builder" after selecting Event Procedure (On Exit) on the Event tab. Does anyone know the VB code necessary to append the date to the table?? Or is there a different way to get this done?

Any help is GREATLY appreciated. I can find nothing in Google about this.

Thanks!!!
May 15 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,619
I'm creating a simple form in Access, and I've added a couple of drop-down calendars, but I don't know how to have the user-selected date append to the table with the rest of the form data.

I'm guessing I need to select "Code Builder" after selecting Event Procedure (On Exit) on the Event tab. Does anyone know the VB code necessary to append the date to the table?? Or is there a different way to get this done?

Any help is GREATLY appreciated. I can find nothing in Google about this.

Thanks!!!
Not a single line of code is necessary since the Microsoft Date and Time Picker Control is Data Aware. Simple set the Control Source of the Control to your Date Field. These Date values will automatically de displayed for existing Records, and any new entries will automatically be saved to the underlying Table for New Records.
May 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.