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. #14
    VBAX Expert Tinbendr's Avatar
    Joined
    Jun 2005
    Location
    North Central Mississippi (The Pines)
    Posts
    992
    Location
    Try
    SELECT DISTINCT CONVERT(VARCHAR(MAX), Region) FROM Region_Mapping
    Max will be the maximum length of the field your trying to convert.
    Last edited by Aussiebear; 04-19-2023 at 02:09 PM. Reason: Adjusted the code tags

    David


Posting Permissions

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