recording a macro in Acess 2007

[barboza]

Hello,

I learned a lot of the vba coding techniques I use in excel by using the macro recorder. A great way to learn to do things.

I am now just starting out in Access, and would like to use a macro recorder to record actions I take.

For example I would like to find the commands for navigating to the first and last records in a database while in a form.

Problem: I can't find a macro recorder in Access. Is there one??

Thanks

 

[ajetrumpet]

I don't think there is....I learned a bit when I started Access 2000 from the macro drop down list.

It is probably too complicated to build a recorder in the program, being DB software and all. Just a few clicks on different objects and you'd have two pages of code written!!

You can learn a little bit from the macro dropdown. Look at the code that's written when you create one, just like in Excel. If you know VBA already, you should be able to do fine in Access by looking up the syntax of commands you want, like "GoToRecord", in the help menu, which is the one you need per your post..

This is one of the actions too, in the macro editor.