Anybody have any ideas about exporting graphics in MS Access?

Question

Hi - I have written a database that tracks sales, stock etc. As usual, possibly the most simple thing ever is my stumbling block - printing Invoices/Receipts.

Have built the Queries and Reports and written the Export Procedures, but even though the logo appears on the screen and can be printed from within Access, I need it to be exported to an e-mailable format (eg: Word). When I export as RTF it comes out formatted OK, but with the picture missing. Anybody know how to solve this?

Thanks.

Answer 1

We've tried LOTS of different ways, but Access doesn't like to export the images on Reports into any format but .SNP (Windows Snapshot Viewer) which is a Microsoft version of a .PDF



.SNP cannot be edited, but looks EXACTLY like the Access Report as viewed through Access (It's a screenshot).



You could try outputting into HTML, but You'll need an HTML Template with the images & formatting already on it, and Access will basically just export the data to it.



Or You can try researching in the MIcrosoft Knowledge base. It's free and might have an article on doing just that...

Answer 2

Access should provide an export to Word (.doc) format or something. If not you could try exporting to Excel however this would be less than ideal.



The RTF format is fairly particular about it's image data, so Access may not be exporting correctly. Alternatively it may be the application you are opening it in is just not rendering it correctly (I think RTF defaults to Wordpad). Try opening it in Word if so.



You could also open it is notepad if you are game, and searching for \bin or \blip as I believe they represent images in the RTF document. You would at least know then if they are exporting correctly.

Answer 3

get admission to definitely has a outfitted-in menu option to do precisely this. collectively as viewing the end results of your question, pass to kit > place of work links > examine w/ Excel. this could export your question consequences into an Excel spreadsheet. (above menu determination is in line with place of work 2003. place of work 2007 has this selection besides, yet could be below a diverse menu)

Answer 4

poofter