CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 13 of 13
  1. #1
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    VB6 Form Generator

    I've been hunting for a VB6 Form generator but can't seem to find one.

    Ideally you could select a Database, Select a Table, Select the Fields you want to show on the form, then 2 Forms are created

    1st Form - Search for Records in the table

    2nd Form - The Record selected from the table is Displayed with ADD, DELETE, CHANGE record capability

    We have all been making these form combinations forever - just wondered if there was one out there (FREE) which I could use.

    I have one which I bought for VB.NET (EasyCode.com) but dont have one for VB6

    Preferably does NOT add controls at run time as this makes it **** difficult to personalise certain fields (eg, Make them combo box or lookup fields)

    Just thought I would ask

    Thanks

  2. #2
    Join Date
    Dec 2001
    Posts
    6,332

    Re: VB6 Form Generator

    Though I'm not entirely clear on what it is you're looking for, have you checked PlanetSourceCode.com for something like that?

    (BTW, have you checked your messages lately?)
    Last edited by WizBang; July 5th, 2008 at 06:34 AM.
    Please remember to rate the posts and threads that you find useful.
    How can something be both new and improved at the same time?

  3. #3
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    I have tried planet... and most other sites, but I just cant find a good form generator - have seriously hunted for months

    Ideally it would also have an ADO backend

    VB6 has a form generator but it is so basic and also uses bound controls to DAO

    The application is

    Open a Table
    Display all the records (or 1st nn records) in a Grid
    Scroll to select the record
    OR
    Key in a search string and search for a record you want
    When you click on the record you want, another form opens up and shows the record
    The form also contains buttons for ADD, CHANGE, DELETE Record

  4. #4
    Join Date
    Dec 2001
    Posts
    6,332

    Re: VB6 Form Generator

    What you're describing sounds to me like a database viewer/editor. Have I misunderstood?
    Please remember to rate the posts and threads that you find useful.
    How can something be both new and improved at the same time?

  5. #5
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    The attached image is off planetsourcecode

    Problem is it uses DBGrid32 and DAO bound controls and creates fields at run-time

    Apart from that it would be perfect

    It is OK in that all you need specify is the database and table name, which is a quick and easy solution but doesn't lend itself to be able to be modified

    Ideally, the form generator would actually create the form adding text boxes and prompts which can then be opened up with the VB6 IDE and modified if required

    eg, Some tables may have 100 or so fields - you need to be able to group these logically using a tab control - you also need to be able to suppress some fields as they are strictly internal

    Example was at:
    http://www.planet-source-code.com/vb...40838&lngWId=1
    Attached Images Attached Images  
    Last edited by George1111; July 5th, 2008 at 08:47 AM.

  6. #6
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    What you're describing sounds to me like a database viewer/editor
    Exactly - but with the ablity to embelish the forms to make a robust application

  7. #7
    Join Date
    Dec 2001
    Posts
    6,332

    Re: VB6 Form Generator

    Quote Originally Posted by George1111
    Ideally, the form generator would actually create the form adding text boxes and prompts which can then be opened up with the VB6 IDE and modified if required
    OK, now I think I get what it is you're looking for. You want a tool for generating a VB form, based on the fields of a database, for editing that database, right?
    Please remember to rate the posts and threads that you find useful.
    How can something be both new and improved at the same time?

  8. #8
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    Thats it !

    EazyCode.com provides an excellent tool for this for VB.NET and it is reasonably priced (I bought it about a year ago)

    I have never been able to find the equivalent for VB6 though

    Have a look at http://www.eazycode.com and you will see what I mean

    Download the demo if you have time - you will see it creates some quite nice forms and code for VB.Net

    The ASP.Net has just been recently added - this is another bonus

  9. #9
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    This was generated by Eazycode - with no programming required !

    However, you end up with the complete source code of the application.

    This is quite a complex application as it allows searching for Orders, then the display of the Header and Detail Lines of the Order Selected

    The applications generated tend to be bug free - I feel they need a little tweaking to make them more user friendly though - eg, I'd rather see a DELETE Button than a X on the form (meaning delete)

    In this example, the Product Description is stored in another table - you would have to write your own code to look up the description and insert it into the grid - or you would change the stored procedure to look it up before populating the grid

    Options exist to have either Stored procedures for your SQL code or to Generate SQL within the VB Code - whichever you prefer

    Cute !
    Attached Images Attached Images  
    Last edited by George1111; July 5th, 2008 at 09:55 AM.

  10. #10
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: VB6 Form Generator

    Just write your own! I wrote a viewer that would open and db, allow you to select any field, and then generate a report (for a client). it was too complex for him, so i gave him 6 option buttons instead.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  11. #11
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    Thanks David

    I am only asking because "You never know what's out there"

    Furthermore I need it now, and it will take me at least a solid week or two to make a really good one. (Which means it won't be ready for at least a month)

    I have half finished one, but want to start it again as I think I can do it better differently - I've already spent a week on it and just don't have the time to blow on a project which may or may not be finished in a reasonable period of time

    So the question remains -

    "Is there a good one out there ready to go for VB6 ?"

  12. #12
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: VB6 Form Generator

    While these are free, the data driven ones aren't. Sometime it's worth the cost of getting something quickly. http://www.devexpress.com/Products/ActiveX/XFreeLib/
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  13. #13
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,900

    Re: VB6 Form Generator

    I'm not a fan of Form Effects (and DevExpress is VERY expensive)

    Want a generator that can make something like the last picture I posted with solid ADO behind it

    Perhaps available to purchase at a nominal fee ?

    Thanks

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

Featured