Good Question for a MVP

[BrianPaul]

I finally got my 2nd or even 3rd wind as an IT professional. So you know
what its like to be burn out and then something perks your interest and you
back in the books again. Background: I have been using Access since 2.0 and
the developers toolkit back when. one evening I loading Visual basic 6.0 and
done some of the examples which helped me in access. Tom wa*** really helped
me understand modules and how to call functions in access. I have been
strugling writing code for about 2 years relying on this newsgroup to provide
the solution. Greatly appreciated by the way because I have had the biggest
case of the dumb etc concerning modules, functions. PS. took me over a year
just to learn the event properties.

Questions:
1. Is there a book that really breaks down the code in modules and gives
practical working examples.

2. Is VBA in access the same as Visual basic 6.0 or the new dot net

3. Is there a library in access that you can look up the built in functions
and what they do to help familiarize myselft with possible database solutions.

4. what is VBE Im thinking editor.

Thanks MVP's your help is greatly appreciated

 

[Tom Wickerath]

Brian,

There's a lot of people who contribute to this newsgroup on a regular basis,
who may not be MVP's, but are still perfectly capable of answering your
questions. So, I think you should be more inclusive of others.

1. Is there a book that really breaks down the code in modules and gives
practical working examples.

Everyone has their favorite books. I like Beginning Access 2000 VBA by David
Sussman and Robert Smith (Wrox). You should be able to find a used copy of
this book for $15. Make sure such a copy includes the CD that was originally
packaged with the book.

2. Is VBA in access the same as Visual basic 6.0 or the new dot net

VBA, or Visual Basic for Applications, is a subset of the full Visual Basic.
I believe that VB.Net is an entirely new beast.

3. Is there a library in access that you can look up the built in functions
and what they do to help familiarize myself with possible database solutions.

A couple of approaches. You can use the Object Browser, by clicking on View

Object Browser (or pressing F2) when you are in a code module. This allows

you to find built-in functions in libraries that are included in your list of
checked references.

You can also use the Help file in VBA. In Access 2003, click on:
Help > Visual Basic Help
Select "Microsoft Visual Basic Documentation"
Select "Visual Basic Language Reference"
Select "Functions"

Enjoy reading. Try out the samples along the way.

4. what is VBE I'm thinking editor.

Yep. VBE = Visual Basic Editor.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________