Recent content by tgleghorn58

Figured it out. set to False

I am saving an access table to excel, which is working however the excel opens also and I do not want it do. This is my vba DoCmd.OutputTo acOutputTable, "tbl_reduction", "ExcelWorkbook(*.xlsx)", RptName, True, "", , acExportQualityPrint Beep MsgBox """File has successfully been...

there is no close query command. I will just have to do an event procedure to run the queries.

Got it... The best thing probably is to write vba for this. thank you for help

even the select and crosstab queries are opening

I have multiple OpenQuery actions in a macro. I have SetWarning = no, however the datasheets are staying opened. I just want the queries to run without the user having so close each one. I have attached a snapshot of the macro.

how would you put a datetime stamp in the file name?

then I need to pass the filename to be a variable in a second file.

I am using a savedexport in a macro. how do I pass a datetime stamp to the file name. I created the savedexport because I want a pipe delimited txt file.

Thank you for the information.. My database has sensitive info in it and I am not permitted to share it.. You had mentioned in a prior thread about asking for what pieces of info is needed.

I haven't done this before and have no clue what you want or expect! Please advise. Thank you

I didn't realize what you were asking. I thought you just wanted my vba... If I understood that was what you were asking I would have asked more questions on what and how to upload it.

I did post a mock up db..... see prior posts. And I thanked you numerous times for your help.

Your code did help... but it did not totally work for me. If you can show me where to put the if len statement in my code.. I would be happy to use your suggestions.

I am sorry, I missed that... thank you for your help, but you need to get rid of your attitude.