Search results for query: *

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

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

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

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

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

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