Recent content by Rpm1957

I have a checkbox on a form which when checked runs a macro, however it also runs the macro when I uncheck it. How can I have it so that the macro only runs when checkbox is checked?

I have a checkbox that runs a macro when ticked, however it also runs when I uncheck it. How can I have it only run the macro when ticked.

i have command button on my form to print the current form. however when i selected it prints all the forms. how do i get it to just print the current form that i am looking at and also print it in landscape only?

nw actually stands for Northwest followed by an address i just thought it was easier to call them NW1,NW2 etc for the purpose of this inquiry rather than fill the page with addresses.

i am trying to run a query based on 2 fields one is called REGION and contains records such as NW1,NW2,SE1,SE2, etc. The other is called OFFICE and contains records such as SLA, NON SLA. What i am trying to achieve is to count how many NW records are SLA and how many are NON SLA. I am not...

Thanks for your help. Works great!!

Thanks for your help I thought the code was the way to go. Just one question where do I put this code? Is it in the control source for DUE DATE?

I have a form with text box for DATE, a combo box for LENGTH OF DEPLOYMENT I.E 4, 6 or 8 weeks and a text box for DUE DATE. how do I get the DUE DATE box to update dependent on the DATE and the LENGTH OF DEPLOYMENT. I have put this statement in the DUE DATE property CONTROL SOURCE =[DEPLOYMENT...

So how do I get the query to run after textbox2 data has been entered and display the results in textbox3. Are there any examples I can follow?

Ok I think I know where your coming from concerning saving the data for text box 3. I'll try to explain. Text box 1 is a mV reading at a certain stage of calibration. text box2 is a mV reading at the the next stage. Text box 3 is the slope between the two readings. I think what you are saying is...

This is a calibration sheet, each record in textbox1 and 2 are different every time therefore the calculated value (textbox3) is also unique, so is it best to use a query and how do I store the results?

Yes I am storing values 1&2 but how do I get the query to store value three in the table?

i have a form with 3 text boxes, i would like the user to enters data in box 1 & 2 and then display the result in box 3. However I need to store the result (box 3) in a table and I have read that you shouldn't store calculated fields in a table so what is the best way to go about this?

Thanks for your help. I think I finally got my head around it. (at last!!!) You guys really know your stuff!!

So can you tell me the answer or post back the database so that I can see what you mean?