Recent content by tjb001

I am sorry, I do not know cross post rule before.

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.

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

I got it. Thank you. You're right!

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

Because N1 has more than 50000+ record, B1 is my watchlist that I want to update. I only need to know the B1 instead of whole database. I am not sure how to use select queries to do this. I import an excel file into access, so the format of N1 cannot be change, such as first row must be...

OK, I already think this idea. But I think N1 only have 2013-2015 now. If N1 updates to 2016-2020, I have to add more field names to equal them, and keep the 2013-2015 because B1's format is same as old N1 with 2013-2015. If I do not keep old, I have to change the format with B1. That is a lot...

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

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.