Friendly Report Names

  • Thread starter gchichester via AccessMonster.com
  • Start date
G

gchichester via AccessMonster.com

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
 
M

Marshall Barton

Steve said:
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 & """"
Click to expand...

Right, exept the code should be:

DoCmd.OpenReport Me!NameOfListBox
 
S

Steve

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
[email protected]
 
J

John Spencer

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
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
[email protected]
Click to expand...
 
G

gchichester via AccessMonster.com

You guys are Great!
Thanks to all for your prompt reply, This is exactly what I needed!

Regards
Gil
 
Top