| 416-621-9348 cgreaves@chrisgreaves.com | .JPG) |
|---|---|
| Home Services Products |
Access is different
The Access Object Model, we are told, is “different” from Word, Excel and PowerPoint.
From time to time you will run across things that don’t make sense to you. It may be that the “Object Model is Different”, or it may just be that we don’t yet understand what’s going on.
Here is an example. Most times when we want to delete an item in a collection, we specify the item, then tap the period key and select Delete. With this you’d expect to be generating this:
dbs.TableDefs(strCourse).Delete
However in Access you need to produce this:
dbs.TableDefs.Delete strCourse
Go, as they say, Figure!
Loading
Toronto and Mississauga, Sunday, December 05, 2010 3:19 PM
Copyright © 1996-2010 Chris Greaves. All Rights Reserved.