Results 1 to 5 of 5
  1. #1
    hawkdriver's Avatar
    hawkdriver is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Nov 2012
    Posts
    23

    Export To Excel Combobox, Pre-Populating the Combobox w/ Stored Data

    I have an Excel template file that I want to export Access data to, which should be populated with the correct values per record. I am assuming I would need to know the combobox name on the Excel form. Would anyone have experience with this and could you provide a code example.

    To make it shorter, I understand the underlying connection requirements and sql statements needed in code. I just don't fully comprehend the "how-to" I'll need to connect to the specific combobox and display the text stored in the database.



    I really appreciate the help!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Doesn't Excel combobox reference a cell range as list source?
    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.

  3. #3
    hawkdriver's Avatar
    hawkdriver is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Nov 2012
    Posts
    23
    Yes. Are you saying the query output should reference the exact cell in the "ListFillRange" (see picture)? I am struggling to connect all the dots. The form needs to keep the list intact so it can be altered after the output to the form. The purpose is to send for revision in future requests. Thanks June7, you're invaluable to this forum
    Click image for larger version. 

Name:	ExcelForm_ComboProps.png 
Views:	11 
Size:	48.3 KB 
ID:	41036

  4. #4
    hawkdriver's Avatar
    hawkdriver is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Nov 2012
    Posts
    23
    Ah, I know what you were referring to. Please see the attached picture. This is the field I need to dump my result into. Perfect! Thanks for leading the horse to the water.

    Click image for larger version. 

Name:	ExcelForm_ComboProps2.png 
Views:	11 
Size:	23.7 KB 
ID:	41037

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Great, if that resolves issue. Found this tutorial https://www.extendoffice.com/documen...combo-box.html
    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.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-21-2018, 01:32 AM
  2. Replies: 1
    Last Post: 07-24-2015, 07:06 AM
  3. Replies: 3
    Last Post: 05-16-2013, 08:21 PM
  4. Stored vs. Displayed Data for a ComboBox
    By tylerg11 in forum Forms
    Replies: 1
    Last Post: 12-14-2011, 03:11 PM
  5. Form / combobox not populating
    By Auracle in forum Forms
    Replies: 7
    Last Post: 09-20-2011, 11:01 AM

Tags for this Thread

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