Recent content by RSDAnalyst

Hello folks. I hope someone can help me with the following. I want to export the results of a Access query to Excel but without saving the Excel file. I want to allow the user to decide what and where they will save the file or not save doc at all). Similar action to copying manually the...

Hi nanscombe (Nigel). Thanks for trying to help with my Access issue. I tried your suggestion. It worked partly. I.e. If I choose any or all of the campaign.status radio buttons. Worked fine. Combined at the same time with Supplier worked fine. But then If I was clear options start from say...

Hello, folks. I thought I had this cracked! Nigel (nanscombe) code works a treate. If I use the campaigns.suggestion iff above on its own (nigel's) it works great. Combining with the existing SQL statement it does not function. Any clues anyone? Again any assitance would be much...

Sorry for delay in responding back to all your individual comments and useful suggestions. I just got caught with other things. I was meaning to respond sooner, my apologies. Nigel (nanscombe) was probably closest to what I finally tried myself in the interim whilst waiting for a response to...

Hello all, This is my first ever post on this website and I hope someone can help with my Access problem. I have table called Campaigns that has a column called Status. This Status column has 4 possible entries: Proposed, Approved, Cancelled and Closed. I am building a query linked to an...