Search results for query: *

Tom pdfMachine by BroadGun SW totally ROCKS!!!! Thanks again

Thanks Tom, I think I'm going to scrap what I have and try what u have suggested...wish me luck

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...

Thank you......

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??

Couldn't have done it with out all of you. Thanks you so very much.

Thanks Frink, that did the Trick!!

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...

Brilliant!!!!! Thanks it works Great.

If I leave DS_X2 field empty then click on Move PDF Files the Code highlites "StrFile2 = Me.DS_X2.Value" Else If I leave DS_X4 field empty then click on Move PDF Files the Code highlites "StrFile2 = Me.DS_X4.Value"

I ran the code but I got the following error message "Run-time Error '94' Invaild use of Null

Again, with the help of many of you, I'm able to copy files from one dir C;/ to another dir K:/. But if any of the fields are empty, the code stops and goes into debug mode and I'm unable to get the code to handle a null field The only field required is DS_X1 the rest of the fields DS_X2...

I was given a Access 2000 database and at the time, the KB was around 20,000. Now its up to 500,000 KB, what causes this and is it dangerous??