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 11 1813
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?
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?
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?
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.
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.
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
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
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
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: CSDunn |
last post by:
Hello,
I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what...
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to...
|
by: Bob Alston |
last post by:
I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as...
|
by: lorirobn |
last post by:
Hi,
I have a report that works just fine.
Now I would like to add the capability to choose selection criteria to
limit what is displayed. I created several reports that do this, but
they used...
|
by: monskie |
last post by:
Hello to all,
I have a problem which could be trivial to you guys. This
concerns opening several crystal reports on the a crystal
viewer on an ASPX page by calling window.open.
My...
|
by: Dave |
last post by:
On my form I have combo boxes. These combo boxes, after updating
them, populate respective listboxes that are located below the combo
boxes on the same form. I am trying to use a "generate...
|
by: creative1 |
last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
|
by: Studiotyphoon |
last post by:
Hi,
I have report which I need to print 3 times, but would like to have
the following headings
Customer Copy - Print 1
Accounts Copy - Print 2
File Copy -Print 3
I created a macro to...
|
by: Gord |
last post by:
When I open a certain report, it runs some code that generates the records
that will be displayed in that report. This works fine. When I go to print
preview the report it appears that the code...
|
by: akmaRudiliyn |
last post by:
Hi..i am newbie and student in programming,so need help from expert.
Here is what i want to do.
1-I want to create Report System/Reporting System.
2-User must choose database and enter username...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |