How To Show the Query Name Using a Function

Chuck Wood
Chuck Wood used Ask the Experts™
on
How can I include the query name in its output using a function similar to 1. I already know how to include the database name using the syntax in 2.
-Chuck
' 1
=QueryName()
' 2
=DbName()
' function
Public Function DbName()
    DbName = CurrentProject.Name
End Function

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
How about if

Author

Commented:
<How about if> what?
MIS Liason
Most Valuable Expert 2012
Commented:
Sorry, ...it was 5PM (Quittin' Time!)

Try this buddy:

;-)

Jeff
Access-EEQ-24635813-ListOpenObje.mdb

Author

Commented:
Excellent! Thank you very much.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
It is always a honor to be able to help another Expert.

...and thank you for an interesting and thought provoking question!
;-)

Jeff

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial