January 30th, 2003, 05:14 PM
Using graphs from ms access
I have to design a database in access so that graphs based on tables/queries could be displayed on demand.
Should i use VB as glue between access and excel or is there a better (easier) way to implement this?
The database is not large, about thousand fields altogether.
Im just a beginner in this. as you can see, so any advice is greatly appreciated.
January 30th, 2003, 05:20 PM
VBA and/or ODBC are the glue between access and excel. but you can use access-tables instead of excel-tables and save yourself from headache...
January 30th, 2003, 05:32 PM
I'll dig into it
And all those suggestions still are welcome.. have not had to mess with graphics in access yet.
This must sound real stupid... he he won't save you from laughing your head off.
Last edited by biaz; January 30th, 2003 at 05:37 PM.
January 30th, 2003, 05:44 PM
i guess noone who ever did VBA can laugh about it... unless he managed to abandon it!
really, itīs no fun... VBA imho is a mess of a programming language. i did one professional project, and i know i wonīt do a second one
January 30th, 2003, 07:47 PM
Now, basicly this graphis is nothing but a query put out nicely in colours, if you only could redirect me to code if there is such available in large, or post about your former experience.
Or suggest to RTFM with a link.
January 31st, 2003, 12:28 AM
maybe somewhere here http://msdn.microsoft.com/code/ but to tell you the truth, this was around 1997 when i did that project. so:
- VBA might be much better to handle and more stable today
- i really canīt remember any details
i "learned" VBA then knowing basic and windows quite well and using the online-help. some reasonable guesses (stuff like "Excel.Worksheets.CurrentWorksheet.Cells[0,0]" just seemed logical to me...) and the code completion feature also helped a lot.
hope this helps a little for the start... for bigger projects, i recommend buying a book. Also now i have MS Office, "Developer Edition" that came with tons of documentation... Primarily the MSDN cdroms, so anything interesting *should* be found on the link above...
January 31st, 2003, 04:52 AM
Thank you for your time