Search results

Good Evening, I have the foillowing Script in MS Access, which calls Excel 2003. Can anyone tell me how to call Excel 2007, instead of Excel 2003 ? Public Sub ActVsPlanPrj() ' 1-Set the recordset in pivot table format (DoCmd.OpenQuery ("Qry_ActualVsPlan"), acViewPivotTable) ' 2-export it...

I wonder if someone can help me. I inherited several MS Access DB's, One has a "Print Macro" which pulls up a 'Info Path' Template The Print Macro Code is:- Option Compare Database Option Explicit Private Sub Form_Load() Debug.Print sFolio Me.Filter = "folio = '" & sFolio & "'" Me.FilterOn =...

Good Morning, I work in Aviation as a Project Planner and Analyst. I inherited 4 MS Access 2007 DB's, with many Queries, Tables and Macros that i dont undersatnd but must maintain. I have not done any MS Access training, but have learnt a little from talking with others and playing with...