I need a very simple MATLAB gui (R2012b) that connects with an Excel database (via VBA) for load and save functionality.
The Matlab GUI has to have 2 pages with their own tabs (named "first page", and "second page" that would
get highlighted when each tab is selected so it is obvious which page we are in) with the following components:
Page1:
-one push Button labeled "Load Record", tag = loadrecord on the top of the 1st page
-6 edit boxes labeled (Last Name, First Name, Sub ID, Group #, Procedure Date, DOB), in the 1st page
-The corresponding tags of (lastname, firstname, subscriberid, groupnumber, procedure_date, dob)
-one push Button labeled "Save Record", tag = saverecord at the bottom of the 1st page
all edit boxes are Strings.
Page2:
-one pulldown menu consisting of (Last Name, First Name, Sub ID, Group #, Procedure Date, DOB)
-one edit box to enter a text String
-one push button named Search (tag=searchrecord)
-a table that shows 5-10 rows with having the following titles for the columns:
(Index, Last Name, First Name, DOB, Sub ID, Group #, Procedure Date, DOB, Last Modified)
Index starts from 1 and is integer. Columns are arrangable and sortable. Must be able to edit all cells
except for "Last Modified" by double clicking.
-one push button named Load (tag=loadrecord)
-one push button named Save (tag=saverecord)
General idea is to Save records from Matlab GUI into an Excel sheet and Load records back into Matlab GUI from Excel sheets.
During the Save and Load there are certain things that have to be checked such as duplicate records and empty cell and such. I will provide a detailed functionality list for every component mentioned above in the two pages once I choose the right candidate. The best overall developer with the fastest developing time will win. If you take more than a week to develop this please don't contact me.
You must provide all the corresponding files (.m, .fig, Excel file).
Thanks,
Hamed