Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. abenitez77

    Monitor a folder and send email and check SQL Server

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

    extract pages from pdf file by contract name

    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?
  3. abenitez77

    extract pdf file by contract name using vba

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

    extract pages from pdf file by contract name

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

    Referencing subforms in Tab control

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

    Referencing subforms in Tab control

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

    Referencing subforms in Tab control

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

    reference the subform using variables

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

    reference the subform using variables

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

    ODBC passthrough string limit?

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

    Tab Control inside a Tab Control

    Thanks! I made the change accordingly.
  12. abenitez77

    Tab Control inside a Tab Control

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

    Tab Control inside a Tab Control

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

    Tab Control inside a Tab Control

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

    Tab Control inside a Tab Control

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

    Tab Control inside a Tab Control

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

    Search and Highlight found word/phrase

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

    Search and Highlight found word/phrase

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

    working with selected records in a datasheet

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

Part and Inventory Search

Back
Top