PDF output not working with MS Access Runtime 2007 (1 Viewer)

P

PaulO

Registered User.

Local time

Today, 17:16

Joined

Oct 9, 2008

Messages

421

• Jul 23, 2010

• #1

Hi

I've created some command buttons to enable users to output straight to PDF format, for subsequent e-mailing etc

However, though these buttons work fine with my 'Master' database (using full licence of Access 2007) they don't with the Runtime version copies?

The error message received is "The format in which you are attempting to output the current object is not available."

Anyone know of this problem, and how to counteract it?

Many thanks!

 

V

vbaInet

AWF VIP

Local time

Today, 17:16

Joined

Jan 22, 2010

Messages

26,374

• Jul 23, 2010

• #2

Let's see the OutputTo code line.

 

P

PaulO

Registered User.

Local time

Today, 17:16

Joined

Oct 9, 2008

Messages

421

• Jul 23, 2010

• #3

Macro commands as follows:-

Action : OutputTo

Arguments:-
Object Type: Report
Object Name: Report1
Output Format: PDF Format (*.pdf)
Output File: (blank ... user to browse for folder and enter file name of their choosing)
Auto Start: Yes



Does this help?

 

ghudson

Registered User.

Local time

Today, 12:16

Joined

Jun 8, 2002

Messages

6,195

• Jul 23, 2010

• #4

The PDF output format is a 2007 add-in that must be installed on your computer. Does the runtime version have that built-in? I do not know but I doubt it if it is not working for your users.

 

V

vbaInet

AWF VIP

Local time

Today, 17:16

Joined

Jan 22, 2010

Messages

26,374

• Jul 23, 2010

• #5

And here's the add-in:

http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

 

P

PaulO

Registered User.

Local time

Today, 17:16

Joined

Oct 9, 2008

Messages

421

• Jul 23, 2010

• #6

OK ... I'll give that a whirl ... still a little puzzled as to how it's a standard feature using full licence but it's not when using Runtime?

 

V

vbaInet

AWF VIP

Local time

Today, 17:16

Joined

Jan 22, 2010

Messages

26,374

• Jul 23, 2010

• #7

On the page where you download the Access 2007 Runtime, under Additional Information it mentions about downloading the add-in. Have another look:

http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

 

P

PaulO

Registered User.

Local time

Today, 17:16

Joined

Oct 9, 2008

Messages

421

• Jul 24, 2010

• #8

The user discovered that he had NEVER downloaded any Windows updates ... so spent a few hours downloading and as if by magic the functionality behind the button suddenly worked?

A good result of course ... but can anyone explain which update will have flicked-the-switch and why?

 

V

vbaInet

AWF VIP

Local time

Today, 17:16

Joined

Jan 22, 2010

Messages

26,374

• Jul 24, 2010

• #9

PaulO said:

A good result of course ... but can anyone explain which update will have flicked-the-switch and why?

Click to expand...

There are hundreds of updates/patches mostly with names beginning with KB... it would be impossible to know which one of those would have caused problems.