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 Rhinorhino 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: jethro11
  • Content: Threads
  • Order by date
  1. jethro11

    Access Tables - Sorting

    Hi, I'm using VBA code to sort a table after writing out the fields but it doesn't seem to work for some reason. To be specific I want the table (tblLptRtgs) sorted by the fields Order_Number and Oper_Seq in ascending order. Here is my code: db.OpenRecordset("Select * from tblLptRtgs order...
  2. jethro11

    Report - Nodata Event - Print message on report

    Hi, I currently have a report where if there are no records matching the criteria (obtained from user input), a messagebox comes up saying "No data available for(user input)". Is there any way that this message can be written out to the report? The Report_Nodata event is based upon...
  3. jethro11

    Report to only display records based on value of calculated field

    Hi, I've set up a report to monitor daily shift activity reports and check compliance to federal standards for environmental pollution. The report does some calculations for Charge lbs/hour and checks it against a predefined standard. If it is in compliance it puts a value 'OK' in another...
  4. jethro11

    Clearing text box in the event of validation error

    Hi, I've set up my form so that the text box entries are validated before update and if the entry fails the validation test, an error message comes up. Is there a way to clear this entry from the text box and ensure that the record isn't saved if the validation test fails? For eg My form has...
  5. jethro11

    Wrong Elapsed time calculations

    Hi, I've defined a custom function called Downtime as coded below which I then use to calculate elapsed time between 2 sets of dates and times. This works fine except when the dates span midnight and then I get really big numbers for downtime. For eg if Stop Date is 12/15/2002 and Stop Time...
  6. jethro11

    Erroneous time calculations in form

    Hi, I have designed a form to calculate total downtime in a shift. My form has 4 separate text boxes to hold Start_Date, Start_Time,Stop_Date and Stop_Time. The downtime is calculated by subtracting Stop_Date and Stop_Time from Start_Date and Start_Time and there is a text box assigned for it...
  7. jethro11

    Report Formatting (multiple records on one page)

    I've created a report based upon an underlying query. This query outputs the top 5 records based upon descending date. However I have a small formatting problem. Each group of records for a particular date is printing on a separate page. How do I make sure that all 5 records fit on a page? To...
  8. jethro11

    Top Values in Report

    Hi, I've created a report based upon an underlying query. This query outputs the top 5 records based upon descending date. The query works fine, however the report outputs just 1 record, not the top 5 as I want. How do I fix this problem? Thanks for your help in anticipation!

Part and Inventory Search

Back
Top