Results 1 to 11 of 11
  1. #1
    chiefweigum is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2019
    Posts
    19

    Sort the import tasks in the manage data task window

    This is my first post I have about 50 different import tasks that I use to import excel spreadsheets into my database. There does not seem to be an order that these tasks appear and it would be easier to find the one I want to execute if they were in alphabetical order. Is there a way that the Manage Data Tasks items can be sorted?

    Thanks

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Welcome to the forum.
    Do you have a list of such tasks?

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Sorted where? In table or form or listbox or combobox or just a query you open?

    You can set order in table design but really, this is what queries are for.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    chiefweigum is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2019
    Posts
    19
    Here is a sample of a few of them and they appear in this order:

    BIG Update
    NCHC Update
    AUS Standings
    AHL Standings
    OHL Standings
    AHL Update

  5. #5
    chiefweigum is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2019
    Posts
    19
    Click image for larger version. 

Name:	DataTasks.jpg 
Views:	16 
Size:	58.2 KB 
ID:	39969

    I would like this window sorted

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Oh, sorry, I've never used saved import specifications. I doubt there is any way to control sort in this dialog. Are they listing in order created?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    chiefweigum is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2019
    Posts
    19
    No they aren't. When I create a new one, it is randomly placed somewhere in the list. I have to scroll around until I find it. Once they are in there, they never change order. I can't see a pattern as to where new tasks are placed.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    They must be saved as a record in some hidden system table. If you could figure out which table then can query that table. Although don't see how that would help interacting with dialog.

    You need to automate this process with VBA instead of running imports manually with dialog.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Well you could have a table with your import specification names. Add a field to the table for a sequence number or sort them alphabetically. Then have a routine/form or other that uses that record from the table in a
    DoCmd.TransferText statement. The names could be in an Option Group or a combo box.
    Your own little routine to automate your imports based on the specifications you have created.

  10. #10
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    import specs can be found in CurrentProject.ImportExportSpecifications - this function returns the names in a comma separated string

    Code:
    function importSpecs() as string
    Dim Spec As ImportExportSpecification
       
        For Each Spec In CurrentProject.ImportExportSpecifications
            importSpecs=importSpecs & "," & Spec.Name
        Next Spec
    
        'remove initial comma
        if importSpecs<>"" then importSpecs=mid(importSpecs,2)
        
    End Sub
    depends on what you want to do with it next - unsorted you could put into a combo box and make use of search as you type. Alternatively, bubble sort it and show in a listbox. Or update a table and sort by query

  11. #11
    chiefweigum is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2019
    Posts
    19
    Thanks for all of the suggestions - much appreciated. I will see if I can try some of these. I do find it strange that this window is not automatically sorted.

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

Similar Threads

  1. Saved imports and exports disappeared from manage data tasks view
    By mmoria2312 in forum Import/Export Data
    Replies: 8
    Last Post: 11-07-2016, 05:07 PM
  2. Replies: 7
    Last Post: 05-06-2015, 01:04 PM
  3. Outlook tasks import
    By dantray02 in forum Import/Export Data
    Replies: 3
    Last Post: 05-21-2014, 07:45 AM
  4. Replies: 13
    Last Post: 11-17-2013, 03:33 PM
  5. How to manage the manage the input of data?
    By Gambit17 in forum Import/Export Data
    Replies: 4
    Last Post: 07-30-2013, 10:32 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