Updating access spreadsheet Video chat georgian free sex
this is a new record so add a new one to the list record = new Custom Object(); record. I know want to add a piece that is going to check if the record exist based on 4 rules: Products, Region, Quarter_F and Year_F If it matches these, it should update the other field (Units_F, ARPU).
Your help will be very much appreciated, I am stucked here and do not see how to get out. Activate ' row 1 contains column headings Do While Not Is Empty(Active Cell) s Product = Active Cell. If not, it should run the code properly and create a new record. OLEDB.12.0; " & _ "Data Source=C:\Users\Gord\Desktop\Database1.accdb;" ' open a recordset Set rs = New ADODB. Open "Price List", cn, ad Open Keyset, ad Lock Optimistic, ad Cmd Table Range("A2"). Filter = "product='" & s Product & "' AND variety='" & s Variety & "'" If rs. Print "Existing record found..." End If rs("price"). In the meantime I need to us date the data into the ms access table. If some one adds a 4th record in the excel spreadsheet.
I need the VBA to search the database and ensure a duplicate 4th record doesn't already [email protected] You should update (edit) your question to include that additional requirement.