Web Resources for Macros

  • Thread starter Thread starter Wendy L
  • Start date Start date
W

Wendy L

Hey guys, are there any nifty little websites for guidance on dealing with
macros? I'm accustomed to working in a spreadsheet environment and I noticed
the language in Access seems quite different from Excel.
 
Macros in Access are not like macros in Excel or word. Access macros are very limited, while Excel macros are real VB code. I've often wished for something similar to the Macro Recorder for Access, but in truth, it wouldn't work. Access does not have fixed records like Excel, nor does it have cell referencing and the like.

You CAN create macros and then save it as VB code, but it's not always the most efficient way to do it. And many things CAN NOT be done this way.

The only way to learn VBA for Access is to plunge in and do it. There are lots of resources to help. Most of the sample databases on my website involve programming. "Access Cookbook" by Ken Getz, Paul Litwin, and Andy Baron is a great book to learn how to do specific tasks in code.
 
Thanks Roger, excellent resource. I'll have endless fun playing with all
these databases.
 
Back
Top