This worked fine, I must have missed something in the typing. I really appreciate your effort as you can not imagine how much this helped me

If I execute the procedure without commenting out all the lines above the insert line, nothing happens. I do check that by looking at the invoice tables which should show...

this did not work. remember it is an access project and I already have a table primary key (TxnID, int). I am following the golden rule of never using the...

thanks a lot

The folderid is one of the inserted fields, I use it to open the invoice form after the update takes place. I do not get any errors from VB code....

Note the '' after the first argument in the ISNULL.

Yes that is what is happening. I will try the @@rowcount and let you know

Yes the server is on the internet

I tried that and still get the same message

I found those tables when I was looking at the database with Enterprise Manager

Those tables contain some rows of select statement but because they are inconsistent they keep poping up

The...

I am sorry, I had to be more clear. When I look at the data base tables i notice the following table names: "~TMPCLP216731" , "~TMPCLP376821" this is just an example...

Unfortunately, the number of lines is not consistent as well as the text, what is consistent is only the two letters abreviations e.g.K-FEGP4450 means the cost of the ticket in...

Thanks for the tips but how can I program different currencies e.g we use L.E (egyptian pounds) and the exchange rate is variable on monthly basis?

The 0.7 is the an...

You can use use the demo CD (which comes with any SQL Book) or download the evaluation version from Microsoft which works fine for 120 days. You will then have...

This worked great, thanks