Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Buttons

	98.1 % recommend us
	More live stats...

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

Training information:

Buttons

Resolved · Low Priority · Version 2007

Reply Mon 23 Jun 2008, 16:15Delegate Fiona said...

Fiona has attended:
Access Introduction course

Buttons

Is it possible to insert buttons on forms that will bring up all information/records related to a particular ID?

For upcoming training course dates see: Pricing & availability

Reply Sun 6 Jul 2008, 19:45Delegate Mark said...

RE: Buttons

One way to do this is to add a combo box button on your form (from Tool Box in design mode) on your form. When you add the box to the form you will see 3 options. Select Find a Record on my Form Based on the Value I Select in my Combo Box. Then press Next and choose the field by which you wish to search (ID), and then go on to Finish. You can then go to form view to check the result. You should get a drop down showing 8 values in your chosen field and scroll bar if you have more than 8 in the list. I often prefer to see more than 8 list items at a time. To alter this go back to design view and double click on the combo box to call up properties (or you could right click and select properties). Go to the Format Tab and you will see List Rows about one third the way down which is usually on 8 and you can change this --try 30 or 40. You may need to see more about what records are behind the ID in order to know what to select, particularly (as often the case) if the ID is a number, then you can select to have two columns or more to show you what you are selecting but have the ID as the field for which related records are pulled.

If you are working with a form which shows one record on the screen at a time but with others on other pages, the above will call up the record relating to the ID you select in the combo box. If you have a sub form for to show the related set of

Reply Sun 6 Jul 2008, 19:47Delegate Mark said...

RE: Buttons

In the above reply I forgot to say, Hi Fiona and I hope this is what you needed, Regards, Mark

Access articles

· It's so easy to Access the information you need
· Be Top Of The Form With Access 2007
· Microsoft Access Training Opens Doors
· How To Create Calculated Fields In Access 2010 Tables
· So You Want To Create Forms In Access 2007?

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

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips