I have tried following the code in my book. It seems pretty simple. When I want to add a record to a database, I first add the record to my dataset. After that, I use the UPDATE command to update the database with the new dataset.
However, it's not working. It keeps giving me an error telling me "Syntax error in INSERT INTO statement".
Everything I have read tells me that I don't even create the Insert statement; that it's created automatically using the select statement I originally used to fill my dataset in FORM_LOAD.
Can anyone help me with this? I will be more than happy to post my code if necessary. However, I am at work and have it on my personal laptop.
Just let me know if you need the code. However, I haven't done anything special. I am trying to be extremely basic until I get this to work properly.
Thanks for any help you can give me.
Page 1 of 1
Help Using VB to Add Records to an Access Database I have tried it 20 times and am sure I have the right code (???)
Page 1 of 1

Ask A New Question
Reply





MultiQuote




|