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!
DMRyanAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Jeffrey CoachmanMIS LiasonCommented:
<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 CoachmanMIS LiasonCommented:
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 CoachmanMIS LiasonCommented:
See attached screenshot.

Remember, you must open the Report *Specifically* in Report View
untitled.JPG
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.

All Courses

From novice to tech pro — start learning today.