• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Access Experts. Is this possible...

S

SnoopCat

Senior member
I have to make an access database that will get numerical data inputted from the user and then have a button on the form that when pressed will be able to show a basic line/bar graph that pertain to the data. I know that this is easily possible in excel, but I would like to use access because there is going to be various data that I will need to record. Anyone know if it is possible to do these kinds of "instant graphs" in access?

I would like the graphs to be produced with the least amount of effort by the user. For example, i hope the user doesnt need to do alot of side work for the graph to be produced.
 
Your best bet would probably be to write some VBA code that will actually take your data form Access, export it to Excel then chart it there. To the best of my knowledge, Access doesn't have any inherent charting capability.
 
Originally posted by: MrMilney
Your best bet would probably be to write some VBA code that will actually take your data form Access, export it to Excel then chart it there. To the best of my knowledge, Access doesn't have any inherent charting capability.
Click to expand...

I think it does, but involves the use of certain modules, which get messy and complicated..
 
Originally posted by: MrMilney
Your best bet would probably be to write some VBA code that will actually take your data form Access, export it to Excel then chart it there. To the best of my knowledge, Access doesn't have any inherent charting capability.
Click to expand...



Im new to VBA/MS Access, this project is more of a learning experience for me. Is VBA code flexible enough to automatically....

take the data from access
export it to excel
plot the graph in excel

... all in a single click of an access form button?
 
Anyone know if it is possible to do these kinds of "instant graphs" in access?
Click to expand...
Absolutely. Just design a simple report and then insert a graph into it. Then follow the prompts in the wizard.

Also you'll need a table or query that contains the information you want to graph.
 
It should be possible. If nothing else, you could always put an excel graph into access. All the MS office products are very flexible in this way.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top