Solved

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

Posted on 2011-02-18
7
1,658 Views
Last Modified: 2012-05-11
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
Comment
Question by:DMRyan
  • 4
  • 3
7 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 34927568
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
 

Author Comment

by:DMRyan
ID: 34928388
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
 

Author Comment

by:DMRyan
ID: 34928421
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
Independent Software Vendors: 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!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34928822
<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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34929157
Or open your standard Report in "Report View"
(Also where the "Search" functionality is built in...)
0
 

Author Comment

by:DMRyan
ID: 34934315
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34954002
See attached screenshot.

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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question