Đang Thực Hiện

Simple Data Macro in Access 2010

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.

Kỹ năng: Microsoft Access, SQL, Visual Basic

Xem thêm: data macro access 2010, track data, sql data entry form, data entry macro, data entry access 2007, data access interface, today data, sql access, simple macro, open data, macro, macro e, indoor, data visual, access sql, keep record access, simple database visual basic, 2010 access, reduce sql, access order, simple function, data entry visual basic, update form access, simple access order database, visual basic entry form

Về Bên Thuê:
( 2 nhận xét ) Daglish, Australia

Mã Dự Án: #1048732

Đã trao cho:

sandymra

Please check PM!

$35 AUD trong 0 ngày
(54 Đánh Giá)
6.5

10 freelancer đang chào giá trung bình $37 cho công việc này

rhomeu

Advanced MS Access developer here. Please check private message for more detail. Thanks!

$50 AUD trong 0 ngày
(41 Đánh Giá)
6.5
guevanjr

Ready to start.

$30 AUD trong 0 ngày
(7 Đánh Giá)
3.4
telemarketing555

Hi, please check your PM. Thank you.

$35 AUD trong 0 ngày
(7 Đánh Giá)
3.4
LitvinovDA

Hello. Let me make this job for you. Yours sincerely, Litvinov Dmitry

$30 AUD trong 0 ngày
(0 Đánh Giá)
0.0
gr8websolutions

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.

$50 AUD trong 1 ngày
(0 Đánh Giá)
0.0
visp80

Ready to cooperate

$30 AUD trong 1 ngày
(0 Đánh Giá)
0.0
takitsolutions

Hi there, i am a ms access guru and can easily do the job. Regards

$45 AUD trong 1 ngày
(0 Đánh Giá)
0.0
sandeep0734

i can do it but i want existing database what u made already.

$33 AUD trong 5 ngày
(0 Đánh Giá)
0.0
rajkavikumar

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

$35 AUD trong 1 ngày
(0 Đánh Giá)
1.1