Results 1 to 8 of 8
  1. #1
    fredk is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    4

    Import Defaults

    Is there a way to edit the defaults on the import wizard. For example, I would like the "First Row Contains Field Names" to be checked.

    ?



    Thanks!!!!

    Fred

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You can save your import or export process and give it a name that can be called using VBA and I believe Macros too. So it does not affect the default settings for the wizard but, it will precisely duplicate the entire import process.

  3. #3
    fredk is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    4
    I did think about some VB but was hoping to just change that one setting.. thanksf or responding!!!!

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You can use the Access Ribbon, under External Data, to manually run your saved Import procedure.

  5. #5
    fredk is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    4
    So that was my next question .. Is there a way to add a custom comand to the ribbon? I would rather have the button on my custom section of the ribbon if thats possible? thanks!!!!

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Have you looked into it?

    From the Back Stage, click Options> Customize Ribbon. From there you can create a new group to store a new custom ribbon. If you want it to go straight to the import process without a Macro may be the best. Don't know because I don't bother with the options described. I use VBA.

  7. #7
    fredk is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    4
    Can you take a vb module and launch that from a button on the ribbon? I was wondering if there is the ability to add a custom button linked to my vb and put it on the ribbon. Thanks again!!!! Fred

  8. #8
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Like I mentioned, a macro may be the best approach if you want to use the Ribbon. I really don't know because I do not use the Ribbon for a User Interface in my apps. If you store your Import procedure in a Standard Module as a Public Function, I believe you can call it from a macro. Launch said macro from your custom Group in your Ribbon.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Defaults in CrossTab query.
    By haydenbl in forum Queries
    Replies: 1
    Last Post: 02-24-2014, 05:47 PM
  2. Change table field defaults
    By paddymx in forum Programming
    Replies: 11
    Last Post: 12-14-2013, 03:38 PM
  3. attachment defaults
    By chiefmsb in forum Access
    Replies: 0
    Last Post: 07-13-2011, 06:38 AM
  4. Combo Box defaults to Blank
    By jimmonator in forum Forms
    Replies: 13
    Last Post: 05-02-2011, 01:28 PM
  5. Defaults Values Missing After DB Move
    By cbuechler in forum Database Design
    Replies: 2
    Last Post: 02-15-2011, 08:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums