Recent content by scotland

Ah excellent worked a treat. Many thanks

Hey, I've been working on my DB for some time(thanks for the help with that:) ) then one day I open it up and my file/edit/view etc menu is gone! After trying to open with shift to see if I've disabled it by accident. with no joy i tried open access on its own not by the project file and its...

Yes, I went through the Microsoft tutorial again. I had missed out rstReport.MoveFirst from the report header. Which is needed because as you say the report is generated again but from where the recordset left off. Thanks Anyway

The referance required is probably DAO 3.6. I dont think its possible using subreports as the query powering the report is a crosstab and so has varing numbers of colums, and the column names vary as well and so can't be bound. Cheers

Sorry to bring this up again but I really would like it sorted. Anybody else got any ideas? Cheers

yes, it loads it up in print preview mode which works fine, I click print and it jsu repeats the last record. I think it is because the text boxes are not bound to fields but are made to equal the data during detail_print, as used here. Thanks

any ideas guys?

Hi I have attached a DB of mine which is a score grid. You select month and year from a form then it produces a report based on that month. All of this works briliantly (after a lot of work) in print preview mode. However when i actully print it all the data is replaced with the last record...

Yea as I say it only happens when I select keep together in the grouping options. I have modified the code slightly so maybe i did something wrong. Also please excuse the sloppy code im fairly new to VBA:(

No, i now have it working with a bit of jiggery pokery and sorting the query. However if i select "keep together" then it does not work and after a few entries it jus repeats the same record again untill the end.

cheers pbaldy that worked great. the only problem i have is that i have some grouping (people are in different groups) and i want all the peole to be grouped together. Is there a clever way of doing this or just make seperate quires for each group?

Hey, I have set up a report powered by a crosstab query that will grab the points scored by people in a month Now the problem is this links to a points table so i want to have the points displayed below the relavent date. the table is set up so that there is 1 record for every entry made. So...