The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Auto date

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Auto date

Resolved · Urgent Priority · Version 2003

ReplyThu 28 Aug 2008, 12:59Delegate Adam said...

Auto date

I am working on a project which requires an issue date and a review date.
Currently the user would have to input both dates manually, but since they could easily make a mistake, and as the review date is always 2 years after the issue date is there a formula I can use to allow access to do this automatically.

Here is an example how the date is set up on the form:

Issue Date: 28/08/2008
Review Date: 28/08/2010

your help is much appreciated.

For upcoming training course dates see: Pricing & availability

ReplyFri 29 Aug 2008, 09:54Trainer Stephen said...

RE: Auto date

Hi Adam

Thank you for your question

I am assuming that you are entering data through a form. If this is the case then you can attatch a dateadd function as the default value of the review date text box.

Bring your form up in design view and select the text box that displays the review date. Then open the properties dialog and go to the data tab

In the Default property type the following

=DateAdd("yyyy",2,[IssueDate])

This is the date add function

yyyy specifies that you are adding years to the date
2 specifies the number of years
[Issue Date] is the field that you are increasing

Hope this helps

Regards

Stephen

Access articles

· Use Split Form View In Access For Simultaneous Views
· Get More Out of MS Access Courses
· Take an Access Course to Learn About Relational Databases
· MS Access can promote teamwork
· Find Microsoft Access Templates For Any Task

Please browse our web site to find out more about
access course london and other Microsoft training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

How do you lock and protect cells

» Forum post: Locking cells

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions