MS Access Experts. Is this possible...

[SnoopCat]

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.

 

[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.

 

[DannyBoy]

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.

I think it does, but involves the use of certain modules, which get messy and complicated..

 

[SnoopCat]

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.

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?

 

[MrMilney]

Hmm, maybe this will help?

 

[BFG10K]

Anyone know if it is possible to do these kinds of "instant graphs" in access?

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.

 

[zephyrprime]

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.