Search results

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?

perhaps it will easier to just attach the database

I have placed it in the VBA editor but still the only field in table2 that stores data is the TEMP field the others are blank? incidentally I am using access 2000 if that makes any difference.

tried this link and after entering the me.textbox etc command it says the macro does not exist?

Sorry I have not explained very well, new to forums. thanks in advance for your help. I'll try again. Table1 is used for the combo box on the form. Table2 is for the record storage there are more fields in table2 I just need help with the combo box. What I am trying to do is when the user...

I have 2 tables as below : table1 TEMP PH4 PH7 PH10 30 4 7 7.9 20 6 8 9 10 7 7 7.9 table2 REC TEMP PH4 PH7 PH10 1 2 3 I also have a form relating to table 2 with a combobox for the temp on table1. how can i get the combobox selection to...