Recent content by jcook32

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???

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

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

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

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

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

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

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

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

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

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

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

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

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

I am using ASP when I run it in the browser