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 bkrike 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: svankley
  • Content: Threads
  • Order by date
  1. svankley

    Can you add a "non-domain" computer as trusted on a domain?

    I have a computer that CANNOT be added to a domain. I'm trying to set up some software on a DOMAIN computer that needs to talk to this NON-DOMAIN computer (over frame relay) and it won't work. I believe it's a security issue. Can you add a "non-domain" computer as trusted computer on a...
  2. svankley

    Outlook Setup of Exchange Server changes server name

    I have an issue with our test server and setting up an Outlook client. We're running Exchange 2007 with all patches and when I set up the account server (mail.myserver.com) and name in Outlook and click the "Check Name" button, the Exchange server field is changed to our internal FQDN...
  3. svankley

    Return rolling 15 minute period min & max

    I'm inserting into a table, a value every five (5) minutes. How can I query for the minimum & Maximum sustained 15 minute value for the day? This would be the three lowest & highest contiguous combined values for the requested 24 hour period (i.e. 10:10, 10:15 & 10:20), or whatever the case may...
  4. svankley

    How to query lowest 3 consecutive combined values **

    I'm inserting into a table, a value every five (5) minutes. How can I query for the minimum sustained 15 minute value for the day? This would be the three lowest contiguous combined values for the requested 24 hour period (i.e. 10:10, 10:15 & 10:20), or whatever the case may be. This one has...
  5. svankley

    Return only the latest reading of the day

    I have 1 table called T_WWPS_1_Daily_Values' with 3 columns ('Date', 'COL1', 'COL2'). What i want to do is generate a report of the Pump Runtimes. Everything works fine except - if, as seen below, there are 2 readings for the same day, Month Day Year Date Pump 1 Daily Runtime Pump 2 Daily...
  6. svankley

    Removing zero or null columns from a query.

    I have a SQL2000 database that contains batch data. In this example it's a cookie dough plant. I want to do a query to group the 3 types of batch runs below based on the prod_ID field but I don't want any blank or NULL columns returned. Is there a way to do a query I can put into a report that...
  7. svankley

    Is an app already running?

    What's the best way in VB6 to see if an external application is running? It's not the VB app (as in app.previnstance...), it's another apoplication that should be running but minimized in the background. Thanks, Steve
  8. svankley

    PDF viewer form crashing on close using pdf.ocx

    I have a VB app that needs to open a pdf document and go to a particular page in it. I'm using the Adobe Acrobat Control for ActiveX (pdf.ocx). The control is called 'pdfmain'. I have the following code on the form: Dim Status As Integer Status = pdfmain.LoadFile(PDF_Filename) If...
  9. svankley

    Open a PDF doc and go to a certain page?

    Is it possible in VB6 to open a PDF document and have it go right to certain page i.e. pg 264? I don't want to diplay the pdf using the iexplorer plug-in, I'ld rather it display in a form. Thanks, Steve
  10. svankley

    ASPX page loads VERY Slowly after 30 minute dormancy

    I'm developing a website for my "other" business that is using ASP.NET. Everytime I go to the site after about 30 minutes or so, the page takes 30-40 seconds to load which is unacceptable. Anyway, If I let this page load completely and then go back to the age 10-15 minutes later, it comes right...
  11. svankley

    Determining if SQL is running from VB 6?

    I have a need to know, for failover support, if a SQL server is running or not. I need to check every 10-50ms to see if the server is running and if not, switch to one of 26 others. I also don't want to have to wait for the 1 minute timeout if the machine is disconnected or the network is down...
  12. svankley

    What is accessing my Hard Drives?

    I have a couple Dell Laptops running Win XP SP1a. Both machines have times when there is serious, crippling drive activity, which usually lasts about 10-15 minutes and then drops off rapidly after that to normal activity levels. I have run Perfmon, Process Explorer and a few other utilities. I...

Part and Inventory Search

Back
Top