Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Is there an Access Report format that can be modified and NOT jus.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Belle - 09 Oct 2004 07:59 GMT
Is there an Access Report format that can be modified and NOT just viewed as
is the case with Snapshot Viewer?  Both Word and Excel loses the format when
an Access report is exported.
Steve Schapel - 09 Oct 2004 09:45 GMT
Belle,

This may be of interest... http://www.lebans.com/ReportUtilities.htm

Signature

Steve Schapel, Microsoft Access MVP

> Is there an Access Report format that can be modified and NOT just viewed as
> is the case with Snapshot Viewer?  Both Word and Excel loses the format when
> an Access report is exported.
Belle - 09 Oct 2004 10:08 GMT
Steve, thank you for the information but I cannot figure out how to work that
application!  Have you used this app before?

> Is there an Access Report format that can be modified and NOT just viewed as
> is the case with Snapshot Viewer?  Both Word and Excel loses the format when
> an Access report is exported.
Steve Schapel - 11 Oct 2004 08:40 GMT
Belle,

Yes, I have used it before, and it has been ok, but not perfect.  I
think the real answer to your original question is that no matter what,
if you want a report to retain all the formatting and graphics, and at
the same time be editable, this is difficult to achieve.  With Stephen
Lebans' utility that I referred you to, you have to put the ReportSpecs
mde file on your computer, and set a Reference to it from your
application.  And then, I'm not experienced enough myself to advise
specifically, so all you can do is play around with the ReportUtilities
form in the mdb file which is included in the download, try out the
various options, and see if you can figure out how to make it do the
same thing in your database.

Signature

Steve Schapel, Microsoft Access MVP

> Steve, thank you for the information but I cannot figure out how to work that
> application!  Have you used this app before?
>
>>Is there an Access Report format that can be modified and NOT just viewed as
>>is the case with Snapshot Viewer?  Both Word and Excel loses the format when
>>an Access report is exported.
Larry  Linson - 12 Oct 2004 02:53 GMT
> Is there an Access Report format that
> can be modified and NOT just viewed
> as is the case with Snapshot Viewer?
> Both Word and Excel loses the format
> when an Access report is exported.

I have had _better_ luck exporting to HTML, but it still is not completely
accurate. As Steve said, there is no Access Report export that is.

When you export to "Word", you are exporting an RTF (Rich Text Format) file,
and that export mechanism does not include graphics and pictures, although
RTF does allow them. I assume the same is true with Excel.

 Larry Linson
 Microsoft Access MVP
MikeC - 12 Oct 2004 04:06 GMT
Belle,

If you have not already done so, another alternative you might want to
consider is using a data access page if your version of of Access supports
data access pages.  I recommend this option *only if* your intended users
have network or internet access to your existing database.

The online help in Access XP (that's what I have) provides a side by side
comparison of forms, reports and DAPs under the below heading in the
"Contents" tab:

Data on the Web
    Data Access Pages
         Differences between forms, reports, and data access pages

The path to the above info may vary depending on your version of Access.
Other DAP topics are adjacently listed.

The down side is that you would need to re-create your report as a DAP, but
that might not be so bad.  To save time/effort, and if the design of your
report is relatively simple, it may be feasible for you to simply save it as
a DAP.  I have had mixed results with this technique especially for more
complex reports, but I usually try it just to see if it will save me time.
The results are usually interesting, even if I have to do some extra
tweaking.  ;-)

You can save a report as a DAP by following the below steps:

1)  Right mouse click on your report in the database window.
2)  Choose "Save As..."
3)  Enter a name for your DAP and select "Data Access Page" in the 2nd combo
box.
4)  Click OK.
5)  Choose a folder where the htm file will be stored and click Save.

The new DAP should display automatically and will also be listed in the
"Pages" group in your database window.  The amount of additional work will
largely depend on the design/complexity of your original report.

Once your report has been converted, you should gain most, if not all, of
the functionality you want...*assuming* your intended users have
network/internet access to your database.

> Is there an Access Report format that can be modified and NOT just viewed
> as
> is the case with Snapshot Viewer?  Both Word and Excel loses the format
> when
> an Access report is exported.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.