nod31
asked on
adding records problem
i ahve a problem where i cannot seem to add records from my visual basic application to my access database tables.
Can someone please take a look at my project ans see if they can fix it!
Please read the txt file in the rar file
http://www.noel16.freeserve.co.uk/images/Problem.rar
thanks for taking a look at it!
you can contact me on
nod9000@noel16.freeserve.c o.uk
Can someone please take a look at my project ans see if they can fix it!
Please read the txt file in the rar file
http://www.noel16.freeserve.co.uk/images/Problem.rar
thanks for taking a look at it!
you can contact me on
nod9000@noel16.freeserve.c
If it's all the same table do one AddNew, then validate your fields, then perform the Update.
Cheers
RichW
Cheers
RichW
I've also noticed that your datProducts data object on the frmOrders form has a different path to the db than the other data objects on the form. It's pointing to the C:\Windows Desktop\Future School\Program Code\FSDBase.mdb, whereas the others are pointing to C:\Future School\Program Code\FSDBase.mdb.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
would it be asking too much if any of you could PLEASE tidy it up a bit, cos i am relatively new to database programming! i would be so grateful!
If i had more points i would definately post them, but thats all i have got, PLEASE PLEASE PLEASE can you help me!
if you do tidy it up, could you send it to me,
nod9000@noel16.freeserve.c o.uk
thanks very much!!!
nod31
If i had more points i would definately post them, but thats all i have got, PLEASE PLEASE PLEASE can you help me!
if you do tidy it up, could you send it to me,
nod9000@noel16.freeserve.c
thanks very much!!!
nod31
ASKER
about the database path, i had copied the database to the other path, its exactally the same, but i forgot to change the paths over to the main one which is the
C:\Windows Desktop\Future School\Program
Code\FSDBase.mdb
C:\Windows Desktop\Future School\Program
Code\FSDBase.mdb
Working on it.
You should have the files now.
ASKER
i still cannot seem to get an order added from my visual app to the database, can u help, i havn't modified the code!
Error still keep occurring!
:(
Error still keep occurring!
:(
ASKER
have you got the program to add orders to the database?
What error are you getting?
You're doing a second AddNew when the first one may not be resolved.
RichW