Search results

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...

Hi All My first problem is that i am making a database to store and print out health and safety information. due to this i need to create different parts, ie Risk assesments (RA) and Method statements (MS). What i want to do is allow my user to fill in all the different parts and then hit...

Hi All I have a table of colours. one of the field contains the access numeric code for a colour which is i copy and paste into the background colour property of a text box changes it to that colour i have found a VB script that does this automatically on load but what i want is to have a...

Yes i have many forms like this one creates a request for money. when the form opens it loads a new record. therefore the request ID reads (AutoNumber). As soon as the user starts typing this changes from autonumber to the next available number. from the instance you start typing access assigns...

another way to do this would be to bound the form and only assign a control to the dmax(primary key) cell. then when you launch the form fire a macro so it goes to a new record. Acces has a built in function that makes sure primary keys are not the same no matter how many users are connected...

I have just tried this using one of my tables i created a query with first name, surname and an expression just link yours combining first and second names with a space inbetween running ghe query creates a record: Ben Hornshaw Ben Hornshaw I then created a table and added a...