access class microsoft training - Date data entry

The UK's most regular instructor-led training courses.
Training information: access class microsoft training · Microsoft access courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Date data entry

Jenny has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Jenny [6 posts] (2007 Jul 20 Fri, 09:51) Reply

When you have a date field how do you get a pop up calender to select the date to automatically input in the field.

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 21 Thu	Bloomsbury	0	FULL
2003/XP	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003/XP	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2003/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003/XP	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
Full Schedule: See all 74 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Date data entry

by - trainer Richard platinum contributer [779 posts] (2007 Jul 20 Fri, 10:39) Reply

Good question. In Access 2007 they have actually added that as default functionality of a date field.

In previous versions, you will need to be able to use VBA to add that functionality.

RE: Date data entry

by - delegate Jenny [6 posts] (2007 Jul 20 Fri, 13:56) Reply

Is this covered in your VBA course?

RE: Date data entry

by - trainer Richard platinum contributer [779 posts] (2007 Jul 26 Thu, 15:50) Reply

Not specifically as far as I know

· Microsoft Access Mistakes to Avoid
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Tips for designing databases in Microsoft Access
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips