Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

The Book

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Combo Box Report list - 28 Mar 2008 15:50 GMT
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 - 28 Mar 2008 17:12 GMT
http://www.viescas.com/Info/books.htm#Visual%20Basic

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.

Signature

Duane Hookom
Microsoft Access MVP

> Good day all,  
>    In Access 2007 there is a "Sales Pipeline" template which has a "Reports"
[quoted text clipped - 14 lines]
> SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like
> "*Subreport*") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name;
patti - 28 Mar 2008 20:10 GMT
thanks to all for the responses and explanations.

> http://www.viescas.com/Info/books.htm#Visual%20Basic
>
[quoted text clipped - 21 lines]
> > SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like
> > "*Subreport*") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name;
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.