C
Can Of Worms
Self:
I am a near 100% self-taught Access user, and can do a fair amount with
Access VBA, however I think that the answer the the below question will
represent another large learning step in working with VBA code. I have alot
of friends and family that are programers of one level or another, however
programing is more of a side hobby that has taken job value within my
completely different career.
Environment:
I am 'attempting' to use the dreaded Access charts ability, to dynamicly
display and update information from queries, which are based on known
Latitude and Longitude points, plotted against satelite images of
geographical areas appropriate to the information they are viewing.
The accuracy of the XY points displaying against the correct location on the
background image relies almost entirely on specific (and known) maximum and
minimum scale values for the X axis and Y axis. Minor deviations in these
values can place data points anywhere from hundreds of yards to several miles
or more off target.
I have tossed about the concept of sending the data to Excel and creating
the chart there, however I have dismissed it due to the general illiteracy of
the individuals that will be using the interface. I need it as simple as
possible for them, even if I have to tie myself and my code in knots to make
it simple. They are huge fans of the "I push and button and it works"
mentality.
Just getting the XY Scatter chart to display properly was a near
nightmare... however I am on to a new step in the process and am at a loss:
Problem:
Until now, I have only used the Object Browser for the standard reference
objects and properties, and do not know how to reference additional libraries
that I link.
In this particular issue, I have linked Microsoft Graph 11.0 library through
the object browser, but have no idea how to call or set the properties of the
graph I am using through that linked library.
I don't even know that I am refering to the problem correctly, as I have
been unable to find assistance from questions other people have posted
through keyword searches. So far, every reference I can find to the issue
either does not take it as far as I need to, or else starts beyond my
knowledge point, making assumptions that I do not know.
Help is greatly appreciated.
I am a near 100% self-taught Access user, and can do a fair amount with
Access VBA, however I think that the answer the the below question will
represent another large learning step in working with VBA code. I have alot
of friends and family that are programers of one level or another, however
programing is more of a side hobby that has taken job value within my
completely different career.
Environment:
I am 'attempting' to use the dreaded Access charts ability, to dynamicly
display and update information from queries, which are based on known
Latitude and Longitude points, plotted against satelite images of
geographical areas appropriate to the information they are viewing.
The accuracy of the XY points displaying against the correct location on the
background image relies almost entirely on specific (and known) maximum and
minimum scale values for the X axis and Y axis. Minor deviations in these
values can place data points anywhere from hundreds of yards to several miles
or more off target.
I have tossed about the concept of sending the data to Excel and creating
the chart there, however I have dismissed it due to the general illiteracy of
the individuals that will be using the interface. I need it as simple as
possible for them, even if I have to tie myself and my code in knots to make
it simple. They are huge fans of the "I push and button and it works"
mentality.
Just getting the XY Scatter chart to display properly was a near
nightmare... however I am on to a new step in the process and am at a loss:
Problem:
Until now, I have only used the Object Browser for the standard reference
objects and properties, and do not know how to reference additional libraries
that I link.
In this particular issue, I have linked Microsoft Graph 11.0 library through
the object browser, but have no idea how to call or set the properties of the
graph I am using through that linked library.
I don't even know that I am refering to the problem correctly, as I have
been unable to find assistance from questions other people have posted
through keyword searches. So far, every reference I can find to the issue
either does not take it as far as I need to, or else starts beyond my
knowledge point, making assumptions that I do not know.
Help is greatly appreciated.