Search results

  1. T

    Table overwirte

    I have two tables. A2 has 3 data. A3 has 4 data. I want to A3 has 3 data as same as A2. How do I overwrite the a3? What function do I use? Thank you.
  2. T

    Access creates the filter functions.

    I have a problem. I created a form to display three combo boxes: form1, form2, form3. The form1 show the "A series, B series, C series, etc"(from query resource).The problem is form2 because I want to filter some conditions that base on form1, such as if form1 has "a series", the form2 only show...
  3. T

    I have a problem with option group's code.

    As you see in the image, I have three options groups. When I check No of G and Yes of B, the ER option will be enabled( I choose enabled false on ER). Private Sub frER_Click() If Me.frG.Value = 2 And Me.frBrand.Value = 3 Then frER.Enabled = True Else frER.Enabled = False...
  4. T

    How Access update two table without field names?

    I have two tableS: N1 and B1. I can update B1 within whole database of N1. The problem is N1's field6 as name as 2013 sales. This name will be change in future. How can I set equal to two tables' value without point to name, such as column6? UPDATE N1 INNER JOIN B1 ON N1.ID=B1.ID SET B1.[2013...
  5. T

    How to update my database to my watchlist?

    I use one Excel file to import to my access, and it includes 5000+ records. But I just want 100 of them. How to update my watchlist to become the newest one when uploading the new database? Thank you.
Back
Top Bottom