Access Forms

Resolved · Low Priority · Version 2003

Thu 10 Sep 2009, 14:33 Delegate Adam said...

Adam has attended:
Access Intermediate course
Excel VBA Intro Intermediate course

Access Forms

How do you make a combo box on a form control the whole form in such a way that it would bring up related fields to the contents of the combo box?

For example, i want to select the Names of people that work at my company from a combo box. I want this then to trigger all other fields that i choose, ie. age, address, job title etc.

Fri 11 Sep 2009, 11:13 Trainer Stephen said...

RE: Access Forms

Hi Adam

Thank you for your question

Create your combo box in the normal way by drawing it on the form. Make sure that control wizards are switched on (Magic Wand button on the control toolbox)

The wizard will ask you which type of combo box you want, and the third entry is to select a record based upon the combo box value. Select this and click next and then the wizard will guide you through the process, asking you to specify the key filed etc.

Regards

Stephen

Fri 18 Sep 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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