Search results

Haha, so simple when you know how! Thanks a lot! You're right about taking you round the houses though! I know this is heading towards a module/vba question, but would you happen to know how change this to landscape using vba? I can get the query to open in print preview mode using vba, but...

Hi all, I'm sure this should be possible. I'm trying to use Access 2007's built in 'Save as PDF' option to output a many queries. I can get them to save as PDF no problems at all, but there never seems to be an option to choose to output it as PDF in a landscape orientation. Anyone have...

Edit: Looks like i may have posted this in the wrong forum. (oops!). Should have probably been Access Modules and VBA, sorry. Hi all, I have done some searching but couldn't really find anything like what I was after. (If it's possible) I have 100 queries is Access. A print out of each...

DCrake I owe you a pint! This is very good, small, easy to modify, and almost exactly what I was after (i wont need to change any of my queries :)), but i never would have thought of that myself! Extremely helpful, and also absurdly fast! Well done. With regards to there being multiple...

Hi DCrake There is very much a logic to filtering for specific strings. There will be about 8 strings i will want to filter for on the same column name of every query. We have so many queries because we are a 'data control' department as such and all of these queries are checking for...

Hi folks, I have a little challenge on my hands at the moment and cant seem to google/search/code up the answer myself (if there is one). I currently have a loop in VBA that does (in it's simplified form) DoCmd.OpenQuery DoCmd.PrintOut DoCmd.Close For a few hundred queries. What i now have...

Well I need to be able to see all the queues, with only 1 subform I will only be able to view one queue at a time. Unless i have misunderstood what you have said, then i apologise. As far as im aware i am already changing the recordsource of the subforms underlying queries with the block of...

Currently have 6. They are all instances of the same form I just change the control source at runtime. We will be moving up to 8 queues shortly, but depending on load IT will deploy more Virtual machines for queues on demand.

Hi folks. I'm trying to create a form that can be update with (x) number of subforms with minimal code changing each time. The form is actually a queue monitoring application; each subform being a separate queue. Depending on the time of year the number of queues is increased or decreased to...