Recent content by grinder332518

please ignore the above : I have worked out what I was doing wrong !!

I have written a report which is returning 2 pages of data, in Portrait mode. However, the report is outputting 4 pages, with pages 2 and 4 blank. If I go into Design View, and right click the black square at the top right of the screen above “Report Header”, and then click on Properties, I...

Thanks Trevor G My Form is working fine now. :D

My table X has a field “DateLastUpdated”, along with 7 other fields. I wish to set this field to today’s date whenever any of the 7 others change. To do this, I suspect I can set an ‘On Change’ [Event Procedure] for each of the 7, but is there a better way of doing this ? And can you suggest...

thanks GalaxiomAtHome & JamesMcS. I have got a solution to this. Best Wishes

My report needs to showi occupancy in residences over the 52 weeks of a year. My fields will include location, week_number, tenant_name, co-habitant_name, and up to 6 dependents. As I do not want to have to define 52 * 8 fields in my table for all the occurences, is there a neat way, in table...

Thanks vbaInet : I'll check it out.

My Form accesses a query to return a dataset from 2 tables. There are almost 1000 rows returned, and I have the usual navigation buttons along the bottom. So if I want to retrieve a row from the middle of the dataset, it takes quite some time to get to it, using these buttons. I would like the...

My Form accesses a Query as follows : SELECT tblA.A, tblB.B, tblB.C FROM tblA LEFT JOIN tblB ON tblA.A = tblB.A UNION SELECT tblB.A, tblB.B, tblB.C FROM tblB LEFT JOIN TblA ON tblB.A = TblA.A where tblB.A not in (select TblA.A from TblA) This gives me all the rows from tblA, with tblB...

I have a query which accesses a table with 2 fields which are hyperlinks. There is no problem with the display. But if I then enhance this query with a union ,the hyperlinks now show "#" symbols at the beginning & end of each hyperlink in the query. Where do they come from, and how do I...

I did move the sources to a shared drive. I now need to write an update query to amend the setting for the OLE object to point to the new destination.

Hi Boro When I select Options, I get lots of tabs, as follows : Advanced International Error Checking Spelling Tables/Queries View General Edit/Find Keyboard Datasheet Forms/Reports Pages I have selected them all, but the only place I can set such a path is in 'General'...

My table consists of 3 populated text fields and 2 blank OLE Object fields. For the last 2 days I have been creating the OLE Objects as follows : Initially I select Tables from the Objects list, and from the Datasheet view I click on the appropriate {blank} field, and then click on the...

My table consists of a few populated text fields and 2 blank OLE Object fields. For the last 2 days I have been creating the OLE Objects as follows : Initially I select Tables from the Objects list, and then from the Datasheet view I click on the appropriate {blank} field, and then click on...

Hi Simon Our IT people are looking at these offices as we speak, with a view to implementing a solution similar to what you have suggested. Unfortunately, this isn't likely to be implemented until the summer. So the existing setup was agreed, to allow the project to proceed, and to give the...