Recent content by Chris Green

I've set up a database to record the hours of a small group of co-workers, and so far the results have been impressive, proving to be 100% accurate compared to the legacy nightmare of an Excel arrangement previously in place which was not robust to change without lots of de-snagging. However...

Thanks guys - I see now that TransferSpreadsheet works just as well with queries and my problem seems to be "solv-ed" as Clouseau would say. This is an object lesson in making sure that everything has a unique name, otherwise a query with the same name as a table would muck things up here. It's...

Well, I did say I hadn't touched this for several years David, and VBA is on my list of things to re-acquaint myself with. Sounds like a nice little project to let myself back in gently!

I'm currently using OutputTo. I've looked at your suggestion but it only seems to work for sending the contents of a table, not a query. Would it work with a query? I suppose if I turned my two queries into Maketable queries, that would give me table names to play with, although this process...

I've set up a macro to export two of my queries to Excel for easy e-mailing to non-Access-using recipients. They work just fine when run from the Macros list but I'm trying to automate the process from a control button on the main screen of the whole database. Unfortunately this masks two...

Thanks for that - I knew I wasn't dreaming. You've confirmed that there is a way to force headings by inserting the correctly spelled names of columns manually, and I've introduced this into my existing effort mentioned in the above post as weeks 1 2 3 4 and 5 even though we seldom get a...

Many thanks guys - I've created a "halfway house" select query to give me my list of all staff, joining name in the staff table to name in the timesheets table forcing a list of everyone irrespective of whether they submitted timesheets or not (I used the second option in the Join Properties)...

I used to be quite a "power user" of Access up to about 7 years ago, then a different job pulled me in another direction altogether (Cycling Instructor!). I'm currently making a database for my employer to keep track of the timesheets for about 24 instructors and it's apparent to me that I've...