Search results for query: *

Willir, Thanks for your reply,I will try your suggestions. Actually I defined the sort order in the table design view and it works fine. However when I link to this table in another database the sort doesn't work. That's the only problem. I guess I can use a make-table query and specify...

All, Thanks for taking the time to respond to my post. Each Order_Number has several sequence steps (10,20,30...) and I have several orders in the table (tblLptRtgs). I want it sorted by Order_Number(ascending)first and then Oper_Seq. Here is some sample data for Order_Number and Oper_Seq to...

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

RoyVidar and dhookom , Thanks so much for your suggestions, I did try setting up an unbounded text box on the report and it worked. But the problem is that the other parts of the report still show up (column headings, etc). No records are displayed obviously but the column...

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

GingerR, Thanks for your helpful tip, it worked! Wonder why I didn't think of it? I appreciate your help with my problem immensely!

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

Ken, Thanks for your prompt reply,I tried to do what you said but I still get an error. To clarify the problem: I have a field called Stop_Date which is when the machine is stopped for some reason and Start_Date which is when the machine is restarted after the downtime. I still get an 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...

Ken and Jeremy, Thanks for your suggestions, I tried to format it as yyyy and it worked, so that was the source of the confusion! The form was designed by somebody else with different fields for date and time and the database is already populated with a years worth of data so...

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

Michael, Thanks for your reply, it makes sense. However I'm making modifications to an existing form designed by somebody else and the separate fields for date and time already exist. There are entries in the database for almost 2 full years and making changes will require a lot of work...

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

Scriverb, I sorted out part of the formatting problem! I went to page setup and changed the number of columns displayed from 1 to 5 and it worked. But there is still the problem of the labels appearing for each set of records. Since the labels are the same for all the records I only...

Scriverb, I did everything you suggested (1) All the controls are in the details section (2) No entries are present under sorting and grouping (3) The force new page option and new col or row option has been set to none But the problem still persists! I know its hard to figure it out...

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

Scriverb, you are a genius! I found that the report was sorting by descending date and I deleted that sorting order from the report. However I still have a small formatting problem. Each set of records for a particular date is printing on a separate page. How do I make sure that all 5 records...

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!