Access report export to Word format lose image and border on the

The UK's most regular instructor-led training courses.
Training information: advanced micorosoft access training · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Urgent Priority · Version 2003

2 posts

ReplyFri 22 Jan 2010, 15:08Delegate Zhi said...

Zhi has attended:
Access Intermediate course
Access Advanced course

Access report export to Word format lose image and border on the

Hi

I have a few reports have been set up in the database, but when I export the reports onto Word, the images and border of tables are missing (not able to export), only left the text on the Word document with correct margin.

Could anyone help me? or VBA code?

Many thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£199	£204
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	8		£75	£80
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

633 posts

ReplyWed 27 Jan 2010, 13:49Trainer Simon said...

RE: Access report export to Word format lose image and border on

Hi Zhi,

Thank you for your question.

As far as I am concerned there has always been a problem with images and border lines not transferring into the word document when you publish the Access report into word.

The reason behind this is the fact that it saves it as a Rich Text Format file extension(.rtf) instead of a word document extension(.doc). This is how Access has always behaved since earlier versions of the application.

One thing you could try is to PDF the report via the Print menu and use any pdf drivers you may have in the list and save it then as a PDF.

I hope this helps.

Regards

Simon

2 posts

ReplyWed 27 Jan 2010, 14:41Delegate Zhi said...

RE: Access report export to Word format lose image and border on

Hi Simon,

Thank you for you reply. It is a solution to PDF the report

However, is there other solution such as VBA code to build the border itself other than PDF it?

As in office, not everyone's desktop has Adobe Acrobat (the writer version), So it is not possible to PDF document when they try to export the report.

So I am hoping to get other solution or VBA Codeto resolve the problem.

Many thanks
Zhi

633 posts

ReplyWed 27 Jan 2010, 17:05Trainer Simon said...

RE: Access report export to Word format lose image and border on

Hi Zhi,

Thank you for your response.

First take out all the existing borders.

To create borderlines you can create a long line of underscore (___) characters within a label instead of drawing a line and this will be exported to the word file.

I suggest you try and copy the picture into the resulting word document afterwards.

Unfortunately writing VBA code would be beyond the scope of the forum as it would take longer than the permitted time to answer forum posts.

I hope this answers your question.

Regards

Simon

Wed 3 Feb 2010: Automatically marked as resolved.

· Microsoft Access, an Efficient Database Tool
· So what's new in Access 2007?
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· How Microsoft Access grows with your company
· MS Access: Access your Personal Information with Ease

Please browse our web site to find out more about
advanced micorosoft access training and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips