Access Dashboard

[MattioMatt]

In need of some help and guidance.

I'm looking to create a dashboard form, I did anticipate to use the built in graph functionality to create this based on queries I had made. I'm currently having a problem with the graph functionality where I get the following "Automation Error Library Not Registered".
I've logged this with the help desk at work several weeks ago but unfortunately haven't had a response or solution yet.

Therefore I am needing to create the dashboard without these graphs and instead in some text format. I'd like to be able to display the results of multiple queries on one form and this is where I think I am going to face problems as I don't think this can be done on an unbound form?

I'm looking for any help/guidance or examples of dashboards in access where I can product the output I am looking for.

 

[Minty]

A lot will depend on the complexity of the underlying queries and how frequently you want it to be updated, but you can easily create a number of queries to do the leg work, and return dashboard values.

Then simply either dump those values into a temp table and bind your dashboard to that, or use a DLookup on the table or query to populate the value. The DLookup will be slower if you have many different sources.

 

[HiTechCoach]

In need of some help and guidance.

I'm looking to create a dashboard form, I did anticipate to use the built in graph functionality to create this based on queries I had made. I'm currently having a problem with the graph functionality where I get the following "Automation Error Library Not Registered".
I've logged this with the help desk at work several weeks ago but unfortunately haven't had a response or solution yet.

Therefore I am needing to create the dashboard without these graphs and instead in some text format. I'd like to be able to display the results of multiple queries on one form and this is where I think I am going to face problems as I don't think this can be done on an unbound form?

I'm looking for any help/guidance or examples of dashboards in access where I can product the output I am looking for.

I build a dashboard using lots of bound sub forms and/or sub reports on an unbound form.

This might be helpful:

Using Dashboard Graphics in Access

Let’s face it, Access isn’t typically a tool you would think of when considering a dashboarding platform. The reporting tools in Access, as slick as they are, don’t lend themselves to visualizations.

That is, Access doesn’t offer a whole lot in the way of dashboarding graphics. Sure, it has charts and conditional formatting, but nothing like Excel.

Also, check out:

Dashboard Builder for Microsoft Access

 

[MattioMatt]

Thanks both, I've gone for a mixture of both solutions as I have quite a lot of data sources I want to pull into the dashboard. Thanks so much to you both for all of the help!

 

[HiTechCoach]

You're welcome.

Glad we could assist.