Search results

I fixed the error by changing: strSQL = "SELECT * FROM Orders WHERE OrderStatus = " & txtCurrentOrderStatus into strSQL = "SELECT * FROM Orders WHERE OrderStatus = 'Payment Received'" But this is not what I want. I need a dynamic input from txtCurrentOrderStatus. How do I solve this? Anyone?

Here is my current script, but it won't work. It said Error at this line: rstOrders.Open strSQL, conDatabase, adOpenDynamic, adLockOptimistic >>>>>>>>>>>>>>>>>>>>>> Input: txtCurrentOrderStatus = Payment Received txtNewOrderStatus = Order Shipped >>>>>>>>>>>>>>>>>>>>>> Private Sub...

Hi all, I'm new to Access programming so this could be very simple for some of you. I have a table with field name: OrderStatus which has several values: Payment Requested Payment Received Order Shipped Completed I currently change each status manually. But more often I need to change ALL...

Lets just say somehow I really really need to save the calculated value. I know its a bit redundant in term of programming effeciency. But is there actually a way to do that? If there is, how? Thanks!

Yes, my control field is =(Nz([AmountSubTotal])+Nz([AmountSH])-Nz([Discounts])) It doesnt work. Let me clear up a lil bit more. I have NO programming script at all on my form. Not sure if I really need one. I have Order Table and made auto Order Form. in Order Form, Control field for...

Hello all, I'm quite new to Access. I've read many Access tutorials and site but I have yet to found the solution for my problem. So here it is (pardon my english): Field AmountTotal is =(Nz([AmountSubTotal])+Nz([AmountSH])-Nz([Discounts])) I manually input AmountSubTotal, AmountSH and...