Hmm, I don't see MAKE Table or IMPORT... anywhere in the query or the macro for the form button.
Query:
Code:
UPDATE ltbl_Deploy_ops_upload_OP
INNER JOIN tbl_milestones ON Val(ltbl_Deploy_ops_upload_OP.Site_num) = tbl_milestones.site_num
SET tbl_milestones.track_last_updated = Date(), tbl_milestones.track_open = [ltbl_Deploy_ops_upload_OP]![track_Open]WHERE (((tbl_milestones.site_project_type) In ("1-New","2.2-Remodel","2.3-Refresh","FDP","Image Activation","Refresh")));
Macro:
Code:
...
DoCmd.SetWarnings False
Call fShowMsg(Forms!Maintenance, True)
DoCmd.OutputTo acOutputQuery, "qry_Gateway_Date Changes", "ExcelWorkbook(*.xlsx)", "C:\temp\qry_Gateway_Date_Changes.xlsx", , , , acExportQualityPrint
DoCmd.OpenQuery "qryU_deploy_ops_upload_CS", acViewNormal, acEdit
DoCmd.OpenQuery "qryU_deploy_ops_upload_TO", acViewNormal, acEdit
DoCmd.OpenQuery "qryU_deploy_ops_upload_OP", acViewNormal, acEdit
DoCmd.OpenQuery "qryU_deploy_ops_removedeinstall", acViewNormal, acEdit
DoCmd.OpenQuery "qryU_deploy_ops_phantum", acViewNormal, acEdit
Call fShowMsg(Forms!Maintenance, False)
Application.FollowHyperlink "C:\temp\qry_Gateway_Date_Changes.xlsx"
...
Edit: Updating using linked table manager does nothing.
In fact, it's not even the same file consistently like I thought. It seems to be random, which I'm sure can't be.
I'm sorry for the amateur questions, but I truly appreciate the help. This is a side project I'm trying to get done between downtime on the main project. I'd like to get it done before my contract is up in a week and a half since no one else here wants to touch it.