New to access macros - help!

[freda42]

I'm finding writing macros in Access very difficult! I can write a little VBA but am struggling here. I know Access fairly well, but have worked it all out for myself so may be missing large chunks of knowledge without even knowing it...

I want to write macros to do the following, initially:

1. Bring up a 'find record' box from a command button on a form

2. Create a command button that takes the user straight to the pivot table view of a saved query.


It may be possible to do the above another way - is it?

If not, could anyone give me some general pointers as to how to start writing the macros? I don't necessarily need them written out, I can usually work things like this out if someone helps me to get going!

Many thanks!

 

[BarryMK]

I'm finding writing macros in Access very difficult! I can write a little VBA but am struggling here. I know Access fairly well, but have worked it all out for myself so may be missing large chunks of knowledge without even knowing it

I want to write macros to do the following, initially:
Try to avoid macros, VBA is better!

1. Bring up a 'find record' box from a command button on a form

In design view find the Toolbox toolbar, make sure the magic wand is selected and then click on the command button icon and follow the instructions.


2. Create a command button that takes the user straight to the pivot table view of a saved query.

Use the wizard again but don't let your users get into your tables, create a form from your query in datasheet view and point the command button there.


Good luck

 

[Hayley Baxter]

You can add a button to your form to bring up a find record box using the wizard, you don't need a macro to do this. Just step through the wizard and select "Record Navigation" and "Find Record".

For your second question choose "OpenQuery" select your queryname and the view in which you wish the query to open in the macro itself then go to your form and create a command button, in the command buttons properties choose to run the query.

 

[maxmangion]

since you're still starting to learn and use macros, i would suggest you spend your time learning VBA rather than macros, because anything you do with macros can be done with VBA, plus VBA is much more flexible. Moreover, the experts of these forums tend to prefer using VBA rather than macros.

 

[Rich]

Moreover, the experts of these forums tend to prefer using VBA rather than macros.

apart from One, that is

 

[maxmangion]

apart from One, that is ...

Hmm, i said experts not members

 

[Rich]

Hmm, i said experts not members