Subcontractor Database

Resolved · High Priority · Version 2007

Mon 21 May 2012, 08:55 Delegate Sophie said...

Sophie has attended:
Access Introduction course
Access Intermediate course

Subcontractor Database

I am trying to create a form so that i can have a drop down box for trade description and then a second one for subcontractor, i want the subcontractor box to filter from the trade above, so if i select bricklayer from the trade description drop down, then only the bricklaying subcontractors are available for selection in the subcontractor drop down?

Mon 21 May 2012, 10:17 Trainer Anthony said...

RE: Subcontractor Database

Hi Sophie, thanks for your query. There's a template to do just that here:

http://blogs.office.com/b/microsoft-access/archive/2009/04/03/template-demonstrates-how-to-synchronize-combo-boxes.aspx

...but be warned, it is fiddly and involves either macros or VBA.

Hope this helps,

Anthony

Mon 28 May 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips