Exercises

team lib
  1. You can use the Immediate window to inspect the properties of data access objects. What line would you have to type in the lower pane of the immediate window to determine how many fields there are in the tblCountries table?

  2. See if you can use the Immediate window to determine how many properties each of the fields in the tblCountries table has. Why do some have more properties than others?

  3. Modify the MakeATable sub to automatically allow for the possibility that a version of tblCountries might already exist by deleting the old table before adding the new one instead of having to do this manually. HINT: you can use a For Each ... Next loop to scan through the collection of Tabledef s for a matching name and the Delete method of the collection to remove it if it does exist.

 
team lib


Beginning Access 2002 VBA
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
Year: 2003
Pages: 256

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net