Recent content by Rog

Just got back to this. Thanks, Ian. I didn't have my tables linked. I'll try it today

How do I run queries in one database from an outside database? I've got lots of databases, each with lots of queries, that I have to run over and over. I've created a routine which runs all of the queries in one database and does other good things. (I haven't succeeded in getting it to work...

That's brilliant. Works a treat now.

I do a lot of data scrubbing and have built a form to run a selection of queries within a database. Trouble is that I often finish with lots of select queries open at the end of the run. Sometimes I want to look at them. Sometimes I don't. How do I identify the open queries within my databse...

As above, using QBE you can do a query to make your first selection, then make a second query to run on the first query. A query doesn't have to be based on a table. It can be based on an existing query.

Thanks 'r' - you're right. I needed someone to point this out even tho I really knew it. Now I've just got to think thru the paranoia which led me to keeping all the data separate in the first place, and being confident that I'm keeping control of all the individual files that the regions...

I know how to use basic parameters in Access. My problems stem from processing data for 8 regions within my company, and wanting to keep the data separate. I sometimes copy info to a common file, process it, (often lots of queries) and then copy results out to a specific file again. But...

I write hundreds of Access queries but only know a little bit of VB. What would make my life a lot easier is if I could see all a database's queries in one place, do global 'find and replaces', then replace all the queries where they came from. It's so time-consuming going into every query and...