linking a marco to a button

[yld53x]

hi

how do i link a button to prompt for a file and once you have entered the file name and click ok, the macro should also run 3 queries once you have clicked ok.

thanks

 

[sdk]

Hi,

I don't believe there is a way to propmpt a user for the file name using macros, you would do this in VBA, prompting for a file location and using the reults to identify the file path/name in a docmd.transferText method.

After the transfer, you can use the docmd.openQuery method to open/execute the queries you require.

Cheers

Steve

 

[GDGarth]

A macro will prompt you for a file name if you leave the "file name" section blank.

Create a new macro
Choose "OutputTo" as the action.
Fill out the object type, object name, and file format. Leave the file name blank.

When you run the macro, a window will pop up, allowing you to browse for the location and/or name.