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

the format in which you are attempting to output the current object is not available

I created a Access 2007 database on a shared drive.  I created several macros using the Output To (Table, TAX1042SSumGrpForeign, XPS Format (*.xps), , No, , 0, )  I can use these macros on my pc with no problem but when I have another user try to use the macro on a difference pc they get the following error: the format in which you are attempting to output the current object is not available.  We have service pack 2 installed which was the recommened fix on Microsofts site.  Please help!
0
DMRyan
Asked:
DMRyan
  • 4
  • 3
1 Solution
 
Jeffrey CoachmanCommented:
1. Why are you using the XPS format specifically?
Another format may work directly.

2. Have you installed the PDF/XPS addin?
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041&displaylang=en
This is required in order for you to use this format.
(It is not installed by default)

(I believer you can pick XPS as a macro argument even if the Add in is not installed.)
0
 
DMRyanAuthor Commented:
It would be great if could just use the access reports but there is no way to search on reports so we can either use PDF or XPS and PDF files take forever to search.  XPS is very quick to search through large documents.  I'll have to check to make sure PDF/XPS addin is installed on the other pcs's.  It is installed on my pc.
0
 
DMRyanAuthor Commented:
Another note:  the users having the issue have opened XPS files on their pc.  I won't be able to verify the addin until Tues.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanCommented:
<I won't be able to verify the addin until Tues.>
OK

BTW, why are you trying to search the report.

Why not search the raw data, or the form, ...where Search functionality is built in?
0
 
Jeffrey CoachmanCommented:
Or open your standard Report in "Report View"
(Also where the "Search" functionality is built in...)
0
 
DMRyanAuthor Commented:
Can't search the raw data because our Audit staff can only search the actually forms that will be printed.  These are tax forms and they are not allowed to access data that can be changed.  They need to search the reports so that they can perform audit sampling of the data and forms.  

That would be great if they could search the report view because then we wouldn't need the XPS files.  We can't find a search function while in a report view.  Where is it?
0
 
Jeffrey CoachmanCommented:
See attached screenshot.

Remember, you must open the Report *Specifically* in Report View
untitled.JPG
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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