You can run a query to list reports, and can then use that in a listbox. This query will pull up only reports:
SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=-32764)); MSysObjects is a hidden system table. If you keep to a standard report name prefix, i.e. rptMyReport, with a different one for subreports, then you can pull up just the actual reports for the list: SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=-32764) AND ((Left([Name],3))="rpt")); Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Trent Johnsey Sent: Monday, October 31, 2005 12:07 PM To: [email protected] Subject: RE: [AccessDevelopers] Re: Queries in combo boxes I don't disagree with this philosophy either. Command buttons are the best way to do it, but adding reports on the fly is much tougher. --- "Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> wrote: > Any time you expect people to type something like that exactly right, > they won't! You need to provide a way to select a report that doesn't > make them have to enter it, either by creating a command button to > bring up a report or a listbox, or set of radio buttons with one > button for each report, with a button to launch the selected report. > But don't expect them to type in a name and get it right! > > Tobi > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Trent Johnsey > Sent: Monday, October 31, 2005 12:01 PM > To: [email protected] > Subject: Re: [AccessDevelopers] Re: Queries in combo boxes > > > The folks are typing in the report name i.e. "Employee Time" which is > on the same record where 'rptEmployeeTime' exists. rptEmployeeTime is > the exact name of the report object which is called via code. > > table structure > Field Field Value > ReportDesc Employee Time > ReportName rptEmployeeTime > ReportStatus (true/false) (active or not active report) > > TJ > > --- scubafish00 <[EMAIL PROTECTED]> wrote: > > > Are you having people type in the name of the report they want or > > are they selecting from a list? > > > > --- In [email protected], Trent Johnsey <[EMAIL PROTECTED]> > > wrote: > > > > > > We have a table with report names ("Report Name") as well as the > > actual report > > > name (rptReportName) listed in the mdb. When a user enters the > > report they > > > want to run, the system calls the corresponding report name from > > the actual > > > report name field in the table. > > > > > > Clear as mud? > > > TJ > > > > > > --- scubafish00 <[EMAIL PROTECTED]> wrote: > > > > > > > Good morning, > > > > Does anyone know if it's possible to have a combo box with > > queries or > > > > reports listed? If so, can you offer instructions? > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > Yahoo! Mail - PC Magazine Editors' Choice 2005 > > > http://mail.yahoo.com > > > > > > > > > > > > > > > > > > __________________________________ > Yahoo! FareChase: Search multiple travel sites in one click. > http://farechase.yahoo.com > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > > __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
