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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: joopa
  • Order by date
  1. joopa

    VB6/VBA access to PDF Metadata

    Hey, I want to access the metadata or just the file properties of an Adobe PDF document. This is to read the title/autohr etc into a test string and then print a barcode. Any suggestions? Prefer using VB6 or VBA, don't have any .NET. THANKS! J
  2. joopa

    Cancel Record Button

    Try to delete instead of undoing. Try this: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 DoCmd.Close Maybe it will help.
  3. joopa

    Connect two computers directly through Cable/DSL Firewall

    Hi, I have a Linksys BEFSX41 Firewall Router. I want to connect two computers through the Firewall, Computer A connected to the Cable/DSL Modem port, Computer B connected to one of switch ports. I want Computer B to access and write data to Computer A and preferably let it use Computer A to...
  4. joopa

    Synchronize two folders

    I want to do an hourly update of a folder with another. It's not a real synchronization since it is one way. I tried to do a backup of the whole folder, but it won't work since there is several GBs stored. Then I tried to first make a list of the filenames in both folders and copy the missing...
  5. joopa

    Fun Filter Problem

    Great, I moved the text box from the sub form to the main form and it works Like a dream. I don't even have to do the requery, it does it automatically. Thanks a lot.
  6. joopa

    Fun Filter Problem

    Thanks, Peterpruimboom It works great! when I have my form alone. But this is a subform, embedded into a main form. I get an inputbox asking me for the txtFilter value each time I open the main form? And the same happens when I do a Shift+F9 requery. Any ideas? Thanks
  7. joopa

    Fun Filter Problem

    So, I have form with 3 fields: Primary_Chemical_Name, Secondary_Chemical_Name and Catalog_No. All Alphanumeric. I want to make One text box for filtering the records. When the user writes the first charaters or numbers in the text box I want to automatically filter based on the entry in all...
  8. joopa

    Bind Label to Table

    All, My form contains ComboBoxes for the user to pick records from a related table. I created them using the wizard, the option Lookup in Query or Table. The ComboBoxes are getting quite long, so I created a button to a Subform where the user can scroll and find the record to insert. I want...
  9. joopa

    Auto Refresh forms?

    That works, Thanks, JJ
  10. joopa

    Auto Refresh forms?

    All, I have a linked form. When I add values to the linked form and go back to my main form I have to either: 1. Go forth and back one record. 2. Press Refresh to see the entered values. Can I set it the forms to refresh automatically or do I have to make a loop. Thanks
  11. joopa

    How to create button to Transfer from Subform to Master

    Sure, I tried to relate the two tabels that my Main Master table is a Many table and the One table is the subform table. Normally the Master being the One and the Sub being the many. That won't wotk for me, so that's why I deleted the relationship. LEt me know if I am wrong. J
  12. joopa

    Button to display current record in a MsgBox

    Thanks Aceman, That was easy. Next I want to have this button in a Subform and clicking it make the selected record (say Customer_ID field value) pasted into a current record field in my Main Form. I can't use Me! for the current record in my Main form, sine the button is in the Subform. Can I...
  13. joopa

    Button to display current record in a MsgBox

    I wan't to make a button that displays the current record on the form in a Msgbox. I am not sure how to bind to current record in Code. I tried to use the Macro but that didn't work. I know this is basic. Thanks
  14. joopa

    How to create button to Transfer from Subform to Master

    OK, I have a Master form with an embedded Subform. The two forms are unrelated, their tables NOT in relation. When I navigate the Subform, I want to create a button that inserts the wanted Subform field value into one of the Master form fields. Then when I navigate the Master form I want to...
  15. joopa

    Master = Many, Child = One Form Problem

    Very Basic, maybe not possible, but anyhow, I want to have a Master Form as my Many table. Then my Child form as the One table. Scrolling through my Master Form records I want to see my Child Form change accordingly. I want to be able to add a new One record to my Master(Many) or assign a...
  16. joopa

    How to Create Tab Form Control from Other Forms

    Sorry, I went blank. How do I change the Child/Field Properties between the Master/Child, it won't allow me to select both? Is this the same as making a bound form? Will that allow me to scroll my main form and see the subforms change to the appropiate records? My Main Form has individual...
  17. joopa

    How to Create Tab Form Control from Other Forms

    Yes, thank you. But it does not work though. I tried as you described but with an empty main form, so I could not really add any records. My system has a "star" like relationship. I have a Main Table, which is my Many table and the rest are related as One tables. I tried using my Many table on...
  18. joopa

    Write to TextFile

    Agree with TomThumb. Used it several times on large scale and it works fine. Just remember to close in the end. From my own code for a file named batches: Your DIMS goes here Set FileSystem1=CreateObject "Scripting.FileSystemObject") Set MakeBatchesFile=FileSystem1.CreateTextFile("C:\My...
  19. joopa

    How to Create Tab Form Control from Other Forms

    All, I have 13 tables. They are all related. I have created 13 Simple forms. I want to make one Master form with tabs for each table/simple form. I can do this using the Wizard, selecting all tables to create a form from and then edit the lay-out extensively. If I open my simple forms and...
  20. joopa

    Simple Many-to-One Problem

    Bob, I can't give you enough stars, you are the best. I am sure I will be back soon with another thread. My next project involves Many-to-Many relations. Thanks again, Jens

Part and Inventory Search

Back
Top