Connecting Tech Pros Worldwide Forums | Help | Site Map

Good VBA for Access instruction book?

Member
 
Join Date: Feb 2007
Posts: 77
#1: Apr 9 '07
Hello Everyone,

I am trying to teach myself a little more about VBA for Access, can anyone recommend a good book for this. (At this point I've read Access VBA Programming for dummies, but I didn't find it very useful).

Thanks,

pks00's Avatar
Expert
 
Join Date: Oct 2006
Posts: 281
#2: Apr 11 '07

re: Good VBA for Access instruction book?


I dont know of any books, the only ones I like to read are those fantasy and ficton ones, but now dont even have time to read them!

anyways, here is a starting point - excellent site, hope this helps

http://www.functionx.com/vbaccess/index.htm
Member
 
Join Date: Feb 2007
Posts: 77
#3: Apr 11 '07

re: Good VBA for Access instruction book?


Quote:

Originally Posted by pks00

I dont know of any books, the only ones I like to read are those fantasy and ficton ones, but now dont even have time to read them!

anyways, here is a starting point - excellent site, hope this helps

http://www.functionx.com/vbaccess/index.htm

Thanks,

I have looked at this site before, and found it helpful, but I think I need more inforomation.
Rabbit's Avatar
Expert
 
Join Date: Jan 2007
Location: California
Posts: 3,835
#4: Apr 11 '07

re: Good VBA for Access instruction book?


The visual basic editor's help files are excellent. You can use the search function or if you highlight a word in the editor and press F1, it'll bring up articles and examples on how it is used.

One thing about events though it you have to highlight just the event name, not the whole sub name.

For example. To find out more about the After Update event of a text box called txtName, you would highlight AfterUpdate of Private Sub txtName_AfterUpdate() and press F1.
Member
 
Join Date: Feb 2007
Posts: 77
#5: Apr 20 '07

re: Good VBA for Access instruction book?


Quote:

Originally Posted by Rabbit

The visual basic editor's help files are excellent. You can use the search function or if you highlight a word in the editor and press F1, it'll bring up articles and examples on how it is used.

One thing about events though it you have to highlight just the event name, not the whole sub name.

For example. To find out more about the After Update event of a text box called txtName, you would highlight AfterUpdate of Private Sub txtName_AfterUpdate() and press F1.


Thanks Rabbit.
Reply