Thread
:
Friendly Report Names
View Single Post
#
3
May 27th, 2010, 05:05 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
Posts: 1,017
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
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]