If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Friendly Report Names
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 |
#2
|
|||
|
|||
Friendly Report Names
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] |
#3
|
|||
|
|||
Friendly Report Names
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 "gchichester via AccessMonster.com" u46492@uwe wrote in message news:a8a2d00621643@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 |
#4
|
|||
|
|||
Friendly Report Names
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 "gchichester via AccessMonster.com" u46492@uwe wrote in message news:a8a2d00621643@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 |
#5
|
|||
|
|||
Friendly Report Names
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/For...ports/201005/1 |
Thread Tools | |
Display Modes | |
|
|