a VBA reference (learning) question

  • Thread starter Thread starter Brian Bastl
  • Start date Start date
B

Brian Bastl

Martin Lee,

Don't know if it is in Access Help, but it is in VBA Help (at least in A2K).
Open database and hit Alt+F11 and then hit F1. Click the 'Index' tab and
type Day without the () in the Key words text box.

Brian
 
Martin (Martin Lee) said:
I found here a lot of tops can answer my questions about VBA sentence
quickly. I am wondering whether you guys :) have some handbook or
internet information to be your VBA reference ??? If so, please tell
me how to find this VBA reference sources. Thank you. :>

I have tried to use ACCESS HELP, but it is really hard to find the
reference to the VBA. For example, today I want to find some example
about the Day() usage, before, I thought this reference should be in
ACCESS HELP, but to my surprise, I can't find them (maybe hard to
find them) in ACCESS HELP.
Click to expand...

One important thing to know is that you can only search the VBA help
from the VB Editor. So if you have a question about a VBA property or
an Access programming object, the easiest way to find the relevant help
topic is to switch to the VBA Editor and either (a) type the name on a
module, or (b) type the name into the Immediate Window, and then
position the text caret in or beside that word and press F1.

As for reference books, there are several that have been recommended in
the past, and a search of Google Groups will probably find these
recommendations. I learned mostly by reading the Access help, topic by
topic. The information is there, even though it isn't very easy to
search.
 
There are some MSDN articles which help, but not many, and you need to be a
subscriber to MSDN to get the entire library. Your best bet may be one of
the Access Developer's Handbook series by Ken Getz, et. al.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
I often use the VBScript reference on MSDN. It's not a 100% match on VBA,
but close enough to be helpful many times.

HTH;

Amy
 
I found here a lot of tops can answer my questions about VBA sentence
quickly. I am wondering whether you guys :) have some handbook or internet
information to be your VBA reference ??? If so, please tell me how to find
this VBA reference sources. Thank you. :>

I have tried to use ACCESS HELP, but it is really hard to find the reference
to the VBA. For example, today I want to find some example about the Day()
usage, before, I thought this reference should be in ACCESS HELP, but to my
surprise, I can't find them (maybe hard to find them) in ACCESS HELP.


Martin ( Martin Lee)
 
Yes, I really think that Access F1 is very hard to search. Has it any MSDN
for the Access?

Because I remembered before, when I use EXCEL and VB, I establish MSDN, and
it seem that MSDN also have some examples for the VBA. Is it?

Martin ( Martin Lee)
 
Back
Top