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 Chriss Miller 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. ds2728

    binding data to a datagrid

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

    binding data to a datagrid

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

    Connecting to SQL server backend

    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"...
  4. ds2728

    Using a RECORDSET in a Report

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

    Connecting to SQL server backend

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

    Using a RECORDSET in a Report

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

    Connecting to SQL server backend

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

    Using a RECORDSET in a Report

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

    Using a RECORDSET in a Report

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

    updating the recordset of an embedded form

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

    updating the recordset of an embedded form

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

    I/O to text file

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

    HELP - HELP - HELP!!!!!!

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

    HELP - HELP - HELP!!!!!!

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

    HELP - HELP - HELP!!!!!!

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

    VBA question

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

    Set list in one combobox based on the selection in another.

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

    Access VBA for Word control

    Hello, I have done this to create merge letters and labels in word 2000 from VBA. What I do is create a table using a sqlstr, then I open word and execute a marco that opens a document thats setup as a merge document and setup to use this table created in the above sql call. I also created a...
  19. ds2728

    Populating a Text Box with the results of a Query

    Hello, I have done this often, although I do not use qdf. I build my sql string then open a recordset, then set a variable or or story_text on your form equal to the field value of your choice, then close the recordset. This eliminates having to delete the qry. and should make it alittle...
  20. ds2728

    Database Splitter

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

Part and Inventory Search

Back
Top