Search results for query: *

I am sorry if I did something to bother you and or any of the other members. I ALWAYS say thank you up front for any help that the group can provide. In the future I will attempt to Officially do this. I didn't know that this was something was supposed to be done.

In this thread707-1119207 we are using the code to create a pdf from an access report and that works great except it it creating 1 pdf for all the records. How would I change this code to loop through a record set and create individual pdf's from that record set. Any help is great! ' Code...

The form I'm creating is a Acrobat Designer 9.0 form. In the properties of the form fields you can make the field "required" which then will show a outlined box around the form field to give a visual to the user that the form field must be filled in. The issue is that the form field is only...

I have a radio button group and when radiobutton1 is selected and had a value of "1" then I would like to make txtbox1 "required". Can someone help me with the code? Thanks

...exactly what we should be putting in our Access 2003 application to make this work. Can anyone help us out with the code in VBA to do this! *&*************************************** From the form I click on a submit button. This is the code behind the button: Private Sub Submit_Click()...

I'd like to run a script using batch processing that goes to folder that is specified in the script,opens the file, then goes to a second folder, which is specified in the script, looks for a file with the same number 8922222 in the pdf file name and adds that file to the source file as a second...

Thanks so much! That did it.....

...to: str = CurrentProject.Path & "Quote_Template_File.xls" but I get the following error: External table is not in the expected format. Thanks ********************************************************* On Error GoTo EXPORT_TEST_Err Dim str As String str = "X:\Test\SDS_DB\" &...

We've created an application in Excel 2000 that has as part of it's code the following: Dim OL As Object, MailSendItem As Object 'Other code in here doing other things and then Application.Dialogs(xlDialogSendMail).Show In OL2002 the above works great. No errors, but some of our users are...

Chance: Thanks so much for your help! We'll do some research.

When I set break on All Errors it broke here in the RidesMergeWord Function Set wordApp = GetObject(, "Word.Application") I got a Runtime Error429 ActiveX Component can't create object

We have it in a module in Access.

...you try to run it again without getting completely out of the database it doesn't work. Any suggestions? Thank you so much! You've been great! ****Word Module********* Function RidesMergeWord(strDocName As String) ' This code takes a word document that has been setup as a MERGE...

Declaring it Public doesn't work either. It changes the text fields to placeholders but never changes them back. So, I went back to basics and created a test word document with text fields in it and connected it to an Excel workbook as the mail merge data source. Put the original code behind...

I don't know how to do this. Would you explain where to publicly declare them and how, please?

...= wordApp.Documents.Open(strDocName) clsRidesPBar.IncOne ' step 3, doc is loaded strActiveDoc = wordApp.ActiveDocument.Name ****************************************************** 'CALLS CODE TO CHANGE WORD DOC TEXT FIELDS TO PLACEHOLDERS-----THIS WORKS!!!! Call...

...Selection.TypeText "<" & fFieldText(1, iCount) & "PlaceHolder>" ' Increment icount iCount = iCount + 1 End If Next aField ****************************************** Inserted my mail merge code and then placed the rest of the code after my mail merge. It never changes the...

This is all I get??? <Text1PlaceHolder> <Text2PlaceHolder> <Text3PlaceHolder> <Text4PlaceHolder> <Text5PlaceHolder> <Text6PlaceHolder> Which is running the first part of the macro and changing the test form fields to the above, but it doesn't then change them back to form fields.

The first function works and replaces all of my form fields with "<Text2PlaceHolder>" but the second sub "Sub doFindReplace" doesn't do anything. I don't know what I am doing wrong. I tried to call the second sub, nothing. Any ideas?

I checked out your code for inserting data with bookmarks. Is there anyway we could use a bookmark to insert a form field?