By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Can I use VB to dump all my global vars & values to the immediate window w/o typing them all individually?

P: n/a
MLH
Can I use Access Basic to dump global var's & values
to immediate window in Access 2.0?

Can I use it in Access 97 to do the same thing?

And please, I can obviously run the following...

Debug.Print "MyGlobalVar = "; MyGlobalVar

.... that's not what I'm looking for here. I wanna do
it without explicitly typing them all in code.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
There's no way that I'm aware of.

Why not create a sub that does it for you, so that you can simply type the
sub's name and everything will be typed out. Yes, you'd need to type the
multiple "Debug.Print" statements into that sub yourself, but you'd only
have to do it once.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MLH" <CR**@NorthState.net> wrote in message
news:n1********************************@4ax.com...
Can I use Access Basic to dump global var's & values
to immediate window in Access 2.0?

Can I use it in Access 97 to do the same thing?

And please, I can obviously run the following...

Debug.Print "MyGlobalVar = "; MyGlobalVar

... that's not what I'm looking for here. I wanna do
it without explicitly typing them all in code.

Nov 13 '05 #2

P: n/a
MLH <CR**@NorthState.net> wrote in message news:<n1********************************@4ax.com>. ..
Can I use Access Basic to dump global var's & values
to immediate window in Access 2.0?

Can I use it in Access 97 to do the same thing?

And please, I can obviously run the following...

Debug.Print "MyGlobalVar = "; MyGlobalVar

... that's not what I'm looking for here. I wanna do
it without explicitly typing them all in code.


AFAIK, no, you can't treat global variables like a collection, e.g., like this:

Dim tdf as tabledef

for each tdf in db.tabledefs
debug.print tdf.name
next tdf

well, unless you created a collection and *added* them it...
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.