• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 912
  • Last Modified:

Property Not Found Error when exporting to Excel from Access 2007

Hi,

I'm trying to use the wizard in Access 2007 to export a query and create a task in Outlook. The export works fine, but when I try to save the Export and create the task, I get the error Property Not Found. Any suggestions?
0
Twilson46
Asked:
Twilson46
  • 3
1 Solution
 
Patrick MatthewsCommented:
What is your code?
0
 
Twilson46Author Commented:
This is the code for the query. I didn't do code for the export. I used the wizard. How can I see the code that it is trying to write in the wizard?

SELECT [Annual Forecast].[Account Number], [Annual Forecast].Volume, [Annual Forecast].Price, [Volume]*[Price] AS [FY 10-11], [Annual Forecast].[FY 11-12], [Annual Forecast].[FY 12-13], First([Annual Forecast].Description) AS FirstOfDescription, [Acct Number w/ CC].[Revenue/Expense], [Acct Number w/ CC].[Account Description], [Annual Forecast].Manager
FROM [Acct Number w/ CC] INNER JOIN [Annual Forecast] ON [Acct Number w/ CC].[Account Number] = [Annual Forecast].[Account Number]
GROUP BY [Annual Forecast].[Account Number], [Annual Forecast].Volume, [Annual Forecast].Price, [Annual Forecast].[FY 11-12], [Annual Forecast].[FY 12-13], [Acct Number w/ CC].[Revenue/Expense], [Acct Number w/ CC].[Account Description], [Annual Forecast].Manager
ORDER BY ,[Acct Number w/ CC].[Revenue/Expense] DESC,[Annual Forecast].[Account Number];
0
 
Twilson46Author Commented:
Also, if iI do not select to export the formatting and layout, the error changes to query support not available.
0
 
Twilson46Author Commented:
found the problem. Backend was corrupted. Going to have our IT manager move it off of the shared drive.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now