Recommended Graph Control ?

[pbcclements]

Hi,

I am a developer on a project that has an urgent need for dashboard functionality / graphing cabability to produce things like dials etc that are not avaliable in access 2007.

I have had a look at Opengate, but they do not seem to be able to offer an evaluation copy that I can do proof of concept with.

If anyone has any firm recommendations for a thridy party product that could be both embedded in forms and reports and evaluated properly, I would be very interested to hear.

Also any endorsements of the Opengate dashboard would also be interesting.

Many Thanks

Pete Clements.

 

[ChrisO]

I really can’t recommend anything other than writing your own.

It strikes me as rather limiting (also read dangerous) to put our trust in something that others write for us. Will it do all we want? Can we modify it if it can’t? Will it work in later versions of Access? Do we get the source code when we buy something?

Access is pretty good at sub-classing Forms if we are prepared to do the work.

There is a small Access 2003 database attached that shows some of the things Access can do with Forms. It was originally written by Fred Ward at Utter Access but I can absolutely assure you Fred won’t mind me posting it here.
I can’t remember if Fred ever tested this in Access 2007 but it should not be too difficult to fix if it plays up a bit.

Again, if we don’t mind throwing a bit of VBA at it, charts are quite flexible. See here for a demo.

Chris.

 

[pbcclements]

Hi Chris,

Thanks for that. Rolling my own solution has been considered, but realistically the tight timescales of the project I am on mean that time developing the control is really time lost on implementing the actual graphs themselves. I totally agree with your sentiments though & would go this way if I had a littlem more time.

Kind Regards,

Peter Clements