Results 1 to 7 of 7

Thread: DB Combo

  1. May 16th, 2006, 01:46 AM #1
    ksandy46
    ksandy46 is offline

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    11

    Angry DB Combo

    hi experts :
    i am not able to fill the DBCombo using ADODB.recordset or adodc control from the module. Please give me the right method to do it, if possible with an example.

    regards
    Sandy
    Reply With Quote Reply With Quote
  2. May 16th, 2006, 06:54 AM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: DB Combo

    Moved from FAQ forum

    Welcome to VBForums

    There is no need to use a DB combo, a normal combo can be used instead - see this FAQ thread for example code.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. May 17th, 2006, 01:44 AM #3
    ksandy46
    ksandy46 is offline

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    11

    Re: DB Combo

    hi experts
    thank you very much, yeah i also followed the same concept, but is it anyway possible to do that or else should i use any other source(other than ADODC) to fill the DB Combo. if there is a way to club DB combo and ADO then please let me know.

    regards
    Sandeep
    Reply With Quote Reply With Quote
  4. May 17th, 2006, 07:15 AM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: DB Combo

    Is there a particular reason for using the DB combo?

    I have never used it myself, I think when I tried it I found it quite restrictive/limited compared to the normal one. As far as I know you need to use a Data Control to fill a DB combo... and Data Controls are not recommended by many people (I think 2 of our regulars - out of about hundreds), due to their "issues".
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  6. May 17th, 2006, 07:56 AM #5
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: DB Combo

    Quote Originally Posted by si_the_geek
    and Data Controls are not recommended by many people (I think 2 of our regulars - out of about hundreds), due to their "issues".
    I may not be 1 of the regular though I am one out of about hundreds that recommends against using Data bound controls, they have given me headaches before when I was just starting...
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  7. May 17th, 2006, 07:59 AM #6
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: DB Combo

    You are here quite often, and have got over 5000 posts.. I'd count you as a regular!
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  8. May 17th, 2006, 11:21 PM #7
    ksandy46
    ksandy46 is offline

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    11

    Re: DB Combo

    hi

    u r right, fine i will carry with data combo and ado, as i am able to taste some success, while using it. anyways thanks a lot for your guidence, it helped me a lot.

    kind regards
    Sandeep
    regards
    Sandeep K
    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


Click Here to Expand Forum to Full Width