I did a search on "Save Report to PDF file and I followed the messages and now I'm stuck when I click on my button I get the folowing message box "Error Creating PDF File"
Button code below
Private Sub SaveReportToPDF_Click()
Call PrintReportToPDF("rptRFQResponseLetter", "RFQ Response...
below is code that PHV wrote and it works great, however my users want to add a another feature, save the report as a pdf file, as it stands when the user run this fuction it ask them to select a format MS Excel...HTML ...RTF Snapshot etc.. is there a way to set the report with the pdf...
Acccess 2000
I created a button to send a email preloaded with the following information
... auto fill email address
... auto fill subject
... auto attach file
below is my poor atempt at coding this
Private Sub cmdEmailNew_Click()
On Error GoTo Err_cmdEmailNew_Click
'Dim stDocName As...
working with Acesss 2000 I have a form with two control list based on a queries. the first control box is a simple query, the second is a cross tab query, when I double click on ctlListOne I want the second query to come up with related data this is what I did
I placed the following in the...
Below is the code that many of you helped me, it is designed to do the following
Take drawings from directory C:\ and Transfer them to Dir F:\ The code copies and paste the drawing and list the new name e.g. FROM: C:\Drawing1.pdf To: F:\Drawing1.pdf
What dosn't work is, when the user click on...
Anyone ever seen this, I have a Path K:\C0Riser-assy.pdf and when I click on it, It doesn't bring up the drawing, instead is show a tiny box below the hand??
Hmmmmmmmmmmmmm, I place in the your code and ran it now I get the following error message
"Error#:424 Object Required, Copy Failed"
below is the revised code
Private Sub cmdMoveFiles_Click()
On Error GoTo ErrorX
Dim x As SHFILEOPSTRUCT
Dim StrFile As String
StrFile =...
Hmmmmmmmmmmmmm, I place in the your code and ran it now I get the following error message
"Error#:424 Object Required, Copy Failed"
below is the revised code
Private Sub cmdMoveFiles_Click()
On Error GoTo ErrorX
Dim x As SHFILEOPSTRUCT
Dim StrFile As String
StrFile =...
The code below moves the drawing from Drive C:\ to Drive K:how do I get the path to recongize the new path e.g.
K:\ inplace of C:I'm going crazy, hope someone can help.
Private Sub cmdMoveFiles_Click()
On Error GoTo ErrorX
Dim x As SHFILEOPSTRUCT
Dim StrFile As String
StrFile =...
The code below copies and paste drawing from one location to another. e.g.
From: C:\filename1.pdf
To: K:\filename1.pdf
but the field storing this information, still shows the old path C:\filename1.pdf
how do I get the field to store the new path location K:\filename1.pdf?
Option Compare...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.