How to add records in ADO?

[homesick]

I have a Tracker table with the fields Agent name, Date, Customer Name and Product. I want to sumbit the records into my DB using a button. How do i do this? BTW, does i make a diffreence it's already bound using the Wizard or do i still have to write that in the code. ow do i find the provider?

Still learning....

 

[scottrod]

I'm still learning too. Here's a great link of example code straight from the horse's mouth.

http://msdn.microsoft.com/library/d...270/htm/mdmscadocodeexamplesinvisualbasic.asp

The main ADO page has some good information and the above link.

http://www.microsoft.com/data/ado/default.htm

Hopefully this will get you going, coding the connection, etc. Error coding aside, you should be able to send the contents of your form controls (if that's what you've got) straight into the DB.

 

[homesick]

Thank You!!

 

[sunaj]

Hi,

see also thread222-175746
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'