1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

VB6 Databases

Discussion in 'Software Development' started by MyName, Apr 15, 2004.

Thread Status:
Not open for further replies.
  1. MyName

    MyName Thread Starter

    Joined:
    Oct 25, 2001
    Messages:
    316
    I'm creating a budgetprogram, and I know some things about databases in Visual Basic. However, some things I am trying to do I am unsure of. Can anyone point me to a website that would help clarify the following things:

    -creating new databases in vb run-time
    -adding fields to databases during run-time (adding a new expense in a text box, I would then add it to the database)

    Essentially, the program works as a user enters their name, if it is a new name it creates a database. It will ask to add categories and amounts. Then it will display those figures on the main form, and allow the user to add the amounts in etc. I know how to get from the database to display values in text boxes and labels, but I don't know how to create a database using Visual Basic, as well as adding fields to it. I've looked around, but haven't found anything that would help me out. Thanks in advance.
     
  2. MustBNuts

    MustBNuts

    Joined:
    Aug 21, 2003
    Messages:
    2,016
    The answer depends on which database software you use. If, for example, you use Access, you should look into ADO.

    You could then use SQL statements to create, modify, and delete tables and records. I am not sure you want to create a new database for every new user/name....look into, possibly, a new table for each.

    Upon closer thought, you may be better off, depending on size, to create one dbase, with a table for user info, then other tables to track other information (using a unique key from the user table as the relationship).

    Hope this helps,

    MBN
     
  3. Spacetop

    Spacetop

    Joined:
    Apr 17, 2004
    Messages:
    8
    I would pick up one of the WROX books on VB+Databases like Access... It the the best publication for beginners..
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/220810

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice