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

    Current applications

    I can make that work, thanks for the info. However the problem I am having is trying to find out what db to access by the name given in the application title. I would like to see if a particular application is running and the name of the db is in the title. I would then like to parse out the...
  2. jscorpion

    Current applications

    Is there a way to find what application are running. I need a vbscript that can compare a string to see if that application is running. I found out how to do it in vb6 but I really need the vbscript since it will be used in conjuction with a bigger vbscript. the vb6 code is as follows...
  3. jscorpion

    COUNTING RECORDS

    thanks for your response, but I just want an sql statement that will due this. This is not part of an application just a query. Thanks jscorpion
  4. jscorpion

    COUNTING RECORDS

    THIS SHOULD BE EASY, BUT I CAN'T REMEMBER HOW TO DO IT. I WANT TO DO A SELECT STATEMENT AND CREATE A FIELD THAT INCREMENTS WITH EACH RECORD SO IF THERE ARE FOUR RECORDS THE NEW FIELD LETS CALL IT COUNT1 WILL BE POPULATED WITH 1-4. ANY HELP WILL BE GREATLY APPRECIATED. THANK YOU.
  5. jscorpion

    copy a table

    thanks for the tip, but I have a solution. I just thought there may be a better way. I ended up doing it like so: OleDbConnection dbConn2 = new OleDbConnection(MainSource); dbConn2.Open(); string test2="DELETE FROM CURRENTTABLE"; string test3="SELECT * FROM...
  6. jscorpion

    copy a table

    All I want to do is copy the contents of one table with one connection into that of another table at a different connection. I have tried to populate a dataset then copy it to a new dataset and use the adapter to update, but it is not updating the new data. Is there an easy way to copy...
  7. jscorpion

    WAIT FOR USER INPUT

    I am writing my own using a wasp scanner and a number pad running in a windows environment. I decided to go ahead and use SpiderBear6 suggestion and go with threads. I am running two threads one running the questions and waiting for input thru the thread.pause command and an accept button...
  8. jscorpion

    WAIT FOR USER INPUT

    Is there a way to stop the program and wait for user input. I am creating a barcode software. The user scans their ID then scans there process such as open job and next scans job number. I am currently using a case statement tracking were they are at, but after the process I would like to...
  9. jscorpion

    I have an sql question. I have two

    thanks for the post SantaMufasa, but I had already figured the problem out. It is very similar to your solution though I did have a few extra columns that I did not mention. Here is the final sql statement I used. SELECT DEPT.DNAME, DEPT.LOC, COUNT(EMP.DEPTNO) "Number of People&quot...
  10. jscorpion

    I have an sql question. I have two

    I have an sql question. I have two tables one has 'deptno' and 'dname' in it two has 'empno' 'deptno' and 'sal' in it I would like to display deptname, number of employees and average sal in each dept. so the display would look like this dname number of people sal accounting 3...
  11. jscorpion

    Crystal reports problem

    I am having a problem with viewing a crystal report in asp.net. when the db is located on another computer or server I get the following error "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed". If the db is located on local machine it works just fine. It is a...
  12. jscorpion

    User Documents

    I wrote a program in vb 6 using user document. The program was loaded into an imbedded web server. By accessing the ip address it would hit an htm file that would then direct it to open the cab file and download the program in temp memory and run it. I understand that vb.net does not support...
  13. jscorpion

    complete rotation

    Thank you CajunCenturion for your response. That does seem to be a better way with less code. One of my orginal problems was that I may not be starting at zero everytime which would mess that formula up, but I have decided to code it to subtract the value back to start at zero so this should...
  14. jscorpion

    complete rotation

    Yes, I had thought of doing it that way, but I did not know if there was a better way to compare degrees in vb. I guess that is the route I will go. Thank you for your help. jscorpion
  15. jscorpion

    complete rotation

    degrees never gets > than 360 it returns back to 0 which is causing the delima. I am reading an external device which is giving me the information in degrees, once a complete circle is done it returns back to zero. This is why > and < than comparisons are not working. Thank you for your response.
  16. jscorpion

    complete rotation

    sorry, I am comparing degrees not radians. My mistake
  17. jscorpion

    complete rotation

    I am graphing data points on a x an y graph. As the angle changes I take a reading of another device. I take as many readings as possible within a 360 degree rotation. How can I in vb code tell when I have made one rotation. You can not use > or < than since I am comparing radians. Is there...
  18. jscorpion

    picture1.line

    I have a picturebox holding a jpeg. I am drawing points on this jpeg using picture1.line and connecting them. If a point goes higher than my picture1.scale I would like to re-scale the drawing keeping my datapoints, but at a different scale. So if the scale goes up then the new datapoints...
  19. jscorpion

    Registry

    I would like to change the (Default) data located at HKEY_CLASSES_ROOT\exefile\shell\open\command I am writing a program to launch an exe when an exe is ran, but I would like a quick install to go and edit the data field for me by setting up a string path to launch the executible before the...
  20. jscorpion

    # of users

    thanks for your reply Do you know if this command would work in Centura SQLbase or do you know the command for the SQLbase?

Part and Inventory Search

Back
Top