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 ------------------------ 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/
