By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

pdf report

P: n/a
pol
Hi,

i read an interesting article to print an access-report and save into an
pdf-file. (http://www.excelguru.ca/node/68)

I use ac2000 but it he does't recognize the pdfcreator. The printer is
installed and is the selected printer of the report .
I wonder if i need some specific reference to achieve this.

regards,Pol
Dec 4 '06 #1
Share this Question
Share on Google+
11 Replies


P: n/a

pol wrote:
Hi,

i read an interesting article to print an access-report and save into an
pdf-file. (http://www.excelguru.ca/node/68)

I use ac2000 but it he does't recognize the pdfcreator. The printer is
installed and is the selected printer of the report .
I wonder if i need some specific reference to achieve this.

regards,Pol
Several questions, if I may.
1 Have you downloaded and installed PDFCreator?
2 Have you set a reference to PDFCreator in the references?
3 Have you changed the report name
and 4 Have you changed the path name?

Dec 4 '06 #2

P: n/a
pol
Hi,
here the answers to your questions,
1 . I've downloaded the pdfcreator
2. I don not know which reference i need to select.
3 & 4 i changed the name of the report , and the report path is the same.

thx, pol
"Tanis" <dn*****@accuride.comschreef in bericht
news:11*********************@80g2000cwy.googlegrou ps.com...
>
pol wrote:
>Hi,

i read an interesting article to print an access-report and save into an
pdf-file. (http://www.excelguru.ca/node/68)

I use ac2000 but it he does't recognize the pdfcreator. The printer is
installed and is the selected printer of the report .
I wonder if i need some specific reference to achieve this.

regards,Pol

Several questions, if I may.
1 Have you downloaded and installed PDFCreator?
2 Have you set a reference to PDFCreator in the references?
3 Have you changed the report name
and 4 Have you changed the path name?

Dec 4 '06 #3

P: n/a
pol
Hi again
i reveived next error: "Dim prtDefault As Printer." I seems mine acess does
not recognize the Printer .

many regards, pol
"pol" <po*@m1236m.djschreef in bericht
news:45**********************@news.skynet.be...
Hi,
here the answers to your questions,
1 . I've downloaded the pdfcreator
2. I don not know which reference i need to select.
3 & 4 i changed the name of the report , and the report path is the same.

thx, pol
"Tanis" <dn*****@accuride.comschreef in bericht
news:11*********************@80g2000cwy.googlegrou ps.com...
>>
pol wrote:
>>Hi,

i read an interesting article to print an access-report and save into an
pdf-file. (http://www.excelguru.ca/node/68)

I use ac2000 but it he does't recognize the pdfcreator. The printer is
installed and is the selected printer of the report .
I wonder if i need some specific reference to achieve this.

regards,Pol

Several questions, if I may.
1 Have you downloaded and installed PDFCreator?
2 Have you set a reference to PDFCreator in the references?
3 Have you changed the report name
and 4 Have you changed the path name?


Dec 4 '06 #4

P: n/a

pol wrote:
Hi again
i reveived next error: "Dim prtDefault As Printer." I seems mine acess does
not recognize the Printer .

many regards, pol
"pol" <po*@m1236m.djschreef in bericht
news:45**********************@news.skynet.be...
Hi,
here the answers to your questions,
1 . I've downloaded the pdfcreator
2. I don not know which reference i need to select.
3 & 4 i changed the name of the report , and the report path is the same.

thx, pol
"Tanis" <dn*****@accuride.comschreef in bericht
news:11*********************@80g2000cwy.googlegrou ps.com...
>
pol wrote:

Hi,

i read an interesting article to print an access-report and save into an
pdf-file. (http://www.excelguru.ca/node/68)

I use ac2000 but it he does't recognize the pdfcreator. The printer is
installed and is the selected printer of the report .
I wonder if i need some specific reference to achieve this.

regards,Pol

Several questions, if I may.
1 Have you downloaded and installed PDFCreator?
2 Have you set a reference to PDFCreator in the references?
3 Have you changed the report name
and 4 Have you changed the path name?
You need to set a reference to PDFCreator in the references first. Go
to modules. Click on new or design, it don't matter which. Click on
tools. Click on references. You will be presented with a drop down box.
Scroll down to PDFCreator in the list. Check the box and click OK. Now
run the sub again.

Dec 5 '06 #5

P: n/a
pol
Hi,
I'am very greatfull to your help with mine problem.
It seems the problem here is that i 'am still working with ac2000. He does
not recognize the printer.object.
The reference to the pdf-creator is now selected.

Now i have to solve the printer object problem.
any suggestions ?
thx, pol

"Tanis" <dn*****@accuride.comschreef in bericht
news:11********************@n67g2000cwd.googlegrou ps.com...
>
pol wrote:
>Hi again
i reveived next error: "Dim prtDefault As Printer." I seems mine acess
does
not recognize the Printer .

many regards, pol
"pol" <po*@m1236m.djschreef in bericht
news:45**********************@news.skynet.be...
Hi,
here the answers to your questions,
1 . I've downloaded the pdfcreator
2. I don not know which reference i need to select.
3 & 4 i changed the name of the report , and the report path is the
same.

thx, pol
"Tanis" <dn*****@accuride.comschreef in bericht
news:11*********************@80g2000cwy.googlegrou ps.com...

pol wrote:

Hi,

i read an interesting article to print an access-report and save into
an
pdf-file. (http://www.excelguru.ca/node/68)

I use ac2000 but it he does't recognize the pdfcreator. The printer
is
installed and is the selected printer of the report .
I wonder if i need some specific reference to achieve this.

regards,Pol

Several questions, if I may.
1 Have you downloaded and installed PDFCreator?
2 Have you set a reference to PDFCreator in the references?
3 Have you changed the report name
and 4 Have you changed the path name?
You need to set a reference to PDFCreator in the references first. Go
to modules. Click on new or design, it don't matter which. Click on
tools. Click on references. You will be presented with a drop down box.
Scroll down to PDFCreator in the list. Check the box and click OK. Now
run the sub again.

Dec 5 '06 #6

P: n/a
On Tue, 5 Dec 2006 20:12:54 +0100, "pol" <po*@m1236m.djwrote:
>Hi,
I'am very greatfull to your help with mine problem.
It seems the problem here is that i 'am still working with ac2000. He does
not recognize the printer.object.
The reference to the pdf-creator is now selected.

Now i have to solve the printer object problem.
any suggestions ?
thx, pol
Why not try Stephen Lebans ReportToPDF utility. It works brilliantly and no PDF
drivers / printers are required. See -

http://www.lebans.com/reporttopdf.htm
Wayne Gillespie
Gosford NSW Australia
Dec 5 '06 #7

P: n/a
pol
Hi,
it's a very usefull tip. thankx,
I'am just strubling with the fact that i want to save the pdf report without
any handling of the custumer. The filename is the name of a public Variable
"varFactid" with the extension pdf. The fileshowdialog must been stay hidden
to prevent an incorrect filename.
Will you show where i have to put this variable into the code ?
grtz, Pol
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.auschreef in bericht
news:jg********************************@4ax.com...
On Tue, 5 Dec 2006 20:12:54 +0100, "pol" <po*@m1236m.djwrote:
>>Hi,
I'am very greatfull to your help with mine problem.
It seems the problem here is that i 'am still working with ac2000. He
does
not recognize the printer.object.
The reference to the pdf-creator is now selected.

Now i have to solve the printer object problem.
any suggestions ?
thx, pol

Why not try Stephen Lebans ReportToPDF utility. It works brilliantly and
no PDF
drivers / printers are required. See -

http://www.lebans.com/reporttopdf.htm
Wayne Gillespie
Gosford NSW Australia

Dec 6 '06 #8

P: n/a
On Wed, 6 Dec 2006 13:58:20 +0100, "pol" <po*@m1236m.djwrote:
>Hi,
it's a very usefull tip. thankx,
I'am just strubling with the fact that i want to save the pdf report without
any handling of the custumer. The filename is the name of a public Variable
"varFactid" with the extension pdf. The fileshowdialog must been stay hidden
to prevent an incorrect filename.
Will you show where i have to put this variable into the code ?
grtz, Pol
See this thread for a work around.

http://tinyurl.com/ync7lo

Wayne Gillespie
Gosford NSW Australia
Dec 6 '06 #9

P: n/a
pol
Hi,
wayne and Tanis
Mine problem is solved. The pdf is saved into the wanted directory with the
correct name automaticly. Great !
many thkx, Pol
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.auschreef in bericht
news:s8********************************@4ax.com...
On Wed, 6 Dec 2006 13:58:20 +0100, "pol" <po*@m1236m.djwrote:
>>Hi,
it's a very usefull tip. thankx,
I'am just strubling with the fact that i want to save the pdf report
without
any handling of the custumer. The filename is the name of a public
Variable
"varFactid" with the extension pdf. The fileshowdialog must been stay
hidden
to prevent an incorrect filename.
Will you show where i have to put this variable into the code ?
grtz, Pol

See this thread for a work around.

http://tinyurl.com/ync7lo

Wayne Gillespie
Gosford NSW Australia

Dec 6 '06 #10

P: n/a
pol
Hi again
a next problem turn on eg the reeiver can change the new pdf-file.
I will send the custemer new pdf-file , made in access, but the receiver may
not have the possibilty to change the pdf-file .
Perhaps i can give the pdf -file a password to write instruction, an no
password to simply read & print the pdf.. Is there somewhere a place into
the code where i can achieve this ?

grtz pol

"Wayne Gillespie" <be*****@NOhotmailSPAM.com.auschreef in bericht
news:s8********************************@4ax.com...
On Wed, 6 Dec 2006 13:58:20 +0100, "pol" <po*@m1236m.djwrote:
>>Hi,
it's a very usefull tip. thankx,
I'am just strubling with the fact that i want to save the pdf report
without
any handling of the custumer. The filename is the name of a public
Variable
"varFactid" with the extension pdf. The fileshowdialog must been stay
hidden
to prevent an incorrect filename.
Will you show where i have to put this variable into the code ?
grtz, Pol

See this thread for a work around.

http://tinyurl.com/ync7lo

Wayne Gillespie
Gosford NSW Australia

Dec 7 '06 #11

P: n/a
Hi everyone

I'e tried this in an ac2003 enviroment, but i enter an error. On the side
there is a mention it should be working also in office 2003, or ma i wrong ?
grtz, Maxwel
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.auschreef in bericht
news:s8********************************@4ax.com...
On Wed, 6 Dec 2006 13:58:20 +0100, "pol" <po*@m1236m.djwrote:
>>Hi,
it's a very usefull tip. thankx,
I'am just strubling with the fact that i want to save the pdf report
without
any handling of the custumer. The filename is the name of a public
Variable
"varFactid" with the extension pdf. The fileshowdialog must been stay
hidden
to prevent an incorrect filename.
Will you show where i have to put this variable into the code ?
grtz, Pol

See this thread for a work around.

http://tinyurl.com/ync7lo

Wayne Gillespie
Gosford NSW Australia

Dec 8 '06 #12

This discussion thread is closed

Replies have been disabled for this discussion.