When I change information on my customer form (contact name) it updates all previous sales records. Question: How do I create forms that do not update once data is entered and saved? If you Need more info or sample of database let me know. THANKS
CK8
QUESTION: How would I edit blow event to include an IF order date is < than 01/01/02 then calc rate at 7.5 percent
but if order date is >12/31/01 then calc at 8.0 percent?
private Sub cmbSave_Click()
If Me.ChurchState = "ca" Then
Me.SalesTax = 0.0775 * Me.CalcSubTotal...
When I change information on my customer form (contact name) it updates all previous sales records. Question: How do I create forms that do not update once data is entered and saved? If you Need more info or sample of database let me know. THANKS
CK8
When I calculate the sales tax on a form I want it to round off to 2 decimals in its calculation. Right now I end up with a long decimal for calculation purposes and this will leave the calculation over or under by one cent on occassion.
I want to create a drop down list for sales tax amount options that when one is selected it will automatically calculate the sale tax on my order form. Right now I have it written so that when you “double click” on the sales take field it calculates. Problem: The sales tax rate is changing and...
How can I run a Warning Message AfterOpen on a form where I want it to first look at a check box. If the Check box is checked I want the message macro to run; if no check in the box then no Message. Message is "Please Confirm Address"
I already have the macro for the message...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.