Search results

Bob, I guess it is down to what I know. The report function would have been another thing to learn and my schedule is tight, whereas I already have a fair grip of Excel and it makes the end user format manipulable if they want to hack it about with the customer. Cheers Jimbo

Hi Chaps, Thanks for your wise replies! I will have a go and let you know how I get on! Cheers Jimbo

OK ... I have been looking at this since I wrote the request. I now think that I can manage the running of the macro to generate the reports in MS Access, and export the resulting Excel files to any location I specify. But I will still need to invoke this action remotely. which is where the...

Hi All, I am a database newbie and have been working on a database to supply a catalogue to our sales team. I have developed a query that strips away what they do not need to see and I have developed an Excel macro that fully formats the query to make it pretty! What I now want to do is: *...