Recent content by abenitez77

I am using powershell to check a folder and when a file gets added to the folder, it queries a sql table and if there hasn't been a file added in the last 6 hours then it will send an email to several people letting them know that the file was copied/uploaded to that folder. I can send the...

No bookmarks on the file that I am aware of. What is a tag? there are labels "Contract Name" to the left of the actual contract name. Is that what you mean?

I have about 1,000 pdf files and each file has about 50 pages. I want to split/extract the pages out of each file onto it’s own file (should be 1-3 pages). The pdf file contains Contract Name. I want the file to print every time it finds a new contract name. It is usually 1 contract per page...

I have about 1,000 pdf files and each file has about 50 pages. I want to split/extract the pages out of each file onto it’s own file (should be 1-3 pages). The pdf file contains Contract Name. I want the file to print every time it finds a new contract name. It is usually 1 contract per page...

I found the correct syntax: Forms(MyFormName).Controls(MyTemplateName).SourceObject = MySubFormsNew Forms(MyFormName).Controls(MyTemplateName).Name = MySubFormsNew

It is not assigning the new name to the sourceobject and not changing the "Name" as well. No error msg's. When the code is done, it did not change it. The variables in my code have the correct values. Forms(MyFormName).Controls(MyTemplateName).Form.SourceObject = MySubFormsNew...

I have a form that has a Tab Control with 10 tabs. Each tab has a subform. I am dynamically creating these forms from template forms I have. I make a copy of the main form and 10 subforms that are in each tab. I want to be able to rename the sourceobject of each subform in each tab. I tried...

so it would be this? Forms(MyMainForm).controls(MySubForm).Form.RecordSource = MySubQuery

I have a subform on a main form that I want to change the recordsource. I have some code that loops and does this for several subforms on the main form. I need it to by dynamically, so I want to use variables. Below is how I would do it hard coded...

I having been using passthru queries with no issues. I am having with a passthru query. The string I am trying to pass is 3,064 in length. It is an insert that has about 150 fields. Is there a maximum length that a string odbc will take? INSERT INTO Tab06 ( GroupID, AssignedAuditors, MoveToWS...

Thanks! I made the change accordingly.

I tried this: Forms!F_workspacePP!SubFrmPPTab5.Form.SubFrmTab05PP.Form.Recordsource and this seems to be working...need to test it more. Thanks!

ok, tried that and now I get: Run-time error '2465': Microsoft Office Access can't find field 'Form' referred to in your expression

I changed it to this: Forms!F_workspacePP.[SubFrmPPTab5].SubFrmTab05PP.Form.RecordSource = "" and I get the error msg below: Run-Time Error '438': Object doesn't support this property or method