Search results

Hi Minty I have been previewing my report via the Print View but it never seems to execute a second pass. From reading many threads on the subject, from various forums I have now added a control in the page footer containing =[Pages] and obscured it. This now seems to do the trick but I fail...

I have come across the following piece of code that I was hoping would reset the page number and number of pages (displayed in the Page Footer unbound control named ctlGrpPages) on the change of group (txtOrgName) within my report. My report has 4 Organisations (txtOrgName), producing 8 pages...

Thank you Gasman for providing a very quick simple solution to the problem. Only slight downfall is that I will need to extend the height of my Page Header to avoid "overlapping" with the controls on the left of the page where I have my Address displayed. Cheers

I have a report that I have created for invoicing my Customers. How does one go about tidying up the display of the address on the report should some customers use less address fields? For example [tbxCustomerName] contains Name [tbxAddressLine1] contains Street/Road [tbxAddressLine2] (Town)...

My thanks to Gasman and isladogs Your suggestion of enclosing the value of the textbox control tbxStartTime with date hashes has done the trick. tbxEndTime = DLookup("dteEndTime", "tblRefWeekSchedule", "[intWeekDay] = " & intDay & " And [dteStartTime] = #" & Me.tbxStartTime & "#") I have...

Hi Micron My field names are in brackets using a naming convention that indicates the Data Type in their prefix. Because my issue is with the "Time" fields I chose not to provide the field names for Venue and Class.

I have created a table (tblRefWeekSchedule) that corresponds to a Weekly Class Schedule. It contains the fields Weekday(intWeekday) Start Time (dteStartTime), End Time (dteEndTime), Venue and Class. The table was populated from an Excel spreadsheet and I note that when exporting the table it...