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 Mike Lewis 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. JoeVegas

    Append data to 3 master tables from 3 temp tables using

    Do I have to use three connection statements, to have three table open at the same time in DAO or ADO ?
  2. JoeVegas

    Append data to 3 master tables from 3 temp tables using

    I will give it a try. Thanks
  3. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Well I did start a new thread. I am attempting to try the DAO or ADO. I had to spend too much time so far and I need to have this working today or ...
  4. JoeVegas

    Append data to 3 master tables from 3 temp tables using

    Sorry, MS/Office Access 2003
  5. JoeVegas

    Append data to 3 master tables from 3 temp tables using

    Using VBA and ADO/recordset's and/or queries, I need to update 3 related master tables from 3 unrelated temp tables. Can someone please show me how. I 've been away from Access for some time and appreciate your input. I have 3 tables a main with (CAMERAID), 2nd table TESTS with (TESTID, and...
  6. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    INSERT INTO tbCameras ( Barcode, Vendor, Model, Type, [Video Format], Imager, [Band], Voltage, Comments, PicturePath, SEQ ) SELECT tbTCamDat.BARCODE, tbTCamDat.VENDOR, tbTCamDat.MODEL, tbTCamDat.TYPE, tbTCamDat.[VIDEO FORMAT], tbTCamDat.IMAGER, tbTCamDat.[BAND], tbTCamDat.VOLTAGE...
  7. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    I have compared all tables, masters and temp and verified all fields are of the same data type. I have some field sizes in the temp tables that a smaller than the master and that is the only difference. I tried the append ("INSERT INTO") query again and got the same error message.
  8. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Here is the SQL and error message I receive: Here is the SQL from the query: INSERT INTO tbCameras ( Barcode, Vendor, Model, Type, [Video Format], Imager, [Band], Voltage, Comments, PicturePath, SEQ ) SELECT tbTCamDat.BARCODE, tbTCamDat.VENDOR, tbTCamDat.MODEL, tbTCamDat.TYPE, tbTCamDat.[VIDEO...
  9. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    I ran the SQL code and received the same error as before (earlier thread in this message) I wish I had the time to take the time but I am desperate to have this process working. I adopted this database and am trying to get things working. Once that is done I will have the time to learn and...
  10. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Well I entered the code in the module window and not getting wnywhere. Do you mean to enter and run the code in the SQL pane ?
  11. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Well I did one thing correctly and am not using the prodution copy. I will try "Insert into
  12. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    I already have 200 + records in the Cameras table and if I run that update example that will change all the records to those values, correct ?
  13. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Sorry, head is spinning right now. I will try an update query.
  14. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Are you running that code in the module Immediate Window?
  15. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Camera table accepted the new record manually.
  16. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Sorry, Barcode is also.....
  17. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    No, CameraID is the only one.
  18. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Below are the 3 table sturctures: Camera Table: CameraID primary/autonumber Barcode Vendor Model Type Video Format Imager Band Voltage Comments PicturePath Seq Tests Table: TestID primary/autonumber CameraID other field other field other field other field Tests_Results Table: Tests_ResultsID...
  19. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    Yes CameraID is autonumber and primary field for the Camera table just as TestID and Tests_ResultsID.
  20. JoeVegas

    Using VBA and recordset's I need to update 3 master tables from 3 temp

    I am able to manually enter a new record in the Camera table.

Part and Inventory Search

Back
Top