Search results

HI JHB I have zipped the back end. Hopefully you can make the front find the back. Regards Dennis

Sorry about that. I forgot that it was split. I'll work on merging it and reposting. I'll have a look for the Master Child relationships in the meantime. Thanks for your advice

Thanks JHB The two queries are exactly the same for the two reports and use the same parameters from the same parameter form. The main difference is the use of 2 subreports in the body of the report so that the information is printed on one A3 page (for print display) in 2 columns rather than on...

Thanks JHB. You have hit the nail on the head. I get the same number of pages as there are records in the first query result. Can you offer a solution? Is there a way of not getting the same number of pages as records in the query?

Thanks Arnelgp. I used the original report when I created the second one.

I have designed a simple database to manage the publication of a weekly list of events. One report I have designed has two (2) sub-reports and prints in 2 columns on one A3 page - This week's events and featured future events. I have used a parameter form to set the date ranges for both...

Hi I am rebuilding an existing database into a web based database so that I can upload it to SharePoint but I am experiencing difficulties in working out how to use web queries. My database is an Events database that publishes a weekly program of events. The model was provided through this forum...

I am trying create a simple Access 2010 web ready database which I will then upload to SharePoint so others in my work group can use interact with the information in the database. I want to use a query with parameter [Enter Surname] and be able to find an individual record for that person. In...

Thanks Allan I was able to use your database and build what I wanted form my group. Thank you very much

Hi I have developed a simple database for managing a weekly events program. Events are entered individually at the moment and can be viewed separately and in various groups. The whole purpose of the database is to streamline the creation of a weekly program of events which is both printed and...

Hi I have been using Access for many years but have built only simple databases without using code at all. I need some help to move forward with a database I have recently developed. Cheers Dennis