Macro to fire a module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have just finished my first Access application. Thanks again to all who
helped along the way.

I need the user to import a table into Access and then run the module I've
written.
All this time I've been editing the module and hitting run from the menu.
There has to be a better way. Please advise.

Thanks - Mike
 
Mike,

More questions than answers at this stage, I'm afraid...

What does the module do? When do you want it to "run", i.e. in response
to what event? How are you achieving the data import? Are the data
import, and the procedures of the module, supposed to happen at the same
time?
 
Steve,

Thanks for the response.

The user will manually import an excel file into Access. The file will be
an Outlook
attachment which will need some editing to delete extra header rows, etc..
so I'm
leaving that as a manual step.

Once the Data table is created in Access, I want to fire my module (1
procedure calling 2 user defined functions), which runs a number of queries
to create the desired report. Currently, after I build the data table, I
edit the module and hit run from the menu. I don't think I want the users
to do that.

Any ideas ?

Thanks - Mike
 
Mike,

What do you mean about "edit the module"?

You can put a command button on a form, and move the code from the
standard module to the Click event of the command button... would that help?
 
Back
Top