recording macros in access 2003

[deniz]

is there any possibility to record macros in access like word, excel..?

i want to create a macro which includes mouse movements (or typed) to open a
menu command, like this:

file - get external data - import...

and i want to combine this with my command button; when I click on the
button, the window must open..

can anyone help me?

 

[Wolfgang Kais]

Hello deniz.

is there any possibility to record macros in access like word,
excel..?

i want to create a macro which includes mouse movements (or typed)
to open a menu command, like this:

file - get external data - import...

and i want to combine this with my command button; when I click on
the button, the window must open..

can anyone help me?

In Access, there's no way of recording a macro, you have to write a
macro yourself.
In you example, use the RunCommand action with the Import argument.
Even in Word or Excel, recorded mouse movement do not contain mouse
movents, just command executions.
You probably want to display a file open dialog box and then use
the TranferDatabase action to import objects fomr another database.
This can be done in VBA.

 

[deniz]

thx...

Hello deniz.



In Access, there's no way of recording a macro, you have to write a
macro yourself.
In you example, use the RunCommand action with the Import argument.
Even in Word or Excel, recorded mouse movement do not contain mouse
movents, just command executions.
You probably want to display a file open dialog box and then use
the TranferDatabase action to import objects fomr another database.
This can be done in VBA.