Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2011-02-18
7
1,648 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 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