The Book

[Combo Box Report list]

Good day all,
In Access 2007 there is a "Sales Pipeline" template which has a "Reports"
combo box that lists all of the reports in that database. After looking in
the design view of this combo box, it showed that it uses something called
"MSysObjects" and the code associated with it (see below).

I'm interested in learning how to write code like this for Access,
however, I have absolutely NO programming experience and only one recent
college semester's worth of learning the MS Office products. I'm looking for
a book somewhere between a beginner and intermediate level; something that
can teach me how to write code and explains "MSysObjects" and Macro, etc. So
If you have a book in mind - remember no programmer's experince - please
enlighten me.

Which book can teach me to write code like this?

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like
"*Subreport*") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name;

 

[Duane Hookom]

http://www.viescas.com/Info/books.htm#Visual Basic

I don't use the msysobjects table for something like this since it isn't
supported by MS. Also, my report names are not for public consumption. Take
the time to create a table of reports which allows much greater flexibility
and functionality.

 

[patti]

thanks to all for the responses and explanations.