Results 1 to 5 of 5

Thread: ListBox bound to Access Database?

  1. #1

    Thread Starter
    Addicted Member Smie's Avatar
    Join Date
    Jun 1999
    Location
    Columbus, OH
    Posts
    249

    Post

    How would I save data in listbox format in an access database? Ive tried a number of things, but no luck...thanks

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    Do you want to use ADO or DAO? Why not save to registry?

  3. #3

    Thread Starter
    Addicted Member Smie's Avatar
    Join Date
    Jun 1999
    Location
    Columbus, OH
    Posts
    249

    Post

    DAO and, I dont want to save to registry because I need the info in a database

  4. #4

    Thread Starter
    Addicted Member Smie's Avatar
    Join Date
    Jun 1999
    Location
    Columbus, OH
    Posts
    249

    Post

    Thanks, but what i need to do, is when your inside Access(making the database) you can choose what type you want the data to be saved as Eg.

    Text
    Button
    Checkbox
    Listbox

    The normal is text, i have gotten checkbox to work, but not listbox, any help?

  5. #5
    Hyperactive Member
    Join Date
    Jun 1999
    Location
    Calgary Alberta
    Posts
    359

    Post

    What exactly do you mean 'Save data in a listbox forat to database'? Do you mean you want all the data in a list box saved into a database? Each in a seperate field or all data into 1 field?

    If you want to take all the data from a list box and save into 1 field in a database, I would set up a loop to cycle through the entries, add chr(34)-" on either side, and seperate by commas and dump into a string. Then write this string into the database field.--> string = "data1","data2" etc.

    If this isn't what you mean, can you be more specific?

    [This message has been edited by netSurfer (edited 01-11-2000).]

Posting Permissions

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



Click Here to Expand Forum to Full Width