Thread: Database Programming

  1. #1
    Registered User
    Join Date
    Mar 2006
    Posts
    3

    Wink Database Programming

    Am writing an MFC program that reads and updates a database(MS Access Db) using ADO. I have been able to create a form to manipulate one table in the database. Am not able to switch from one window/form to another so that I can access the other tables. I need help. You can send a code for this in an example or even lead me to helpful resources.If you can do it in ODBC or any other Db access method, please feel free to send it. Thanks.

  2. #2
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,079
    Too vague. Where are you having trouble with the coding? Show us what you have so far and we can help from there. Also, if this is a problem with the MS Access end and not the MFC program, then this is probably more suited in the tech board. If you're having specific problems with the MFC, then you can check here:

    http://msdn.microsoft.com/library/de...html/mfchm.asp
    Last edited by SlyMaelstrom; 03-22-2006 at 07:31 AM.
    Sent from my iPadŽ

  3. #3
    Registered User
    Join Date
    Mar 2006
    Posts
    3

    Question

    Thank you for allerting me. maybe I should make it clearer.My problem actually is not with the database i.e MS Access,but rather on writing the code to implement switching of the windows. My database is made up of two tables, customers and invoices. The application is meant to fill customer details(name,customer number, invoice number,telephone and address),update them,navigate through each record and be able connect to the invoices form which will enable the user to fill the invoice details(invoice number, date of issue,customer number,amount) as pertains to a particular customer. Using ADO(ActiveX Data Objects), I have managed to do with the customers' form. I honestly have no idea on how to insert the invoices form and particularly how to connect it with the customers' form.(the code for the main frame) this is where I need help.If you can do this using ODBC,please feel free to help.Am ready to give any clarification if still am not clear. Hank you.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. literature database: help with planning
    By officedog in forum C++ Programming
    Replies: 1
    Last Post: 01-23-2009, 12:34 PM
  2. Creating a database
    By Shamino in forum Game Programming
    Replies: 19
    Last Post: 06-10-2007, 01:09 PM
  3. Replies: 10
    Last Post: 05-18-2006, 11:23 PM
  4. Developing database management software
    By jdm in forum C++ Programming
    Replies: 4
    Last Post: 06-15-2004, 04:06 PM
  5. Making a Simple Database System
    By Speedy5 in forum C++ Programming
    Replies: 1
    Last Post: 03-14-2003, 10:17 PM