Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dab1477
  • Content: Threads
  • Order by date
  1. dab1477

    Can I format a range of cells based upon another cell value

    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...
  2. dab1477

    form code not working - please help

    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...
  3. dab1477

    Rowsource issue?

    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...
  4. dab1477

    Access - VBA to match a table

    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...
  5. dab1477

    Can I code a calc on a report

    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...
  6. dab1477

    Can I code a calc on a report

    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...
  7. dab1477

    Code to print a BLANK form

    I created a form to collect responses from a process audit. I would like to print a blank form - having all the labels and blank input fields (checkboxes). Presently, I can print a completed form, but this had detail on it from a previous audit. Not what I want. Any ideas how to do this? Not...
  8. dab1477

    How do I count "true" occurances?

    I've created an audit form where I simply want the Auditor to select or click on a Yes/No box for a series of 16 quesstions. I then want to count the TRUE or YES conditions for all 16 questions within a text box on the form. This gives feedback as to the score for that audit. Ex: Auditor will...
  9. dab1477

    Code for use in Form Navigation

    I wrote the code below in order to navigate through a form named "Production Board Data Input". I wrote this code so that I could skip some inputs based upon the Dept or Location input - dont need the all data fields for all Dept selections, but want to capture department and man-hours at a...
  10. dab1477

    Calculations within query

    Thanks in advance for the assist. I am attempting to create a calculation within a query that says the following: Fixed Days: field1+Field2 My issue is as follows: I need the query to perform the following in my Fixed Days calculation column. If Field 3 = field 4, then Fixed Days =0, else Fixed...
  11. dab1477

    using VBA to code EXCEL form

    I've created a form where I wish the user to select machine # and Part # from drop down menus in 2 separate text boxes. Once the user selects these 2 parameters, i want to look up the 2 parameters from an excel sheet based upon the MAX or most recent date that the part ran on that specific...

Part and Inventory Search

Back
Top