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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jtmach

  1. jtmach

    Hide a CreateProcess

    If I understand your questions correctly all you should have to do is change the line. Private Const SW_HIDE = 3 to Private Const SW_HIDE = 0 Try it and see what happens The hardest questions always have the easiest answers.
  2. jtmach

    Outlook Attachments

    Could you share your success, so that I may learn. Thank you. The hardest questions always have the easiest answers.
  3. jtmach

    Reading Outlook Address Book.

    I created a form with 3 boxes EMail, Text5, Text7 (forgive the naming conventions). I then use the two subs below to read the address book and populate the form. Our global address book is on the server, however this has no trouble reading it from the local machine. You must also have a...
  4. jtmach

    SIMPLE UPDATE - Just Drain Bead

    Ok, this should work then. UPDATE (SELECT DISTINCT Full_Name, Address, City, State, Zip, Distinct_Player FROM Player_Information_Import_Data) SET Distinct_Player = 1 The hardest questions always have the easiest answers.
  5. jtmach

    SIMPLE UPDATE - Just Drain Bead

    Try it this way. UPDATE (SELECT DISTINCT Full_Name, Address, City, State, Zip FROM Player_Information_Import_Data) SET Distinct_Player = 1 The hardest questions always have the easiest answers.
  6. jtmach

    Default Folder for Pickfolder

    I am using PickFolder to allow users to browse the Outlook folders and pick one. I would like to be able to set a default folder that the browse starts in. Any suggestions or alternatives to this method would be greatly appreciated. Here is the code that I have so far. Dim olApp As...
  7. jtmach

    I have two questions: 1.[/b

    To keep you window on top use the following code. I got this from DSI on this site. Assuming you are talking about a form: You can use the SetWindowPos API function. 'To Force Form On Top Private Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter...
  8. jtmach

    Writing my own DatePart() function

    Are you using VBScript or JavaScript, or another. If you are using VBScript you can simply use the DatePart Function it will work in VBScript as well. DatePart('ww', DateEntered) The hardest questions always have the easiest answers.
  9. jtmach

    Expand Nodes using SendKeys

    I am trying to figure out how to expand nodes using the sendkeys function. Everything that I have read says that the plus key should work. If I push the + key on the keypad the node expands the plus key by the backspace does nothing. When I try sendkeys it does nothing. If open Windows NT...
  10. jtmach

    Call Function From Access Database

    Thank you for the responses, let me give a few more details on what I want to do. I have and Access 97 database backend with a visual basic frontend. I would like to be able to print Access reports without allowing users access to the backend database. In order to do this I would need to call a...
  11. jtmach

    Call Function From Access Database

    I would like to be able to call functions that exist in an access database from my vb application. What is the best way to go about this? Any help you can give would be appreciated. The hardest questions always have the easiest answers.
  12. jtmach

    System DSN

    I am trying to create a system DSN by using the code below. The code works (in that the DSN is created) however I am not able to use the DSN in other programs until I go into the control panel and test it. Once I have hit test it works fine. Any ideas on how to get this to work completly from...
  13. jtmach

    SendObject like module???

    Sorry, like this [code] SendEmail "bgorsk@ngc.com;msamso@ngc.com;mminnic@ngc.com;gougan@ngc.com;", , "Weekly Automated In/Out Report","Weekly Automated In/Out Report", "D:\(Joe) Supply Chain\In_Out\Upcoming_In_Out_Promo_Week.XLS", False, True [b] The...
  14. jtmach

    Use keys plus/minus to increase or decrease number?

    Go to the design view for your form. Right click on the control that you want this to happen for. Make sure that the format is set to short date. Go to events and next to the on key down event type event procedure. Then click on the ... button. When the code window opens up paste the code below...
  15. jtmach

    Specify Reply-To Address Using SendObject?

    [b]No, you cannot do it with the sendobject method. Have you done anything in the code window before? The hardest questions always have the easiest answers.
See more

Part and Inventory Search

Back
Top