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

...below where copied from a early request and response session dealing with the same issue and place in my module section. hope someone can help ' ********Module One titled PDF Export *********** Public Sub PrintReportToPDF(sReportName As String, sPDFFileName As String, sFileAttachment As...

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

...happens what should happen is the drawing opens. Please help I'm ready to give up on VB altogether Option Compare Database '**************START CODE***************************** Private Const FO_COPY = &H2 Private Const FOF_SIMPLEPROGRESS = &H100 Private Const FOF_NOCONFIRMATION = &H10...

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

...True On Error GoTo HandleErrors ' Set three pairs of values for the Filter. cdl.Filter = _ "Adobe Acrobat Document (*.pdf)|" & _ "*.pdf|" & _ "Database files (*.mdb, *.mde, *.mda)|" & _ "*.mdb;*.mde;*.mda|" & _...

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

...True On Error GoTo HandleErrors ' Set three pairs of values for the Filter. cdl.Filter = _ "Adobe Acrobat Document (*.pdf)|" & _ "*.pdf|" & _ "Database files (*.mdb, *.mde, *.mda)|" & _ "*.mdb;*.mde;*.mda|" & _...

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