C
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;
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;