Search results

Don't worry I've sorted it!

Hi Carlo Many thanks for your reply - it's great to know we are on the right track. One query - I added a subform but how do we get it to automatically insert one of the foreign keys? Cheers!

Hi I've been tasked with rebuilding (starting again!) a database at work, but only have limited knowledge of Access so apologies in advance. What we want to do is link multiple context records (archaeological term for a wall, ditch, soil layer etc) to multiple photo records. eg CONTEXT 1 is...

Thanks for the suggestions CJ London. They are overlapping vertically, but there is nothing to either side - the sub-report is basically the same width as the main report. I am increasingly thinking it's something in Access 2007. I've opened the database in Access 2013 Preview and the report...

I've got excactly the same problem (Access 2007). The only work around I've found is to have the report open in print preview mode, where it reads fine but isn't very user friendly. I've seen it reported elsewhere but no-one seems to have an answer. Is it a bug? Any help would be appreciated.

Cheers lagbolt - got it working!

I'm a newbie to Access and I'm sure this must have come up many times before but searching the forum/internet I couldn't find it... I want to create a report which shows site information (site record), and then shows monitoring information (monitoring record). The site information and...