Recent content by BernardAtherton

Thanks again for the advice on not using a macro and getting the VBA to execute the Query. With regard processing each row one at a time here is the problem I face. The query returns many fields but I am interested in two : Cust Number and Product customer has. For example: Cust No | Product 1...

Wow, thanks all of you and Mile for your code example. I will try this out tomorrow at work and let you know how I go. I intend to have a macro that runs the query and then get the macro to run the new VBA which processes the results of the query one row at a time. Is this a good way to run...

At work we are using Windows NT machines, so I think its Access 2000, trouble is I am not at work at present so I cannot verify until tomorrow. Sorry. Do you have any code examples that I could see and try? Thanks for your time and help. Bernard

Can VBA code access results of a query? Hi there, I have an access database that has a query in it that produces results that are view as a datasheet. I would like to code some VBA that reads the results one row at a time is this possible? If it is can anyone provide some code examples to get...

Thanks for the second attachment, it is superb. I agree the wording needs to be precise. What you have produced is the kind of things I am after. If I ask for customer numbers where they ONLY have a Current and Savings that is all I want. I am not interested in customers that have...

Thank you for your speedy responses. Namliam, I downloaded your attachment and got it working many thanks. Please note I am a novice and I am wondering how the query would be changed to just find customers that only have a Current and a Credit card. Any further assitance greatly appreciated. I...

Hi, I would like help in finding a way to find the following by using a query. I have a table that contains customer number and product. For example Cust No Product 1 Current Account 1 Credit Card 1 Savings Account 2 Credit...