Recent content by ds2728

RiverGuy, Thanks for your help, it worked great. I am new to vb.net and still having troubles with the whole concept transferring my vba knowledge. Although my son is knows both vb.net and now is working in java, is a great encourager for me to figure this vb.net stuff out. Thanks again, Dave

Hello, I need help: I have 2 forms, the first one called frmMain, and the second one frmFilesList. frmMain is the main form and I have a menu option to select that opens the second form. On the second form I have a datagrid that is supposed to display a list of records I have in a recordset...

Thanks, but no good. I actually tried the 9.0 earlier with no success then either. I did realize that I changed my connection string, so here's the new: Public Function Init_Globals() Set GBL_cn = New ADODB.Connection With GBL_cn .Provider = "Microsoft.Access.OLEDB.10.0"...

Thanks for the clarification. I have another post concerning this same application running on access 2000 where it errors out. Post is labeled: Connecting to SQL server backend Any help on this would also be appreciated......

Thanks for the post, but I have the connection string working for access 2002-2007. My problem is with access 2000. I get the following error: ---------------------------------- Run-Time Error 3706 Provider cannot be found It may not be properly installed. ----------------------------------...

I pass the sql string to the function that's required for the desire report, then build the qry. Then when I open my report the data source is already set to use the query: "rpt_qry" here's my code: Function BuildPassthruQry(strSql As String) As Boolean Dim qfd As QueryDef Dim db As...

Hello, I have a application that I have successfully converted to use data on a sql server. I have no linked tables or DSN's for this application. I built the system using access 2003. My problem is I have alot of access 2000 boxes that it needs to run on and it errors on the connection...

Thanks for the input, I was actually doing what Joeatwork suggested, which worked good. I ended up building a function that builds a pass through query using the querydef statement, which I add all information for qry including the sql server connection string. Then I actually pointed all my...

Hello, I am converting a standard access application that is setup with the data and application split. I have problems with the speed of the application due to the slower data link between buildings. I have been successful in converting the data to MS sql server 2000, with all data access...

Thanks for the response and the web link. The following did the trick. Set Me!Form1.Form.Recordset = GBL_rst Thanks again....

Hello, I have form1 which has a subform (form2). in form2 code for form_open I am setting the recordset to a sql query that attaches to a sql server. When I open form1, form2 loads as the sub form great and I have data. what i can not find how to do is update or change the recordset of...

i can input and output to a text file as long as the file is in the same directory as the c++ program. but i cant figure out how to input output to a file in a different directory i.e. I:\c++projects any thoughts. thanks

RASKEW, Thankyou, I will go through the process of changing all the code for the correction. My last question would be, why did it work and why does it work on the existing database that has not been updated with the copy undergoing development???? Thanks, dave

Hello, Thanks for your response, but I am not the the speller at all. As I said in my first post this code has been working for about 1 year and has started acting up since I have added a few modules to the overall project. I am puzzled Thanks dave

Hello, I hope someone can give me some help. I have coded a database and has been operational for about a year. I have been adding another section to the database and I am currently getting an error on code on code that has been working. The following is the line of code that is causing the...