VB School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Help Using VB to Add Records to an Access Database I have tried it 20 times and am sure I have the right code (???) Rate Topic: -----

#1 Tibim01  Icon User is offline

  • New D.I.C Head
  • Pip

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 13-June 07


Dream Kudos: 0

Share |

Help Using VB to Add Records to an Access Database

Post icon  Posted 13 June 2007 - 06:49 AM

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.
Was This Post Helpful? 0
  • +
  • -


#2 m2s87  Icon User is offline

  • D.I.C Regular
  • Icon

Reputation: 18
  • View blog
  • Posts: 390
  • Joined: 28-November 06


Dream Kudos: 1225

Re: Help Using VB to Add Records to an Access Database

Posted 13 June 2007 - 10:52 AM

Ahh, its probably just a little bug, do not worry about it to much. Take another example. ^_^
Was This Post Helpful? 0
  • +
  • -



Fast Reply

  

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users