Replies

Sorry Steve… Didn’t get that far… I was playing with code… lol

Sorry Steve… Didn’t get that far… I was playing with code… lol

Thanks Steve… I really appreciate the help, but all I get is “DataType Mismatch” error… even when I just put… ?activesheet.pivottables(1).sourcedata …in the Immediate window… I’ve checked out the object browser and tried to use the pivottable object, pivottables collection, pivotcache… etc… I’m not having any luck…
The only thing I can get to return anything is this statement… It actually finds that there is a pivottable…

?Worksheets(“BOC SUMM”).pivottables.count
1

Lot’s of good that does me huh?…

Thanks Steve… I really appreciate the help, but all I get is “DataType Mismatch” error… even when I just put… ?activesheet.pivottables(1).sourcedata …in the Immediate window… I’ve checked out the object browser and tried to use the pivottable object, pivottables collection, pivotcache… etc… I’m not having any luck…
The only thing I can get to return anything is this statement… It actually finds that there is a pivottable…

?Worksheets(“BOC SUMM”).pivottables.count
1

Lot’s of good that does me huh?…

Thanks Jan… I already have your FlexFind utility… (Thank you very much BTW! )
But it’s not finding anything when I search for a back slash… … even with the objects checkbox checked)

Thanks Jan… I already have your FlexFind utility… (Thank you very much BTW! )
But it’s not finding anything when I search for a back slash… … even with the objects checkbox checked)

I’ve even gone into MS Query and edited the SQL to say the proper path… but it doesn’t change on the workbook itself… I saved the query but that doesn’t help…

I’ve even gone into MS Query and edited the SQL to say the proper path… but it doesn’t change on the workbook itself… I saved the query but that doesn’t help…

I tried that… It keeps giving me a Login window… prompting me for Authorization… and password… The default user is Admin… I ignored that and selected Database and the path, but it never saves it…
Any idea what’s wrong?

I tried that… It keeps giving me a Login window… prompting me for Authorization… and password… The default user is Admin… I ignored that and selected Database and the path, but it never saves it…
Any idea what’s wrong?

… Ahhh… The scope… I should have thought of that…
Thanks a million John!

… Ahhh… The scope… I should have thought of that…
Thanks a million John!

Thanks Patt, but that’s one of the things I tried…
I get error ‘Runtime Error 2465 – Application-defined or Object-defined error”

Thanks Patt, but that’s one of the things I tried…
I get error ‘Runtime Error 2465 – Application-defined or Object-defined error”

Thanks Wendell… but the problem I’m having is with the syntax…
This is what I have so far for the code…

Dim acApp As Object ‘ Declare variable to hold the reference.
Dim acDatabase As DAO.Database

Set acApp = GetObject(“C:Documents and SettingstreaspaDesktopdb1.mdb”)

With acApp
.Visible = True
.DoCmd.OpenForm “Form1”
.Forms(“Form1”).frmOptions = 1
.Forms(“Form1”).cmdDone.SetFocus
‘cmdDone_Click ‘this is where I don’t know how to enter the command… I’ve tried a few things but I can’t get it right…
.Quit
End With

Set acApp = Nothing

End Function

P.S. This is just a sample… Not the real thing…