Displaying PivotChart on desktop

[Bill]

I have an Access Query that I view in PivotChart form. I
want to view this PivotChart as a desktop item that I can
refresh at will and see 'real-time' data.

Anyone know how i can do this?

I have tried 'saving as...' html/xml - to no avail...

(BTW: I'm using Access Beta 2003)

Bill.

 

[Guest]

Bill,

Try this:

Set the Modal and PopUp properties of your form to "Yes"
Make sure you have a button on the form to quit Access. In the OnClick
event: "DoCmd.Quit"


Create a script file on your desktop with the following code:

Dim oAccess
Set oAccess = CreateObject("Access.Application")
oAccess.Visible = false
oAccess.OpenCurrentDatabase "Full Path to mdb enclosed by quotes"
oAccess.DoCmd.OpenForm "frmPivot"
Set oAccess = Nothing


If all goes well, you'll have only your form floating on your desktop.

Steve