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

B

Belle

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.
 
B

Belle

Steve, thank you for the information but I cannot figure out how to work that
application! Have you used this app before?
 
S

Steve Schapel

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.
 
L

Larry Linson

"Belle" wrote
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.
Click to expand...

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
 
M

MikeC

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.
 
Top