Thanks much - appreciate the quick response.

I would also initialize my variables before using them - it's just good programming practice:

set @Total = 0

set @max-2 = 0

it should be

SELECT @key=@NextKey

Here's my 2 cents:

All order type systems should have a history table. Make sure you (also) place all orders in the history table (id, descriptions etc.) that way, you will...

DATEADD("day", 2, getdate()),

should work as well.

since your "select", "update" and "insert" run in separate threads, it is almost certain to get blocks and conflicts - you will not be able to do "updates" and "inserts"...

Sergiy is correct -

Either use some sort of conversion, or check the value of the cbo - if it is empty/blank pass zero (0) that is an integer and...

The sproc looks ok and if you say it works, then the problem has to be the parameters - your code is not passing the correct values. Your sproc is...

it sure looks that way - let's avoid the confusion - post the stored proc so we can look at it

you left out the "end with" statment - that's your syntax error - it goes before the yellow line and the set rst line should read

set rst = .Execute "proc_Charge2",...

I noticed that you changed the connection string - hope it still works.

Try the following code as is - i'm assuming that proc_Charge2 does not take any parameters:

Sub Test()

Dim conn...

well, if you're not totally bummed out yet, look at this article i found

http://support.microsoft.com/kb/245374

it seems that there are issues with "adDBDate". Try replacing it with adVarchar????

keep the CDate function...

Well KC,there is one other thing to check - maybe you're not connecting to the DB like you think. In your code, immediately after the "conn.open svrConn" line, add these...

no, no

set param1 = cmd.createparameter("@start", adDBDate, adParamInput, ,CDate(RangeA.value))

cmd.Parameters.Append param1   --(no period after append)

Do this for both parameters

Wow!! just noticed that you append the parameters to the collection before you set the values for them - switch the 2 lines where you append and set the values.