473,326 Members | 2,815 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

get sub proceedure name

For reasons of neat and tidiness in code can anyone tell me how to get the
name of a running sub from the title of the sub and from within itself as it
is executing?

Thanks hopefully

Andrew
Mar 4 '07 #1
3 1405
Andrew Hall wrote:
For reasons of neat and tidiness in code can anyone tell me how to
get the name of a running sub from the title of the sub and from
within itself as it is executing?

Thanks hopefully

Andrew
Fairly common request. You can't.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Mar 4 '07 #2
"Andrew Hall" <an**********@virgin.netwrote
For reasons of neat and tidiness in code can
anyone tell me how to get the name of a running
sub from the title of the sub and from within
itself as it is executing?
Both the free "mztools" from http://www.mztools.com and FMS's product, Code
Tools, http://www.fmsinc.com, have the capability to pick up a procedure's
name at compile time... you could store it in a variable. Both also have the
option of generating comments and code (normally used for error-handling) at
the click of an icon. AFAIK, the name of the sub is not available from the
system at execution-time.

There are some other similar products... and were more, but at least two
free products were discontinued by their authors in support of "mztools".

Larry Linson
Microsoft Access MVP
Mar 4 '07 #3
Thanks for your help

Andrew

"Andrew Hall" <an**********@virgin.netwrote in message
news:UC******************@newsfe2-win.ntli.net...
For reasons of neat and tidiness in code can anyone tell me how to get the
name of a running sub from the title of the sub and from within itself as
it
is executing?

Thanks hopefully

Andrew


Mar 4 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: John Webb | last post by:
Hope someone can help. I am trying to write a stored proceedure to display sales activity by month and then sum all the columbs. The problem is that our sales year starts in April and end in...
0
by: BobC | last post by:
One of Microsoft's VB code samples is a solution called Logger (or WinLogger). It has a file associated with the "Logging" project called ILog.vb. In the module, interface or whatever it's called...
1
by: Melissa Meyer via SQLMonster.com | last post by:
How do you set a stored proceedure for automatic execution? -- Message posted via http://www.sqlmonster.com
0
by: pmclinn | last post by:
In the .net designer wrote a proceedure named 'Fireitup'. How do I call on this proceedure from client javascript.
2
by: Problematic coder | last post by:
I have a form based application that inputs values into various oracle tables, after it has done this I want to call a stored proceedure in Oracle which is already written to do more work on this...
9
by: Problematic coder | last post by:
The intention is to call a stored proceedure which sets flags in the database, this requires no parameters and the page does not need an output from the stored proceedure, though is this is...
0
by: ig.martix | last post by:
I'm a bit new to asp. What I'm looking to doing is having three input boxes on a page. As an example I would like for the user to input a employee ID in the first input box and then wither...
4
by: Mick Walker | last post by:
Hi Everyone, I am stumped here. I have the following stored proceedure:P CREATE PROCEDURE . @SupplierSKU varchar(50), @RetVal int AS Select @Retval = count(*) from dbo.ImportLines Where =...
8
by: jthep | last post by:
Is there a way to create a stored procedure where more than one type of parameter can be entered? For example, a user can enter a int type, char(4) type, or nothing in the same stored proceedure.
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.