Recent content by jtmach

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.

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

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

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.

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.

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

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

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.

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

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

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.

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

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

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

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