If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

Re: help with ado

There is a handy dandy little wizard [data form wizard] that will create a form for you complete with buttons and code that you could look at.
There are about a million samples on the internet of how to do simple data operations with ADO

But as I said the .Update method does this, that is about as simple as it gets. Have you tried it?

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.