Recent content by Tidy

I think the problem might be with your parameter setting. Are you setting the parameter from a drop down box or a text field that users will input? If so you need to set the parameter to the control source like this [Forms]![FormName]![txtbox1] this will pull make the parameter pull the data...

When ever I export data from access to excel I use "CopyFromRecordset". I use this method so I can run query and import only the data I need. The code would look like this Dim dbs As Variant Dim objExcel As Excel.Application Dim objxlBook As Excel.Workbook Dim objxlSheet...

Anyone know how to fix this.

Good Morning To All, I am having a problem an excel pivot chart that I'm building using data from Access. I am putting 3 graphs in one worksheet, but when I add the second sheet the ".SetSourceData" is not working correctly. This is causing my 2nd Graph to link to my first graph. The below code...

I found the answer after hours of searching the web and playing with the code. If anyone else has run into this problem here is the answer. 'Set PIVOT CHART Location by Height/Width and Left/Top objxlBook.ActiveSheet.ChartObjects("Chart 1").Left = Cells(11, 2).Left...

SMH, are my questions always unanswerable LOL.

I would put the results of the data you pull into a query and select "Unique Records = Yes" this should remove the duplicate entries.

Have you tried a "Select Case" yet.

Good Morning, I have a quick question. Is there anyway to move an "Excel Pivot Chart" (The actual chart) around using VBA in access. I'm trying to mount the chart on a certain position of my spreadsheet but with no luck. I can't find any code that will set the charts location. If anyone...

Can you reword your message above. I'm trying to understand your problem.

I believe what you are trying to do is possible. You would have to create a database connection to all the seperate databases. I would try making the connections using "DAO" connections.

sorry about that I mean "copyFromRecordSet"

Thanks for the feedback. I got the queries to pull data from my access database into excel using the copyRecordset function. I am using the qryDef so I can delete the data to free up space. I am having to pull serveral queries into this spreadsheet to get all the data I need.

I found a way to populate data using the ".CopyFromRecordSet" excel function. Does anyone know if there is any other way of doing this.

I think I may have posted this in the wrong spot before. But here goes: Good Morning Everyone, Can any one tell how to pull information from a QueryDef and make it populate into fields in excel. I have all of the code working up into this point but I do not know how to add the information...