Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2014
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Automate Saved Import

    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

  2. #2
    New Lounger
    Join Date
    Apr 2014
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Automate Saved Import Solved

    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.

  3. #3
    2 Star Lounger bobdog's Avatar
    Join Date
    Jan 2001
    Posts
    108
    Thanks
    3
    Thanked 5 Times in 4 Posts

    Automate saved import

    Many thanks. I needed that, Bill.

    Quote Originally Posted by William.hodgson View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •