VBA Toolbox

[Yuta]

Hello,
This may be a very stupid question, but please understand it is from someone
who is reading 'VBA for Dummies'. In the book they describe the VBA Toolbox
that should be available to us. However the Toolbox is greyed out and
unavailable when in my VBA window. Can someone explain how I access the VBA
Toolbox using Access 2003.
Thank You

 

[Jack Leach]

I don't recall there being any toolbox other than one used in form/report
design (access ide, not vba).

For the record, of all the 'for dummies' books i've been through (better
than a dozen), there were only two that i didn't like. One of those two I
feel was a complete waste of money, and that one happens to be VBA for
Dummies. The only good use I've found for it is the datatype breakdown on
the inside cover for a quick reference. I would recommend the 7in1 Access
for dummies (to get aquainted with everything except vba), or the wrox Access
2003 VBA book for vba intensive stuff. Some of the wrox book is a bit
advanced for beginners but there's plenty for the novice to work from, and I
still refer to it years later. I hear the Access Cookbook is excellent as
well.

Sorry I don't know about a vba toolbox, but if you have the same book I have
there's far far better available IMHO.


--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[Yuta]

The Toolbox button is actually there in the VBA ide, it's just greyed out
and unavailable. This is at the beginning of the book & I'm already running
into "I don't see that on MY system" kinda stuff. Thanks for the other book
recommendations though.
Off topic, I'm primarily trying to learn about the syntax requirements and
so on...
I get confused about when/what is supposed to be in the parenthesis at the
beginning of the code.
i.e.
Public Function Whatever() or Public Function Whatever(strProcess As String)
and sometimes I see an actual value in there. Very confusing for the newbie.
Any books that give a definitive description would be very helpful.

Regards

 

[Tony Toews [MVP]]

I get confused about when/what is supposed to be in the parenthesis at the
beginning of the code.
i.e.
Public Function Whatever() or Public Function Whatever(strProcess As String)
and sometimes I see an actual value in there. Very confusing for the newbie.
Any books that give a definitive description would be very helpful.

Put your cursor over the "Function" and press F1. You will get some
help text which, admittedly, is quite dense and can be quite
incomprehensible.

The key lines, at least in A2003 help, are:

[Optional] [ByVal | ByRef] [ParamArray] varname[( )] [As type]
[= defaultvalue]

and

defaultvalue Optional. Any constant or constant expression. Valid for
Optional parameters only. If the type is an Object, an explicit
default value can only be Nothing.

So the actual value you see, presumably with an = (equal sign) just
before it is a default value only to be used if the parameter is
optional and not present in the calling line of code.

Tony

 

[Tony Toews [MVP]]

Off topic, I'm primarily trying to learn about the syntax requirements and
so on...
I get confused about when/what is supposed to be in the parenthesis at the
beginning of the code.

Also feel free to ask as many of these kinds of questions as you want.
We don't mind. That's why we like helping folks.

The way I look at it folks who answer questions have two main
functions. The obvious function is to give a decent quality answer.
The not so obvious function is to take your problem expressed in your
terminology and give you the answer back in the official terminology.
Basically a walking FAQ.

Tony