Search results for query: *

dhookom, Does this help you out in figuring out my issue? Option Explicit '**************************************************************** 'This function will walk through a table and email the 'report, which is filtered using 'MS Outlook through the MS Access SendObject. ' 'This function...

dhookom, MY QUESTION IS I have a much more complex report, with sub-reports and all, where the filter approach DOES NOT WORK. So, what I am trying to do now is apply the filter to the make table query - from there the report then uses the temp table and the problem of filtering via the...

Hey Bob, Where do I insert your code in my code? At the end of my code?

dhookom, Your right my mistake. What other criteria do you suggest I should use in my make-table query that will apply me to filter the make table query?

dhookom, What criteria can I use in my make-table query. I entered [break stop] in the criteria and when I open the query make table the message "you are about to run a make-table query that will modify data in your table" I select ok then a Enter Parameter Value box pops-up. I enter a field...

dhookom, Thanks for the reply. Would this be more clear? I have been successful in using this report when running data through a simple report and having the code apply a filter... The challenge I am now having is that I have a much more complex report, with sub-reports and all, where the...

I have a report with sub reports. I currently have a table with a query that filters a specific field. How do I go about creating another query filter to create a table in the report sub reports? Instead of me manually entering 25 new tables (sub reports), how can I create a query to filter...

I have a report with sub reports. I currently have a table with a query that filters a specific field. How do I go about creating another query filter to create a table in the report sub reports? Instead of me manually entering 25 new tables (sub reports), how can I create a query to filter...

I have been successful in using this report when running data through a simple report and having the code apply a filter... The challenge I am now having is that I have a much more complex report, with sub-reports and all, where the filter approach does not work. So, what I am trying to do...

I have been successful in using a report when running data through a simple report and having the code apply a filter... The challenge I am now having is that I have a much more complex report, with sub-reports and all, where the filter approach does not work. So, what I am trying to do now...