Solved

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

Posted on 2011-02-18
7
1,633 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now