Recent content by Worsty

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

We developed a small test database that we are using to attempt to connect to a wsdl to consume web services. The database form contains 3 fields and a submit button on the form. At the bottom I've included the code behind the button on the form and the class module code that was generated by...

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

We are about to do a demo of an application and we just needed a way that when we copy a db onto a CD that it looks in the ActiveFolder Path of the Access Database for an Excel File. When we specify the full length of the file in the str Argument it dinds it just fine. How can we change str...

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.

We are so close>>>>>We got the below code to work. We still have the "stop" commands throughout, but that was just to test. We removed the stops and it works fine --- ONCE! ---. If you try to run it again without getting completely out of the database it doesn't work. Any suggestions? Thank...

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?