Recent content by David Ball

I will try that thanks

I have information from two different sources about subsystems (areas of an industrial plant). One is a to do list with items that need to be completed and the other is to do with checksheets that need to be completed. The information from each source is completely different but both refer to...

Hi, I was eventually able to fix this by minimizing the Access window, dragging it to the right, so that only the left border was visible, then dragging that border far to the left until I could see the left border of the property window. I could then drag that border back in. Thanks for your...

Hi arnelgp, thanks. I see one separator line but when I double click on it it goes even wider! Also, I don't seem to be able to move the window from its docked position. When I try to "grab" the window with left mouse button nothing happens.

Hi, suddenly the Property Sheet has very wide columns. So wide that it is unusable. The "Add Existing Fields" screen is the same. I am unable to get to the edge of the column to adjust it because it is off my screen. My Access is now unusable because of this silly issue. Does anyone know how...

Hi, I have a field of delivery dates, DelDate, and want to include a field that shows the sequence of the deliveries. I would call the new field Seq. For example, the earliest date would have a field value of 1, the next earliest would be 2, etc. If multiple records have the same delivery date...

Thanks very much

Hi, I am trying to set up conditional formatting to show Green for <1 , Amber for 1 to 14 and Red for anything over 14. I have the expressions as below: Expression is [Text24] < 1 Expression is [Text24] > 0 <15 Expression is [Text24] <14 The middle expression with > 0 < 15 doesn’t work. How...

Yes, after I stripped the my tables down to seven records each the query and report both open. When I had a thousand odd records in my tables the report only showed the first record from the query.

Hi, I have attached a stripped down database. The report seems to open OK with 99.9% of data stripped out of the tables. The query in question is qryW-CIV-TANKS-Dates and the report is rptTEST. Please note that two fields in the query, TankNo and TankNumber, are derived from fairly complex...

Hi, The text boxes are in the Detail section. I have attached an image. Thanks very much Dave

Hi, I have a query that seems to open without any problems. It opens with 63 records. When I create a report using the report wizard only the first record from the query appears on the report. Also, I notice that if I try to set a Sort in the query I get a message, Invalid Procedure Call. What...

Thanks very much, MajP, I will try that.

June7, I have attached a stripped down version of the database. If you open query, qryCC_Data_With_Expression, you will see the field (UniqueNo) I have created by concatenating two existing fields together. I need to do this to get a unique number that corresponds to a number in another...

Yeah, I'm the only user. I crunch data in Access and then copy the result from my query and use it in other applications. I got the query to filter but I have a calculated field in the query (two of the fields concatenated to create a new field) and everytime the query runs it deletes the...