I have an Access table with 25 fields; when I try to use the transferspreadsheet function to export it to Excel, I keep getting the "Too many fields defined" error. Is there any way to fix this problem? Thanks, Annna
I have 4 columns on a spreadsheet- sample ID, x value, y value, and series (of which there are three). I sort the columns based on series so I can group the data to graph, but I have to resort based on sample ID (to put them back in order). When I do this, the graph data is linked to the cells...
I created a chart in Excel based on an Access query, and I want to resort the data but the source data cells remain the same instead of sorting with the data. Also, I want to reposition and resize the chart in my worksheet. Any help would be greatly appreciated!!
I created an embedded chart next to my data on an exported Excel spreadsheet, but I don't know how to programmatically position it. Is there a property for this?
I have a list box in which I need to access the bound column values when there are multiple selections, and put them in an array. Is there a simple solution for this? Thanks!
I have data in a table, and I would like to display data in groups- for instance I have 10 samples under GroupID#10, and I want to display all of them in one detail instance and create a graph for them. Also, there is info about them, such as name, user, etc. that I would like to display at the...
I have a query that has data that I would like to group by id number and create a xy scatterplot. The query contains my x value, y value and series association. How do I do this in a report? The chart wizard won't let me do it!
PS I'm not allowed to link the tables, do to the general fear that that might create changes to the back-end. In other words, I just need to take a snapshot of the current data. Thanks!
I have a multiple back-end databases because we one db just can't hold all of our data. So, we have db1, db2, etc. I would like to just copy all the tables from the specified back end to my new db (dbNew) that I'm creating so that I can access the data to do my analysis. Is there a relatively...
I have a list box is connected to a field in one of my tables- but sometimes there could be as many as 200 values! I keep getting an error saying that it's too long. Is there any way to accomodate all these choices? I need to have the option of being able to multi-select, too.
I would like to use a SQL statement to add data from one database, DB1, into a table in another database, tblData in DB2. What is the best way to do this? It seems there are many choices that I've read of so far- the IN statement, INSERT, INTO, etc. Thanks!
I just want to preface this message with the fact that I have very limited knowledge of Access reports. That being said, I need to create a scatterplot using data in a query. Is there a simple way to do this? I need to group it based on one of the fields, which could be one of four things...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.