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 wOOdy-Soft 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 tcoffey

  1. tcoffey

    SMTP Server

    I need for you to be more specific? I am using MS SMTP but I am sure that it can work with others also. In my situation, behind a firewall, I needed to know what the "smarthost" was so that the information could get to the outside world. In order for me to understand\detail I need...
  2. tcoffey

    EXPORT Help needed ASAP

    There are many possible solutions for your situation. If these servers are connected then you could establish a link and just pull the data you want. I personally don't recommend using links because of the traffic issues on networks. You could also use create a stored procedure that would...
  3. tcoffey

    Combo box problem

    A Combo box only selects one value so if you clear out the value of the combo box (cbocombo1.text = "") this should unmark the item.
  4. tcoffey

    Setting the Picture Property

    Take a look at Loadpicture.
  5. tcoffey

    Help with public types

    strField = ColRec. & strvarname Since colRec is a collection what you can do is reference it with an index. Try something like ColRec(x) where x is the index. You will need someway to track what the index is pointing to so you might also check ColRec(x).name for instance. Good Luck.
  6. tcoffey

    pick up file from directory

    Try using the "DIR" command and put the name of the file you are looking for in it. The number of files should not matter. After you put you filename in the DIR command check and see if the legnth is > 0 it so then the file exist.
  7. tcoffey

    Strange Behaviour

    In your application are you using a reference to an object that would reside on the office 2000 disk? Create a very simple application and make sure that the only reference information is the standard options (Visual Basic for Applications, Visual Basic runtime objects and procedures, Visual...
  8. tcoffey

    converting vb5 application to vb6

    Personally I did not have any problems. There are some enhancements with VB6 but none of this should make a difference. Thomas
  9. tcoffey

    clean memory

    I can't say that I am familiar with "REUTER|IDN" but I really don't think that is the problem. In most cases when this method is used the problem is because the called object is still sitting in memory. Even your call used in the first method probably has left something out there...
  10. tcoffey

    SMTP Server

    Are you trying to use CDONT? To make this work the SMTP service must be setup correctly on the server you are going to try and use. Dim objNewMail, sString1 Set objNewMail = CreateObject("CDONTS.NewMail") objNewMail.From = "me@here.net" objNewMail.To =...
  11. tcoffey

    Connections not terminating

    This is all good stuff but I have a question. I like to use async processing when I can. Is there a way to do this with this method? "The above example covers everything you need to know to get started. The rest can be foound in the help files installed as part of the Oracle Client...
  12. tcoffey

    on error resume next problem

    Looking forward to see what they say. It could be something with the ME OS.
  13. tcoffey

    on error resume next problem

    You might try using the on error statement at the top of the code. What happens when you step thru the code and at what point does it give you the error? Usually when I am using the on error statement I place the code at the top of the routine. You could be getting an error before that time...
  14. tcoffey

    Connections not terminating

    James, James, James you are the man!!! When I upgraded to MDAC 2.6 it all worked. Before I did that I also got it to work with a modification to the connection string that turned off connection pooling. I may not have been using the 0040 route correctly but it did not work for me. I you...
  15. tcoffey

    Connections not terminating

    Thanks for the information James. I have tried both methods the create object and the set as adodb.connection and got the same effect. I did read somewhere that there is a known leak with ADO/MTS objects and this fix was done in msado15.dll so I check the date on mine and it is is using 2.5...

Part and Inventory Search

Back
Top