Search results for query: *

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

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

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

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

I built a database, (with the help of many of you)in Access 2000 and now I want to share it out to about 5 to 10 user and let them play around in it, then they'll send me feed back. What is the best way to share the database I'm not ready to split it yet??

Working on Access 2000 I have placef a option group called "SelectProductCategory", On open Form it works great, the defualt setting is Opt1, however, I need the same thing to happen if someone clicks command button i.e., Add Record Undo Record Save Record Etc.. what is the code...

I've been using the Search engine to see if this question ever existed before, but I found nothing. so here goes, I'm using Access 2000 and I'm working in a query, is it possible to create a formula which generates a row number, for each record and records it, for later use?? i.e. 1 2 3 4 etc...

I have a textbox on a form (access2000)that pulls in files from the users C dirve i.e. C:\COdescassy.pdf, now I need a button that will save the pdf drawings into another director as well as the path name this is what I have so far Unbound text box called "txtFileOpen" =...

The statement below works great, now the user want to add in additional requirements when selecting items for example if the user select CAPACITORS, [Composition] is enabled, if Composition ="Aluminum", Turn off [TempCoef] if other than "Aluminum" Turn off [RippleCurrent]...

I'm using Access 2000, Currently I have a CommonDlg allowing the user to search for PDF. files on his/her C drive, and they copy/paste the URL into a text field on a form, below is the code for this function: this works great, however, now they want the database to copy the pdf drawing from the...

I'm trying to pull information from a record and the left function Left([Description2],4) will not work, how do I pull all data before the @ character?? 5A@30VDC 10mA@24VDC 0.01A@24VDC 1A@30VDC etc.... Thanks in advance

Need code for saving changes to a table after user selects Add Record command or Close form command the following code works however, it doesn't update to the table unless I force it See below Private Sub ActiveFormula() Select Case Me!txtInvisible Case "BATTERIES&quot...