Search results for query: *

Thanks for the info ... however Where do I put the (int(([vaule]+.0050*100))/100 Cliff

Once I get the answer how do I delete my own forum posts?

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

THANKS IT WORKS!

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 = &quot;ca&quot; Then Me.SalesTax = 0.0775 * Me.CalcSubTotal...

Thanks... For safety sake I renamed &quot;temp&quot; to &quot;oldtemp&quot;, created a new &quot;temp&quot; folder and rebooted... all seems ok.. Thanks CK8

Can I delete everyting that has acummulated in my WIndows/temp folder? What damage will be done HA HA Thanks CK8

New Idea Here is my presnet code for the event when I click the save button: private Sub cmbSave_Click() If Me.ChurchState = &quot;ca&quot; Then Me.SalesTax = 0.0775 * Me.CalcSubTotal Me.SalesTax.Requery End If Me.SubTotal = Me.CalcSubTotal Me.ShipCharges =...

Thank you for your help..This works...however I m adding this to an existing form that had an existing text box for sales tax...when i place the new one on the form all old records (forms) retain correct sales tax info but now I have two sales tax text boxes on the form. With 1000 records I do...

I have a sample database that I am writing that does include samples of what you are asking...if you would like a free copy for you to look at no problem...A friend helped me write it so I don't know all the ins and outs. Also there are a few bugs in it I am trying to work out. CK8

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.

How can you password portect a Powerpoint 2000 presentation file?

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 &quot;Please Confirm Address&quot; I already have the macro for the message...