A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Friendly Report Names



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 04:39 PM posted to microsoft.public.access.reports
gchichester via AccessMonster.com
external usenet poster
 
Posts: 12
Default 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  
Old May 27th, 2010, 04:48 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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  
Old May 27th, 2010, 05:05 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old May 27th, 2010, 05:23 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default 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  
Old May 27th, 2010, 07:43 PM posted to microsoft.public.access.reports
gchichester via AccessMonster.com
external usenet poster
 
Posts: 12
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.