Search results for query: *

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

Is there any way to check if there is an open ADO connection?

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!

Thanks for the tip! Works like a charm. :)

Is there any way to override alerts in Access, such as there is in Excel: Application.DisplayAlerts=False?

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...

Is there any way to change the query source database using code?

I have data in a query that I want to group on an scatterplot graph, and I want all the data to be displayed next to the graph. Is this possible?

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...