View Single Post
  #6 (permalink)  
Old September 10th, 2003, 05:43 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi Sean,

For the values of MSysObjects.Type see:

http://www.perfectparadigm.com/Tip001.html

Mid([name],1,4) means "give me the first four characters of the object name starting at the first character." See the Mid Function in the helpful VBA help file which is accessed from the VBA editor menu (not the "unhelpful" Access help file which is accessed from the Access menu).

Quote:
quote:Bob, opened MSysObjects and see it all clear now.
Not sure what you're telling me here.

Bob


Reply With Quote