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

Visual Basic Command Reference Information

P: n/a
I am learning Visual Basic as I go, and many times I run across a
command I would like to reference.

Can anyone tell me how I can open the VBA Help Reference portion of
Access directly, without opening access first? Currently I find I have
to open an mdb, then a form or report, then click on the builder, to get
into VBA, then I can access the help to lookup the command info, which
is very combersome.

Alternately, is there a source or site online which you can reccomend
which offers a VBA command reference VBA 6 would be nice) which can be
searched easily, or perhaps even a downloadable version which I can have
locally?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
15 Replies


P: n/a
TC
The VBA help is in a seperate .HLP file.

I don't have Access on this PC, and I can't quite remember the filename. The
VBA help files are usually named like VBAxx.HLP, eg. VBAWRD.HLP (?) for
Word. The Access one will be similar. Use start : find, you'll easily find
it.

Then create a desktop shortcut to that file. When you double-click that
shortcut, the help file will be displayed, independent of Access.

HTH,
TC
"BlackFireNova" <BF*****************@myrealbox.com> wrote in message
news:3f*********************@news.frii.net...
I am learning Visual Basic as I go, and many times I run across a
command I would like to reference.

Can anyone tell me how I can open the VBA Help Reference portion of
Access directly, without opening access first? Currently I find I have
to open an mdb, then a form or report, then click on the builder, to get
into VBA, then I can access the help to lookup the command info, which
is very combersome.

Alternately, is there a source or site online which you can reccomend
which offers a VBA command reference VBA 6 would be nice) which can be
searched easily, or perhaps even a downloadable version which I can have
locally?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

P: n/a
Uhh, I think a lot of the help files are .CHM files. There are tons of
them. You can create shortcuts to them, or just double click them.
"TC" <a@b.c.d> wrote in message news:1067228932.362053@teuthos...
The VBA help is in a seperate .HLP file.

I don't have Access on this PC, and I can't quite remember the filename. The VBA help files are usually named like VBAxx.HLP, eg. VBAWRD.HLP (?) for
Word. The Access one will be similar. Use start : find, you'll easily find
it.

Then create a desktop shortcut to that file. When you double-click that
shortcut, the help file will be displayed, independent of Access.

HTH,
TC
"BlackFireNova" <BF*****************@myrealbox.com> wrote in message
news:3f*********************@news.frii.net...
I am learning Visual Basic as I go, and many times I run across a
command I would like to reference.

Can anyone tell me how I can open the VBA Help Reference portion of
Access directly, without opening access first? Currently I find I have
to open an mdb, then a form or report, then click on the builder, to get
into VBA, then I can access the help to lookup the command info, which
is very combersome.

Alternately, is there a source or site online which you can reccomend
which offers a VBA command reference VBA 6 would be nice) which can be
searched easily, or perhaps even a downloadable version which I can have
locally?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #3

P: n/a
TC
Good point! But not with win98/a97 :-)

TC
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:zz********************@newssvr28.news.prodigy .com...
Uhh, I think a lot of the help files are .CHM files. There are tons of
them. You can create shortcuts to them, or just double click them.
"TC" <a@b.c.d> wrote in message news:1067228932.362053@teuthos...
The VBA help is in a seperate .HLP file.

I don't have Access on this PC, and I can't quite remember the filename.

The
VBA help files are usually named like VBAxx.HLP, eg. VBAWRD.HLP (?) for
Word. The Access one will be similar. Use start : find, you'll easily find it.

Then create a desktop shortcut to that file. When you double-click that
shortcut, the help file will be displayed, independent of Access.

HTH,
TC
"BlackFireNova" <BF*****************@myrealbox.com> wrote in message
news:3f*********************@news.frii.net...
I am learning Visual Basic as I go, and many times I run across a
command I would like to reference.

Can anyone tell me how I can open the VBA Help Reference portion of
Access directly, without opening access first? Currently I find I have to open an mdb, then a form or report, then click on the builder, to get into VBA, then I can access the help to lookup the command info, which
is very combersome.

Alternately, is there a source or site online which you can reccomend
which offers a VBA command reference VBA 6 would be nice) which can be
searched easily, or perhaps even a downloadable version which I can have locally?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Nov 12 '05 #4

P: n/a
I've already tried looking for .HLP files, and could find nothing that
came up as Access VBA Help, either directly, or by just trying the ones
that came up.

I've searched for .CHM files (as another reccomended, and there are,
indeed, hundreds of them. The trouble is finding the right one. I've
tried all the obvious ones, any one with Access as part of the name. I
see nothing with VB or VBA or Access VBA as part of the name.

Anyone know the actual file name (s) by any chance??

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #5

P: n/a
Perhaps if you used Alt+F11 from the 'normal' access window you could get
into the VBA editor rather more speedily?

"BlackFireNova" <BF*****************@myrealbox.com> wrote in message
news:3f*********************@news.frii.net...
I am learning Visual Basic as I go, and many times I run across a
command I would like to reference.

Can anyone tell me how I can open the VBA Help Reference portion of
Access directly, without opening access first? Currently I find I have
to open an mdb, then a form or report, then click on the builder, to get
into VBA, then I can access the help to lookup the command info, which
is very combersome.

Alternately, is there a source or site online which you can reccomend
which offers a VBA command reference VBA 6 would be nice) which can be
searched easily, or perhaps even a downloadable version which I can have
locally?

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #6

P: n/a
BlackFireNova <BF*****************@myrealbox.com> wrote in
news:3f*********************@news.frii.net:
I've already tried looking for .HLP files, and could find
nothing that came up as Access VBA Help, either directly, or
by just trying the ones that came up.

I've searched for .CHM files (as another reccomended, and
there are, indeed, hundreds of them. The trouble is finding
the right one. I've tried all the obvious ones, any one with
Access as part of the name. I see nothing with VB or VBA or
Access VBA as part of the name.

Anyone know the actual file name (s) by any chance??
(I'm using Access 97 on Windows 98.)
"C:\Program Files\Microsoft Office\Office\ACVBA80.HLP"

And it was very easy to create a shortcut for it.

Bob Q
BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #7

P: n/a
TC
If you only have CHMs, not HLPs, try doing a Start : Find search of all CHMs
containing the text "tabledef" (without the quotes), or some other similar
VBA term.

Of course, the CHMs will not be simple ASCII files. But hopefully, there
might be at least some ASCII text inside them. Try opening one with Notepad
& see if there is anything readable. If there *is*, my suggestion will
probably work. If there *isn't*, it won't!

HTH,
TC
"BlackFireNova" <BF*****************@myrealbox.com> wrote in message
news:3f*********************@news.frii.net...
I've already tried looking for .HLP files, and could find nothing that
came up as Access VBA Help, either directly, or by just trying the ones
that came up.

I've searched for .CHM files (as another reccomended, and there are,
indeed, hundreds of them. The trouble is finding the right one. I've
tried all the obvious ones, any one with Access as part of the name. I
see nothing with VB or VBA or Access VBA as part of the name.

Anyone know the actual file name (s) by any chance??

BlackFireNova

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #8

P: n/a
TC

"Bob Quintal" <bq******@generation.net> wrote in message
news:07******************************@news.teranew s.com...
BlackFireNova <BF*****************@myrealbox.com> wrote in
news:3f*********************@news.frii.net:
I've already tried looking for .HLP files, and could find
nothing that came up as Access VBA Help, either directly, or
by just trying the ones that came up.

I've searched for .CHM files (as another reccomended, and
there are, indeed, hundreds of them. The trouble is finding
the right one. I've tried all the obvious ones, any one with
Access as part of the name. I see nothing with VB or VBA or
Access VBA as part of the name.

Anyone know the actual file name (s) by any chance??


(I'm using Access 97 on Windows 98.)
"C:\Program Files\Microsoft Office\Office\ACVBA80.HLP"

And it was very easy to create a shortcut for it.

It's a neat technique, isn't it. I use it when I'm automating other Office
programs (eg. Word) from Access. Then I can quickly check the other
program's Help, without having to start that other program up.

TC

Nov 12 '05 #9

P: n/a
"TC" <a@b.c.d> wrote in news:1067394933.602315@teuthos:
If you only have CHMs, not HLPs, try doing a Start : Find search of all
CHMs containing the text "tabledef" (without the quotes), or some other
similar VBA term.


TableDef = VBA Term???????????????????

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #10

P: n/a
BlackFireNova <BF*****************@myrealbox.com> wrote in news:3f9ed93b$0
$1***********@news.frii.net:
I've searched for .CHM files (as another reccomended, and there are,
indeed, hundreds of them. The trouble is finding the right one. I've
tried all the obvious ones, any one with Access as part of the name. I
see nothing with VB or VBA or Access VBA as part of the name.


You might try searching for *vb*.chm

For AccessXP one could find:

VBAAC10.CHM

which may or may not contain the information you want.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #11

P: n/a
TC

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn******************@130.133.1.4...
"TC" <a@b.c.d> wrote in news:1067394933.602315@teuthos:
If you only have CHMs, not HLPs, try doing a Start : Find search of all
CHMs containing the text "tabledef" (without the quotes), or some other
similar VBA term.


TableDef = VBA Term???????????????????

Well, he is looking for Access VBA help (from what I remember of the
original post), so that terms seems as good as any!

TC

Nov 12 '05 #12

P: n/a

"TC" <a@b.c.d> wrote in message news:1067400381.179213@teuthos...

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn******************@130.133.1.4...
"TC" <a@b.c.d> wrote in news:1067394933.602315@teuthos:
If you only have CHMs, not HLPs, try doing a Start : Find search of all CHMs containing the text "tabledef" (without the quotes), or some other similar VBA term.


TableDef = VBA Term???????????????????

Well, he is looking for Access VBA help (from what I remember of the
original post), so that terms seems as good as any!

TC


Perhaps Lyle's point was that TableDef is DAO specific, so, perhaps not the
best search term.

Nov 12 '05 #13

P: n/a
TC

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:%H********************@newssvr28.news.prodigy .com...

"TC" <a@b.c.d> wrote in message news:1067400381.179213@teuthos...

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn******************@130.133.1.4...
"TC" <a@b.c.d> wrote in news:1067394933.602315@teuthos:

> If you only have CHMs, not HLPs, try doing a Start : Find search of all > CHMs containing the text "tabledef" (without the quotes), or some other > similar VBA term.

TableDef = VBA Term???????????????????

Well, he is looking for Access VBA help (from what I remember of the
original post), so that terms seems as good as any!

TC


Perhaps Lyle's point was that TableDef is DAO specific, so, perhaps not

the best search term.

Ok! I thought that was his point, but I discounted it's significance. I'd
forgotten the DAO/ADO thing, so I thought that he was saying: "TableDef is
not VBA!" I thought to myself: "who cares, in this context?". But now I see
he was actually saying, "TableDef does not find ADO!"

TC

Nov 12 '05 #14

P: n/a
"TC" <a@b.c.d> wrote in news:1067405144.148345@teuthos:

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:%H********************@newssvr28.news.prodigy .com...

"TC" <a@b.c.d> wrote in message news:1067400381.179213@teuthos...
>
> "Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
> news:Xn******************@130.133.1.4...
> > "TC" <a@b.c.d> wrote in news:1067394933.602315@teuthos:
> >
> > > If you only have CHMs, not HLPs, try doing a Start : Find search
> > > of

all
> > > CHMs containing the text "tabledef" (without the quotes), or some

other
> > > similar VBA term.
> >
> > TableDef = VBA Term???????????????????
>
>
> Well, he is looking for Access VBA help (from what I remember of the
> original post), so that terms seems as good as any!
>
> TC


Perhaps Lyle's point was that TableDef is DAO specific, so, perhaps not

the
best search term.

Ok! I thought that was his point, but I discounted it's significance.
I'd forgotten the DAO/ADO thing, so I thought that he was saying:
"TableDef is not VBA!" I thought to myself: "who cares, in this
context?". But now I see he was actually saying, "TableDef does not find
ADO!"


I think neither of us knows what I was actually saying.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #15

P: n/a
TC

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn******************@130.133.1.4...

(snip)
I think neither of us knows what I was actually saying.


That could well be true on both counts!

TC

Nov 12 '05 #16

This discussion thread is closed

Replies have been disabled for this discussion.