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!

Register Log in
  • Congratulations Rhinorhino 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. jcook32

    VB 6 Question

    Does it really matter where the error is . I need code for a do while loop using the recordset EOF do you know what the code is???
  2. jcook32

    VB 6 Question

    when the loop tries to execute This is all my code Private Sub Form_Load() Set objLoginInformation = CreateObject("WScript.Network") Dim adoConn As New ADODB.Connection adoConn.Provider = "SQLOLEDB.1" adoConn.ConnectionString =...
  3. jcook32

    VB 6 Question

    when i run the project. runtime error 438 Object does not support this property or method
  4. jcook32

    VB 6 Question

    I need the code to do a loop using the record set EOF Here is what I have:(i get an error) rsuserinfo.Recordset.MoveFirst Do While Not (rsuserinfo.Recordset.EOF) rsuserinfo.MoveNext Loop thanks
  5. jcook32

    VB 6 Question

    I need to do several things with a VB exe. 1 When a user logs in a login script is run. I need to get the login ID. Not sure if there is a standard way of getting this. 2How do you open a IE browser window automaticly from VB 3What section of the VB project would all of the above go and where...
  6. jcook32

    Need to display total on last set of records

    You are the man!!! Thanks Another question. I want to take those three totals and add them together to get a Total for the whole column which would be the department total. Thanks Hey we have the same last name Cook Any relative in Pittsburgh, PA area?? Joe Cook
  7. jcook32

    Need to display total on last set of records

    I have code that works ok. It keeps a running total and displays it on the screen. the way i have the code set up though is it does not give me a running total for the last set of data. My screen looks like this: Health Care Group |30 | 31-60 |61-90 |91-120 |120 | Net |...
  8. jcook32

    need to display the results from a record set

    the data returned from the sql statement looks like this grpname under 30 days $$ xxx 200 xxx 255 xxx 666 xxx 888 xxx 444 yyy 555 yyy 343 yyy 656 yyy 878 yyy 557 zzz 3434 zzz 454 zzz 322 zzz 0909 zzz...
  9. jcook32

    need to display the results from a record set

    this is my sql statement: SQLstr="SELECT tkinit,tkfirst,tklast,tkloc,ldesc,tkdept,head1,tksect,tsectdes,mclient,clname1," SQLstr=SQLstr& " right(mmatter,5) as matter,mdesc1," SQLstr=SQLstr& " (arf1 + arc1 + aro1 + ari1) as one," SQLstr=SQLstr& " (arf2 + arc2 +...
  10. jcook32

    need to display the results from a record set

    I have a SQL statement that returns some data say 1000 rows. Each row has a Dept in common. Each dept has Groups within it. Say Dept1 has 3 Sub Groups. Each sub group may have any number of records for the question's sake lets say group one has 500 rows and Group 2 has 300 rows and group 3 has...
  11. jcook32

    display rows from a database in ASP

    this is in the wrong forum. It should be in a asp forum.
  12. jcook32

    display rows from a database in ASP

    I have a SQL statement that returns some data say 1000 rows. Each row has a Dept in common. Each dept has Groups within it. Say Dept1 has 3 Sub Groups. Each sub group may have any number of records for the question's sake lets say group one has 500 rows and Group 2 has 300 rows and group 3 has...
  13. jcook32

    diplaying Data from a stored procedure

    Litigation 7029.05 0 0 0 0 7029.05 Litigation 0 0 0 0 148618.679 148618.679 Litigation 0 21615.14 0 0 0 21615.14 Litigation 0 0 0 0 47843.7464 47843.7464 Litigation 0 0 0 0 2630.25 2630.25 Litigation 5860.91 0 0 0 0 5860.91 above a several rows of data the is returned...
  14. jcook32

    diplaying Data from a stored procedure

    I have a stored proc. that returns a bunch or records. There is a col. called head1. there are 5 different departs in head1 I need to display each department once and give running totals of other columns. ex there is say 100 records with the head1 as Litiagation with each row have some numbers...
  15. jcook32

    crystal report issue

    I am using ASP when I run it in the browser
  16. jcook32

    crystal report issue

    Crystal 8. I am running the report within crystal but I do get the same error when running it from a web page. I am doing all this from the same computer if that matters. I am executing the report on my localhost. I tried to run on my intranet server and it does not work there, just opens up a...
  17. jcook32

    Trying to link to a second table in Crystal Reports

    the error messgase is General SQL server Error:Check messages from the sql server and next Error detected by database DLL These occur when I add a field from the other table. When I remove the field the error goes away. joe
  18. jcook32

    Trying to link to a second table in Crystal Reports

    Here is what I have. I have a report the diplays one record from a sqlserver db. I us a parameter field. In this one record I have several names that I need to display. The names are actually usernames(ex jpcook) I added the table that contains the fname and lname and mi of the user name...
  19. jcook32

    crystal report issue

    I am able to run the report on my localhost machine but when I move it to another server the report viewer come up but the report is not there joe
  20. jcook32

    crystal report issue

    I am trying to run Crystal reports on my intranet server and when the report viewer comes up the report is not shown. Do I need the coplete path or just the local folder path. ex. Within my testing dir I have a reports folder and that is the path I use to call the report. joe

Part and Inventory Search

Back
Top