G
Guest
Hi guys,
I want to graph a table and I am battling. It seems quite easy in Excel, but
Access is not so easy. I have 2 problems that I need help with...........
1. I have tried placing a Microsoft Chart ActiveX in a report and then
linking it to a table in my database through MS Jet 4.0 OLE DB
Provider(which I understand is a fancy way of telling the computer to use
Access). The problem is I get an error that the Database that I wanna link
to is already open which I know as I am trying to chart my data. How do I
link the data to a table in my open or current database? I suspect that when
I get this solved it will give me the same result as discussed in my next
problem.......
2. When using the insert chart wizard, I end up with an error that I have
too many crosstab column headers. Excel has no problem graphing the data, so
is this a limitation in Access or is there a way around the problem?
Ok......thanks for the help guys!
Kenny
I want to graph a table and I am battling. It seems quite easy in Excel, but
Access is not so easy. I have 2 problems that I need help with...........
1. I have tried placing a Microsoft Chart ActiveX in a report and then
linking it to a table in my database through MS Jet 4.0 OLE DB
Provider(which I understand is a fancy way of telling the computer to use
Access). The problem is I get an error that the Database that I wanna link
to is already open which I know as I am trying to chart my data. How do I
link the data to a table in my open or current database? I suspect that when
I get this solved it will give me the same result as discussed in my next
problem.......
2. When using the insert chart wizard, I end up with an error that I have
too many crosstab column headers. Excel has no problem graphing the data, so
is this a limitation in Access or is there a way around the problem?
Ok......thanks for the help guys!
Kenny