Automate Saved Import

Topic

New Reply

MS Access 2010 question.

There is a saved import that I would like to run off of a button. Unfortunately I don’t know how to set up the code or a macro to do this. I don’t want the end users in the menu ribbon.

You all have always had an answer for me so I will thank you in advance and also after the fact.

Thanks
Bill

Reply | Quote

Replies

:rolleyes:As usual the answer is pretty straight forward.

Just add the following code to the button
DoCmd.RunSavedImportExport “SavedImportName”

When I save my steps for the “Import” I accept the overwrite table function and it gets included with the save. Which is nice since it gives the end user a nice Message that the table is getting overwritten. Makes the end user more comfortable that something did indeed happen.

Reply | Quote

Many thanks. I needed that, Bill.

:rolleyes:As usual the answer is pretty straight forward.

Just add the following code to the button
DoCmd.RunSavedImportExport “SavedImportName”

When I save my steps for the “Import” I accept the overwrite table function and it gets included with the save. Which is nice since it gives the end user a nice Message that the table is getting overwritten. Makes the end user more comfortable that something did indeed happen.

Reply | Quote