Hello,
I have a created a query in Access database and I can view the pivot form of that query by clicking "Pivot Table view" tab at the bottom right of the page.
My question is how to export this view to Excel spreadsheet. What command in VB should I use to do it. Is it at doable?
Thank in advance for helping,
Sarah
sarah2855
Last Activity: Dec 2 '11, 02:48 PM
Joined: May 17 '10
Location:
-
How to export Pivot table view from access to Excel
-
How to create pivot table in access 2007 reports
Hello,
I would like to insert a pivot table in an access report.I was able to create a pivot table chart in Query -> pivot table view but I don't know how to incorporate that in reports. Is this doable at all?
Thanks in advance,
Sarah -
Thanks Neopa,
Yes I'm using DoCmd.TransferS preadsheet() .Sorry I wasn't so clear in my question. My problem was when using TransferSpreads heet() after I open up the excel file I get error message because of the file type. The code I was using is:After I did a little bit of search...Code:DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "TABLE NAME", "FILE PATH", True, "WorkSheet Name"
-
Vb code for Exporting Access table to Excel
Hello All,
I'm looking for the vb code that export an access table to specific worksheet in Excel. I tried to search see if this question was answered before here, but didn't find anything that really relates to this question.
I will appreciate your help,
thanks in advance. -
You are brilliant .Thanks a lot. solved the problemLeave a comment:
-
Bound column in List box
I have a listbox object and I have it bound to column 7 which is orderID. but I don't like order Id to be shown in the listbox. I only would like to see the name and property of that order. Can I make the bound column somehow invisible in listbox?
Thanks in advance, -
You're awesome, I did imported all the objects, and it's working perfectly fine now.
Thanks a lot for you fast help.Leave a comment:
-
I exported that problematic query to blank database as you said, and it worked perfectly fine. Thanks
But I still don't know how to export ALL of my objects in one shot.
Please advise,Leave a comment:
-
How can I export all the forms, tables, queries and reports all together?Leave a comment:
-
Error message running query : Can not open database
Hello everyone,
I'm running a Make-Table Query in Access. They was working fine up intill an hour ago and suddenly now that I'm running the query , I keep getting this error message:
Can not open Database 'Query 1'. This may not be a database that your application recognizes, or the file maybe corrupted.
And if I close access and reopen it , sometimes it works fine then but sometime it gives error... -
Thanks msquared, That resolved my problem....Leave a comment:
-
Autosave Access Forms
How can I disable auto save function in access forms?Currently , If accidentally something is changed in forms, it gets saved automatically without being prompted.
Thanks in advance -
@ Pat: thanks Pat, your solution worked perfectly fine. They are not indexed columns but it's a small database. do you think it's gonna be an issue?...Leave a comment:
-
Latest Date in a group function
I have a table that looks like this:
CustomerID ProductOrdered OrderDate OrderQuantity
0001 ProdA 1/1/2007 3
0001 ProdA 1/1/2008 2
0002 ProdB 1/1/2006 1
I'm only interested the LATEST order of each customer. I'm trying to use SELECT TOP, but somehow it doesn't work with Group function:
...Code:SELECT TOP 1 CustomerID,ProductOrdered,OrderQuantity,
-
Oh and thanks for the trick , it was really helpful.Leave a comment:
-
Thanks Neopa, I changed it to the following code, is that correct? it didn't throw any error message.
p.s: What kind of moderator is Debas!!! No one forced you to reply on the threads !
Code:strSQL = "DELETE FROM tblA WHERE fieldA =" & Chr(34) & name & Chr(34) DoCmd.RunSQL strSQL, -1
Leave a comment:
-
Delete Function
I'm reading Vb code of my ex-colleague and here is what I see
My question is why this is working !!! isn't it lacking one double quotation?? there is one quotation before DELETE but there is no ending quotation!!Code:strSQL = "DELETE FROM tblA WHERE fieldA = """ & name & Chr(34) DoCmd.RunSQL strSQL, -1
-
I got it myself I needed to do:
Code:strSQL = "INSERT INTO temp( ID )" & _ "SELECT ID FROM Customers"Leave a comment:
-
How to Insert data into a table
I have opened a recordset and now I want to copy all the records of that recordset to a table.
This command gives me the list of all Ids in Customer Table.Code:set rs = db.OpenRecordset("SELECT ID FROM Customers")
How can I now Insert this list in to a table? -
Thanks Pat,
I just created an account here. I will definitely look for this topic. If you find it please let me know.
Thanks in advance,
Sarah...Leave a comment:
No activity results to display
Leave a comment: