B
bavjean
Hello,
I am about to start a project where I must link an Access front-end database
to an Oracle backend. I have about a year of Access development behind me
now, and now here is the next challenge.
What I have to do is create analyses of data and output the data mainly in
the form of diagrams (i.e. graphs or charts). I have seen how this can be
done with Automation in Access in a book by Alison Balter (Mastering Access
2000 Development), by controlling the Excel object etc.
Here are my 2 questions:
1. I am considering buying another book on Access now, something that will
contain more examples/methods for presenting information as a graph with the
help of Excel. Should I stick to buying an Access book, or should I look into
getting something that is more Excel programming oriented, i.e. something
like an “Excel programmers compendium� Any recommendations/tips to get me
started would be appreciated.
2. The users want the graphs that I produce to be saved as a .PDF
automatically at the push of a button in the Access GUI. How is this done? Do
I need special software, or can I use something like PDFWriter to
automatically convert the Excel graphs into .PDF’s?
Thanks in advance for the tips and have a nice day! J
J
I am about to start a project where I must link an Access front-end database
to an Oracle backend. I have about a year of Access development behind me
now, and now here is the next challenge.
What I have to do is create analyses of data and output the data mainly in
the form of diagrams (i.e. graphs or charts). I have seen how this can be
done with Automation in Access in a book by Alison Balter (Mastering Access
2000 Development), by controlling the Excel object etc.
Here are my 2 questions:
1. I am considering buying another book on Access now, something that will
contain more examples/methods for presenting information as a graph with the
help of Excel. Should I stick to buying an Access book, or should I look into
getting something that is more Excel programming oriented, i.e. something
like an “Excel programmers compendium� Any recommendations/tips to get me
started would be appreciated.
2. The users want the graphs that I produce to be saved as a .PDF
automatically at the push of a button in the Access GUI. How is this done? Do
I need special software, or can I use something like PDFWriter to
automatically convert the Excel graphs into .PDF’s?
Thanks in advance for the tips and have a nice day! J
J