Results 1 to 20 of 27

Thread: Solved: Populate a comboxbox and Listbox in a excel userform with an sql table data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-17-2010, 11:19 PM #11
    abhay_547
    abhay_547 is offline
    VBAX Contributor
    Joined
    Sep 2009
    Posts
    130
    Location

    Populate a comboxbox and Listbox in a excel userform with an sql table data

    Hi Tinbendr,

    I am facing the following error when i use the below sql statement in my macro.

    stSQL = "SELECT DISTINCT Region FROM Region_Mapping"
    Error Encountered : "Run-time error '-2147217900 (80040e14)':
    The text data type cannot be selected as DISTINCT because it is not comparable."
    Last edited by Aussiebear; 04-19-2023 at 02:06 PM. Reason: Adjusted the code tags
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules