Search results

kyguy, Good Morning. I have Access 2007. I will be removing Excel 2003 today and am hoping it will then call Excel 2007. CJ-London, as above and also i went and checked References. I have ticked, Microsoft Excel 11.0 Object library. I unticked it and will trial now, before Excel...

CJ, Good Morning and many Thanks. I will remove excel 2003 from my machine leaving only excel 2007 and see if it calls 2007. yes ? How do i check for this :- "make sure you haven't referred to Excel in your references" what am i looking for ? a few weeks back, I resaved the old xls file...

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...