Recent content by J4mieG

Adrianna, that sounds perfect ! :p ( Thanks also Roy ), I havent had a chance to try re-writing the code ( to first declare the query parameters ), but will give this a go. Sounds as though you've encountered exactly the same problem, so believe this should now work. "Can I ask why you are...

Smercer - "Try doing a macro, then save it as a module. You would then have the vb coding necessary for your work" I'm not sure what you are relating to here :confused: Hi Roy, Thanks for your response. Yes the 6th query does contain parameters from an open form (me.txtdealer and...

Thanks Smercer, I see what you mean - however, this would only work if I had one sheet in excel ( used as a linked table ) which held all the data... Whereas my problem is that the data needs to be inserted into the Excel template in various sheets in various locations. I did ponder the...

Smercer - Thanks for your reply, but not sure how using link tables will export data to excel ? I have a Excel Template, in which I want to extract data from multiple access queries into various locations on the template. It worked fine for the first 5 recordsets until I added Rst6 - now it...

Hello, my first post, please can somebody help me with the following problem ? I am writing a program which will allow me to export data from multiple queries into excel,( by calling the fields from each DAO recordset rather than transferspreadsheet method ). However, everytime I reach the 6th...