Search results for query: *

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

I created a form and put the tab control in that form and then put that as a subform in the tab control that is inside the main tab control. Now I have another issue related to this. I have my main form called: F_workspacePP Then I have a Tab control called: TabMain I then created a subform...

I want to put a tab control inside another Tab Control. I have 10 tabs on the parent tab control. When I try placing a tab control in the 6th tab of the parent tab control, it works but when I move to another tab on the parent tab, the child tab control shows up on every tab of the parent tab...

I got this to work below. I used 2 textboxes on a form and a button. It works when it finds what i searched for. But if I search for something that is not there, it highlights everything in the textbox. How do I not highlight everything when not found? Private Sub Command2_Click() Dim...

How can I search for something in a textbox and when found, highlight the word or phrase searched. I don't want the whole textbox highlighted. thanks, alex

I have a SQL view linked into a ms access application. That view is used in a subform and in datasheet view. I want to select multiple records and click on a button that will delete those selected rows. I need the button because the view has 1 table and a subquery joined in the view and will...