I am putting together a membership database for a indoor rock climbing company. I have written an access database to keep track of all their members but have one last user interface/data macro I need in order to make it complete.
This data macro is "Add visit" and this is what I need it to do. In the combination form view which displays a form and a table (based on the contacts MS access 2007 template) I need a data column similar to the "open" function in the contacts template. This "on-click" with the words "add visit" will do three things. It will:
- Update the "last visit" entry for a record to "date()" i.e. to today.
- Update the "number of visits" entry for a record and add one to the number of visits. i.e. a counter
- If "visits left" for a 10 visit pass is greater than 1 then reduce "visits left" by one.
I have attached a screenshot showing what I would like done.
Đã trao cho:
10 freelancer đang chào giá trung bình $37 cho công việc này
8 yrs experienced senior developer. Have worked extensively on macros. Will be able to achive in a simpler logic. Let us know to complete this work.
Hello, I am expert in MS-Office macros, web application and have 3+ yrs of Experience in advance VBA programming, I ll deliver you the quality work. Please check the PMB I have sent you sample of my past work