MS Graph (or equivalent)

[The Frog]

Hi Everyone,

Just a quick one, does anyone have a good reference or suggestion for
info on integrating MS Graph with Access via VBA code? I have read
some conflicting information and just wondering if someone has a good
reference site that may save me many hours...

Cheers

The Frog

[DFS]

The Frog wrote:

Hi Everyone,

Just a quick one, does anyone have a good reference or suggestion for
info on integrating MS Graph with Access via VBA code? I have read
some conflicting information and just wondering if someone has a good
reference site that may save me many hours...

Last I knew, you can't do a whole lot of MS Graph customization with VBA.
You can't set the chart type or scaling or headers or major/minor gridlines
or font sizes or font opacity or pie labels or pie explosion (hope it's a
blueberry!), etc, programmatically.

That said, MS Graph is decent - for the kind of business charting I do at
least. You can show graphs on forms and reports, and you can update them in
real-time in response to changes in user choices and data.

Cheers

The Frog

[The Frog]

Thats a bugger about the programming of it. Do you know of any other
ways to achieve a suitable interactive graphic output? I was hoping to
build an app for some of our field sales people to look at some data.

I know of some ways to do this with other programming environments,
but I was hoping to keep this inside VBA / Access. Any ideas on how I
may achieve this?

Cheers

The Frog

[Rick Brandt]

The Frog wrote:

Thats a bugger about the programming of it. Do you know of any other
ways to achieve a suitable interactive graphic output? I was hoping to
build an app for some of our field sales people to look at some data.

I know of some ways to do this with other programming environments,
but I was hoping to keep this inside VBA / Access. Any ideas on how I
may achieve this?

I have programmatically worked on graphs is Access. Added trendlines, changed
colors, etc.. Look at the object model in the object browser and try some stuff
out. I don't know why it would be any less programmable than any other COM
objects.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Tony Toews [MVP]]

The Frog <Mr************@googlemail.comwrote:

>Thats a bugger about the programming of it. Do you know of any other
ways to achieve a suitable interactive graphic output? I was hoping to
build an app for some of our field sales people to look at some data.

I know of some ways to do this with other programming environments,
but I was hoping to keep this inside VBA / Access. Any ideas on how I
may achieve this?

Consider exporting the data to Excel and programmatically updating the graphs there.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/