Search results for query: *

Thanks. I was able to do that with CF. I was attempting to learn if VBA could do this. You did help me with the cell ref issue. Thanks.

Thanks in advance for the assist to a VBA newbie. I want to perform the following: I want to color format cells A1:k:1 based upon the value entered into K1. I want to do this for each of 65 successive rows. I can do this via conditional formatting for each series of cells, but I want to do this...

Nope. Still no value in Me.Handset1_EH_CALC. No error message. Field remains blank. I copied code and directly overwrote. Saved code. Shutdown and restart form. Should I have exited Access? I understood alteration of single vs double quotes at end of DLOOKUP, but why omit .value? Trying to...

Thanks in advance. I created the following code to do the following: After exiting an input form field (HandsetProduct1), I wanted to perform a calculation in another form field (Handset1_EH_CALC) by looking up a specific value (i,e,EARNED HRS standard) using DLOOKUP function, based upon the...

Thanks in advance. I have a form with the field AREA where I can select from two choices (Handset or Polymer) in a drop down combo box. This same form also has another combo box titled Location. I want the choices in the LOCATION box to be dependent upon the selection in the AREA combo box. For...

Dlookup worked. Thank you.

I have a form field that I would like to perform a calculation upon the exit from a second form field. For instance... FormField1 is a quantity showing how many "units" were created for the day for the Category "Scrolls". I also have a table in my database containing 6 Categories - including...

Thanks Dhookum. I now see that I need to create a second report for just HPO calc. I appreciate your time and effort.

Dhookum, I've zipped and uploaded the database. I am trying to alter the "DailyProductionSummary" report. I've removed all my tests in order to get back to square one. I envision the report have a box that calculates Hours Per Order as HPO = Grand Total Manhours/Shipping Total Good Orders when I...

TY dhookum

I've tried this code! No luck, I have an unbound textbox with this code within the DETAIL section of the report. It returns nothing, a blank. I think the AfterUpdate() declaration is incorrect. What declaration is required when I initially run the report? Private Sub HPOCalc_AfterUpdate() Dim...

OK... I was calculating in a footer! I should know better. Thanks. But the issues still exists. I moved the text box with the formula into DETAIL section of the report. When I run the report, it wants inputs for Shipping, Total pcs, etc - basically an input for each of the output heading noted...

Almost. The expression now wants an input for Dept or Loc, for Total Shipped Sum, and for Grand Total Manhours. I wanted the calc to occur using values on the form, without me inputting those same values. Thanks for your patience.

I placed the formula in the Control source of the calculated box and it returns the error: "The expression you entered has the wrong number of arguments". If this was to be VBA code, I assume it replaces my HPOCALC as noted above, I get #name error. My code looks like this: Option Compare...

I am trying to do the flowing when I run a report that displays a Group format: I've included a sample page of my report - attached I want to alter the Grand Total Sum calculation to show Sum of SHIPPING (both shifts) / Grand Total of manhours I.E. I ONLY want the Sum of Shipping - NOT all...

Access 2010. I will post in other forum. Thanks. Sorry.

I am trying to do the flowing when I run a report that displays a Group format: I've included a sample page of my report - attached I want to alter the Grand Total Sum calculation to show Sum of SHIPPING (both shifts) / Grand Total of manhours I.E. I ONLY want the Sum of Shipping - NOT all...

Thanks everyone. I ended up outputting a record to .PDF and then photoshop out the detail I did not want. I was able to save and use as a template. Not quite what I wanted, but the work-around will do. Thanks again.

The form is an input form for a table. I have tried to print at "insert", but it prints out a completed form - not a blank; even when the form on the screen is blank - I get a record.

Access 2010. I've tried removing data and printing, unsuccessfully