Recent content by jscriptor09

Hi folks Right now, I have a query set up to write to a table, and a Pivot chart that plots the data off the table. The data range in the table changes depending on dept/functions and so forth. I need the ability to rescale the pivot chart Primary Y axis on the fly using vba. The line of...

Hi Folks I have office 2010. In my Excel Macro, I added reference to DAO 3.6 object library. My goal is to be able to update a record in a table or add a record to the end of the table. I et an error as soon as I reach this line Dim db As Database, rs As Recordset, r As Long ' Set db =...