Save As Dialog Box

[Wiz0fBaud]

Hey guys, I'm using the following vb action to save a chart on a form in MS Access to the "C:\Graph1.jpeg" location. How would I go about Instead of just automatically saving it to that directory, how would I go about asking the user where to save it? I'd like to add a command button that would save the file, but ask the user where to save it and the name? Can anyone help me out?

Dim grpApp As Graph.Chart
Set grpApp = Me.Graph1.Object
grpApp.Export "C:\Graph1.jpg", "JPEG"
Set grpApp = Nothing
Me.Graph1.Action = acOLEClose


THANKS!!!

 

[JeremyNYC]

Do some googling in comp.databases.ms-access for "Common dialog control".

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.