Friendly Report Names
in [Reports]
|
Prev: Deleting page headers on pages w/o records
Next: Reference controls on a dialogue form as the parameters
From: gchichester via AccessMonster.com on 27 May 2010 11:39 I have 40+ reports with somewhat critic names that would confuse my users, Is there a way to assign a alias/friendly name to the reports and use it to call the report from a listbox? Thank you for any and all suggestions Gil -- Message posted via http://www.accessmonster.com
From: Steve on 27 May 2010 12:05 Build a table of report names: TblReportName CryticName UserFriendlyName Make this table the Rowsource of your listbox. Set the Bound Column = 1, Column Count = 2 and Column Width = 0, 3. The listbox will display the user friendly names but the selected report will return the cryptic name. Put the following code in the AfterUpdate event of the listbox: DoCmd.OpemReport """" & Me!NameOfListBox & """" Steve santus(a)penn.com "gchichester via AccessMonster.com" <u46492(a)uwe> wrote in message news:a8a2d00621643(a)uwe... >I have 40+ reports with somewhat critic names that would confuse my users, >Is > there a way to assign > a alias/friendly name to the reports and use it to call the report from a > listbox? > > Thank you for any and all suggestions > Gil > > -- > Message posted via http://www.accessmonster.com >
From: John Spencer on 27 May 2010 12:23 Whoops. Small typo OpenReport not OpemReport. Also the quote marks are not needed and will lead to an error when Access looks for a report named "MyCrypticReportName" (including the quote marks)instead of MyCrypticReportName with no extraneous quote marks. To immediately print the report DoCmd.OpenReport Me.[NameOfListbox], acViewNormal or to open the report in preview mode DoCmd.OpenReport Me.[NameOfListbox], acViewPreview John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Steve wrote: > Build a table of report names: > TblReportName > CryticName > UserFriendlyName > > Make this table the Rowsource of your listbox. Set the Bound Column = 1, > Column Count = 2 and Column Width = 0, 3. The listbox will display the user > friendly names but the selected report will return the cryptic name. Put the > following code in the AfterUpdate event of the listbox: > DoCmd.OpemReport """" & Me!NameOfListBox & """" > > Steve > santus(a)penn.com > > > "gchichester via AccessMonster.com" <u46492(a)uwe> wrote in message > news:a8a2d00621643(a)uwe... >> I have 40+ reports with somewhat critic names that would confuse my users, >> Is >> there a way to assign >> a alias/friendly name to the reports and use it to call the report from a >> listbox? >> >> Thank you for any and all suggestions >> Gil >> >> -- >> Message posted via http://www.accessmonster.com >> > >
From: Marshall Barton on 27 May 2010 11:48 Steve wrote: >Build a table of report names: >TblReportName >CryticName >UserFriendlyName > >Make this table the Rowsource of your listbox. Set the Bound Column = 1, >Column Count = 2 and Column Width = 0, 3. The listbox will display the user >friendly names but the selected report will return the cryptic name. Put the >following code in the AfterUpdate event of the listbox: >DoCmd.OpemReport """" & Me!NameOfListBox & """" > Right, exept the code should be: DoCmd.OpenReport Me!NameOfListBox -- Marsh MVP [MS Access]
From: gchichester via AccessMonster.com on 27 May 2010 14:43
You guys are Great! Thanks to all for your prompt reply, This is exactly what I needed! Regards Gil -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1 |