rupert delfin
New Member
Hi All,
I am seeking help for my project, I am using MS Excel 2010 as front end and MS Access as my backend. I am new to VBA programming and been practicing in building some VBA. I have an excel file that's already connecting to my access database, but struggling with it.
first, how can I check if record/data is already exist before saving the data in ms access? This is way I can set my primary key to the productname where no duplicates. Second, how can I display the records each time I select the value in combobox and display the remaining records in textbox1 and textbox2? Hope to get your feedback and inputs. TIA
Here's my access database link
http://www.mediafire.com/download/m8o0lzijo23nk6y/Inventory.accdb
and here's my excel file that link to my database. http://www.mediafire.com/view/h565e7e6rmb4oxf/Inventory.xlsm
I am seeking help for my project, I am using MS Excel 2010 as front end and MS Access as my backend. I am new to VBA programming and been practicing in building some VBA. I have an excel file that's already connecting to my access database, but struggling with it.
first, how can I check if record/data is already exist before saving the data in ms access? This is way I can set my primary key to the productname where no duplicates. Second, how can I display the records each time I select the value in combobox and display the remaining records in textbox1 and textbox2? Hope to get your feedback and inputs. TIA
Here's my access database link
http://www.mediafire.com/download/m8o0lzijo23nk6y/Inventory.accdb
and here's my excel file that link to my database. http://www.mediafire.com/view/h565e7e6rmb4oxf/Inventory.xlsm