Search results for query: *

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

...Handles tsmiInteractive.Click Dim fFilesList As New frmfilesList ConnectToDBs() 'make connection see *** below for actual connection string Dim rs As ADODB.Recordset Dim strsql As String...

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

Hello, I have a question on how to tell which form called another form. On form 1 when I select option "A", I open form 2 for data input. Once form 2 opens I would like to know how to figure out that form 1 was the form I was in before opening form 2. Form 2 is a multi purpose...

Hello, I had problems doing about ayear ago and here is the solution that was given to me that works great. The following goes into the second combo box for contacts, in the row source. You build a qry that will contain this in the criteria for the corresponding field from the 1st combo box...

...str_sql = "DROP TABLE tester;" CurrentDb.Execute str_sql Next I build my sqlstr to create table sqlstr = "SELECT * INTO tester FROM table1" Dim dbs As Database Set dbs = CurrentDb dbs.Execute sqlstr dbs.Close ' start win word and run...

...Dim db As Database Dim rs As Object Dim con As Object Dim strSql As String Set db = CurrentDb strSql = "SELECT * FROM [design srb] " strSql = strSql & "WHERE (([design srb].bearing_size) " strsql = strsql & "= '" & Me!Text0.Value...

Hello, I would like to know if there is a way to keep some table in the local access file when you splitt the database. And How to add tables to an already created split data file. I have a shared DB that has 25 users on a network. I have a few tables that I have located in the local access...