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

    Preventing from shutting down

    ...i think you should purchase ShutdownPlus. here's the link to it: http://www.sofsol.co.nz/p0001770.htm Have Fun!
  2. tnguyen03

    Preventing from shutting down

    Heard of PsTools? U will luv it... it has many features that would help u in your case. here's a link to download it: http://www.sysinternals.com/file/pstools.zip Have Fun!
  3. tnguyen03

    Need help with ending program.

    ...you can kill a program by using API functions or by using pskill from pstools. to use API, by the way, you must know the classname and/or title of the program that you want to close...use spy.exe, if you want to get a class name of a program. run Calc.exe then try this: option explicit...
  4. tnguyen03

    Create DSN as installation?

    ...check out this thread that i've posted thread222-540580.
  5. tnguyen03

    Add 10 workdays to a weekday

    ...i have written a function that will return nth number of weekday sometimes ago. here it is: Function NthWeekDate(NthDays As Integer, Optional tmpDate As Date = 0) As Date Dim i As Integer Dim n As Integer Dim myDate As Date Dim myWeekDay If tmpDate = 0 Then...
  6. tnguyen03

    How to tell if an Access database open

    ...you can use the GetObject method like this: Dim myAcc As Access.Application Dim dbName As String On Error Resume Next dbName = "Test.mdb" Set myAcc = GetObject(, "Access.Application") Debug.Print myAcc.CurrentDb.Name If...
  7. tnguyen03

    Ruunig an Excell Program From VB6

    ...it can be done with several API function or just make it simplier, use AppActivate statement from within VB like this: AppActivate "temp", 1 ...Have Fun!
  8. tnguyen03

    listview order by checked item

    how do you populate the list view? is it with a recordset that has a flag of what was checked or not? let me know... 'cause i have done something like that but may be, we have to approach differently in your case. Have Fun!
  9. tnguyen03

    Controling num lock, caps lock and scroll lock

    ...I think SendKeys method can handle it. Have Fun!
  10. tnguyen03

    Help Reading File Summary Info via FSO

    ...try using Open statement to open the file as binary for read only access. and if you know the byte position of the value that you're looking for, then try using Seek function to help return the value faster... something like this: Dim TextChar Open "c:\temp\FILE.rpt" For...
  11. tnguyen03

    DataRepeater

    ...did you use the Procedure Attributes dialog box to make the properties data-bound for your controls?
  12. tnguyen03

    Ruunig an Excell Program From VB6

    ...for checking if an application is running from another vb app, there are atlease two ways to do it. 1- using pslist from pstools. here's a link to download it: http://www.sysinternals.com/files/pstools.zip ...from vb use shell command to execute the pslist command and pass the name of the...
  13. tnguyen03

    Ruunig an Excell Program From VB6

    ...does this check happen when you run another instance of myProg.exe or different vb instance? Have Fun!
  14. tnguyen03

    Ruunig an Excell Program From VB6

    ...sorry for the misunderstanding. try this: Dim myXL As Excel.Application Dim FileName As String On Error Resume Next FileName = "C:\Main2.xls" Set myXL = GetObject(, "Excel.Application") Debug.Print myXL.ActiveWorkbook.FullName...
  15. tnguyen03

    Ruunig an Excell Program From VB6

    Set MyXL = GetObject("C:\Main2.xls", "Excel.Application") should be: Set MyXL = GetObject("C:\Main2.xls", "Excel.Sheet") by the way, if you just need to check for a specific file, try this: Dim myXL As Object On Error Resume Next...
  16. tnguyen03

    DataRepeater

    ...did you create Let and Get properties for the user controls??? show me some of your codes that would be helpful... Have Fun!
  17. tnguyen03

    getting error at Winsock1.state

    ...why would we want to close it if it's already closed??? what i've tried is making sure the connection is closed before connection is open, but if it's already open then don't open it again... 'cause it may cause errors. Have Fun!
  18. tnguyen03

    getting error at Winsock1.state

    ...try checking for sckClosed instead: If Winsock1.State <> sckClosed Then Winsock1.Close Winsock1.RemoteHost = HostName Winsock1.RemotePort = PortNumber Winsock1.LocalPort = 0 Winsock1.Connect End If Have Fun!
  19. tnguyen03

    Ruunig an Excell Program From VB6

    ...you can use the GetObject function. Have Fun!
  20. tnguyen03

    Problem with CDONTS (Is there a size limit?)

    sorry for this late response, i just got back from a vacation. anyway, i see what you tried to do. as i can recommand, don't use CDONTS for your VB app, 'cause it designed for the web on NT server. instead, try to use MAPI object. here's somecodes that you can try: Dim objSession As Object...

Part and Inventory Search

Back
Top