Recent content by ben.hornshaw

yea great i had used the grouping in the wrong query Thanks

Thats Great thanks

im sorry i still dont understand i have attached a help database that i have just made to illustrate the problem. im sure its me but i already have a query but it displays the sametransport company over and over again any more help would be greatly appreciated

i assume you want me to use the group by function but how?? the field i am doing this against is a text field? i now have a Total Row and under each field is Group by what next?

Hi all I have a table called Vendors and another called Trucking. i have set up a 1 to many relationship between these because one vendor may use many trucking companies. i want to create a drop down combo box that displays all the currrently used trucking companies so i can select one easily...

ok and to make things more confusing i just added the line msgbox("nodata1") into the on no data event of all three subreports and not one fired! even though the subreport doesnt show any records and when i run the queries there made from then return no records! any ideas

i have just tried putting me.pagebreak1.visible = false in the on no data event of the first subreport but it still displays a blank page

Hi all i have a report with multiple subreports. after each subreport there is a page break as i want each location, each subreport to start printing on a new page. when a location/subreport contains no data of course the report prints a blank page as the page break still acts, how do i stop...

legends both of you!

i dont know how to do this or if it would help what i want can you explain more??

Hi all I have created a Delete Record Query. this works great but when i click my delete button i have created a message box asking if you are sure you want to delete record "" when the user clicks yes i then get two more message boxes, one saying are you sure you want to delete data and the...

Thanks Dave I was in the process of trying this and im pleased to say it works well. I didnt want to have to create 2x every report but ah well. i would rather do that than supress error messages. thanks

Hi all I have a small problem. i ahev a report which i have created to fit exactly to an A4 page with no boarders. the reason for this is when i print it to a PDF i wan the background image to go all the way to the edge of the page! (Nice haha) My problem is that i also want to be able to print...

Erm i dont know im trying that now butwhat i am doing is quite big so maybe the three page limit of a report isnt enough

thank you for your replies i had a look at DCrake's demo. Thanks for that its kind of wat i was originally thinking. the reason i dont want to go with that is that i need more than just 3 diffferent colour, even more that 10, more like 150 and therefore i didnt want to go down the road of...