Search results

  1. O

    SQL Query

    Hello Guys, I am in need for some help with SQL code to search multiple columns in multiple tables in an Access database. We have a database supplied to us, as part of our CAD software, which contains multiple tables each with slightly different column counts and headings. One thing in...
  2. O

    ADODB Order Question

    Here is what I am trying to achieve... I have two recordsets both exactly the same except the data they contain. I have to consolidate them into one list. Because they contain part data it may be that it is just an amendment of the quantity of that part so firstly I have to search for each...
  3. O

    ADODB Order Question

    I did see your previous message...maybe my understanding is a little clouded here? As I understand it, and I am sure you will correct me if I am wrong, but a recordset contains records. What I am trying to do is to pass a recordset and a record to the function called ExistingDataSearch hence...
  4. O

    ADODB Order Question

    I am not trying randomly, I hope anyway. :confused: All I am trying to do is open a record into a recordset which according to other resources should work in the way described but for some reason I get the error message.
  5. O

    ADODB Order Question

    What I amtrying to do is create an interface between our design office and ERP system. What I need to do is to re-jig the part details from our CAD system and put it into a specific format with additional information before the purchasing department gets it. I have spent a significant amount...
  6. O

    ADODB Order Question

    oh my :o Thanks for your reply. Out of interest what would you use?
  7. O

    ADODB Order Question

    I do not use a select statement to open the recordset. What I have is this: Dim adoRs As ADODB.Recordset Dim i As Integer Set adoRs = New ADODB.Recordset adoRs.Fields.Append "Desc1", adVarChar, 20 adoRs.Fields.Append "Desc2", adVarChar, 20 adoRs.Fields.Append...
  8. O

    ADODB Order Question

    Hello all, I have a ADODB recorset which is full of records. I want to be able to sort the data in a field, say a field called "description" for instance. If anyone can offer any advise, I would greatly appreciate it. Thanks
  9. O

    Create and email report

    Hi, I am hoping that someone may be able to advise me on the best way to manipulate reports using VBA??? What I have currently is a report and in it's record source there is a query. When I run the report the query builds the information and then I can see the information in the...
  10. O

    Form Records

    Thanks all for your replies - they are most helpful This will give me something new to look into and learn!! Thanks
  11. O

    Form Records

    Hi, I have many forms which I have designed to be as idiot proof as possible howver I have one problem which is prooving difficult to solve. When the forms open, records are attached to bound text boxes, list boxes etc. The problem is that when a form opens it should display one record only...
Back
Top Bottom