Search results

this all seems great what if I simply use DoCmd.OutputTo acOutputForm, "frmResults", acFormatXLS and then somehow call it to make changes to the data adding condition statements

ok, know we are getting some were TY theDBGuy love the image btw so he found this code below and yes so it exports the data as I have selected it to step 1 know I guess i need to add in condition statements for what I want? Public Sub cmdExport_Click() Call...

No, I think you are on track for an answer but how could I select the filtered SQL from the form and import that to an excel sheet?

the ideas seem good how would I even go about coding them?

Hi, I have found the motherload of a question and I cannot find how to do it. I want to output the results of my form after the person has filtered it so some VBA like this DoCmd.OutputTo acOutputForm, "Report 13", acFormatXLS, "C:\DATABASE\BLQ-10\ExportedResults.xls" Know-how in the world can...

Hi, I am reaching out to you because of your Export to Excel with Conditional Formatting post. I am having a hard time tracking it all but I see that you got it working i have been searching for this answer for a while can I see your finishing code I cannot seem to figure this one out please help!