Search results

  1. B

    Update table with data from another table

    Hi, I've table TblMain with data and another table Tbl2009, which is linked to excel sheet. I need to update TblMain with data from Tbl2009 with update query. Problem is, that update query doesn't create new rows, only updating existing. Please advise if that can be avoided. Thank you.
  2. B

    Autofill value in form

    Hello. I'm totaly newbie in access coding. I've created my first DB, two tables and a form. Tables are: tbl_product product|amount pr1|100 pr2|200 pr3|250 etc... tbl_subproducts subproduct|amount|add|product sub1|100|no| | sub2|250|yes|pr3| frm_subproducts is used for filling values. Main...
Back
Top Bottom