References

Resolved · Low Priority · Version 2007

Wed 21 Sep 2011, 16:29 Delegate Lee said...

Lee has attended:
Access VBA course

References

How can references be set programatically to ensure that a database works on another machine.

Wed 28 Sep 2011, 12:52 Trainer Anthony said...

RE: References

Hi Lee, thanks for your query. This link should give you what you need:

http://wiki.lessthandot.com/index.php/Add ,_Remove,_Check_References

Hope this helps,

Anthony

Wed 28 Sep 2011, 15:20 Delegate Lee said...

RE: References

Thanks Anthony. I'll give that a try

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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