Programming a chart object

[Phil Stanton]

Sorry for a ramble but
I have an access database that holds information on the location of boats
(Boat Names & Owners) and the XY co-ordinates of the spaces they are stored
in. What I am trying to achieve is to see a map on the Access form of the
area with the spaces and boat owners marked on it. Currently I am using
Excel to link to the database, creating a scatter chart, using Bob Bovey's
chart labeller to label the chart, then outputting the chart as a GIF file
which I display as an image on the Access form. It all works perfectly and
automatically, but what I want to do is eliminate using Excel.
Have got closeish to doing it on occasions, but it is very flaky and not
really working.

daft asking how to eliminate Excel on an Excel newsgroup - but what the
hell.

My first problem is I have set the Rowsource of the chart to the correct SQL
String, but apart from containing the XY data and the labels, I also hold
the position of tha labels relative to the plotted points and also the
orientation.

Sometimes if I view the Chart datasheet, the data is missing and sometimes
it is there.

So could anybody tell me gow to force that datasheet to get the SQL
information

Thanks

Phil

 

[Joel]

Why don't you creat an excel object in Access? The object odesn't even have
to be visible. The code will look like excel without using excel

Put following line in Access VBA Module
Set ExcelSheet = CreateObject("Excel.Sheet")

 

[Phil Stanton]

Thanks for coming back

Assuming that I create this sheet, how does that link up with the plan on
the Access form

Thanks

Phil

 

[Joel]

I've only done a small amout of programming under Access. Doing it this way
allows you to keep all your excel program. You just have to move (or link)
the data from Access to the Excel Object.

To get the data in Access the Database is a table similar to Excel. The
Access table are less flexible that you can't directly get to an Row, Column
location in the table. Instead you have to move down X number of Rows. Then
move Y number of columns.

The problem you were having was to create a chart with Access data. I think
the chart will be easier in an Excel Object.