Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a chart object
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a chart object
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a chart object
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" wrote in message ... 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" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a chart object
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. "Phil Stanton" wrote: 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" wrote in message ... 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart with VB programming? | Charts and Charting in Excel | |||
Need help with Range object in Macro programming | Excel Programming | |||
Cannot Activate Chart Area in Chart. Chart Object Failed | Excel Programming | |||
Programming code to new object | Excel Programming | |||
Pie chart programming | Excel Programming |