Wrox Programmer Forums
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 6th, 2014, 08:26 AM
Registered User
Join Date: Apr 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default help with ado

hi everyone

so, i have created a kind of transaction program(whether withdraw or deposit) and i have used ado to link the database with the program.

the thing is that, on one form, when the user makes a transaction and click the print button, the program should save the newrecord and go to the other one. another problem is that in the transactionID field the data type is autonumber and thus should automatically increment. on the same form, when i leave or go to the mainmenu, the databse should be saved so that i can produce report afterwards.

i dont know how to do all this as i'm a student who has just began to just vb 6.0

the database is in .mdb and the table linked with the form above is tbltrans with fields: TransactionID(Autonumber),TransactionType,Quantity (Rs),TransactionDate,Notes,CustomerID
the form has AdoBank,cmdprint,cmdMainMenu

i would be glad that someone experienced help me for this program. if you need more information or the form or database please ask me. if you need to talk in private i can give you my facebook.

thanks in advance,

Similar Threads
Thread Thread Starter Forum Replies Last Post
ADO??? monabaumgartel BOOK: Beginning Access 2003 VBA 1 August 7th, 2007 05:44 PM
Difference between ADO and ADO.NET rakeshclose2u ADO.NET 2 April 23rd, 2007 03:57 AM
ADO ProudToBeMuslim VB Databases Basics 6 January 30th, 2005 11:23 AM
ADO AND ADO.NET royalsurej ADO.NET 1 November 8th, 2004 08:28 AM
ADO could ADO counot find the specified provider. Rob Collie Classic ASP Databases 2 June 9th, 2003 04:12 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.