• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 144
  • Last Modified:

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.co.uk

 
0
nod31
Asked:
nod31
  • 7
  • 4
1 Solution
 
RichWCommented:
You're only showing one Update in cmdAddOrder_Click, and even that is not handled if the If statement isn't true.

You're doing a second AddNew when the first one may not be resolved.

RichW

0
 
RichWCommented:
If it's all the same table do one AddNew, then validate your fields, then perform the Update.

Cheers
RichW
0
 
RichWCommented:
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.



0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
RichWCommented:
Also, when you're validating the txtUnitPrice, you're setting the txtTotal field by doing a calculation.  The problem is that the txtQuantity field hasn't yet been populated when this validation fires off, so your result will always be zero.

When the txtTotal field is set to zero you have the txtTotal_Change event firing off (from the txtUnitPrice_Validate event), which invokes an error giving a type mismatch.

You need to clean this up as well.

0
 
nod31Author Commented:
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.co.uk


thanks very much!!!

nod31
0
 
nod31Author Commented:
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

0
 
RichWCommented:
Working on it.
0
 
RichWCommented:
You should have the files now.
0
 
nod31Author Commented:
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!

:(
0
 
nod31Author Commented:
have you got the program to add orders to the database?
0
 
RichWCommented:
What error are you getting?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now