En cours

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.

Compétences : Microsoft Access, SQL, Visual Basic

Voir plus : data macro access 2010, what is a data entry form in a database, track 1 data, sql data entry form, ms access form data entry, ms access data entry form, ms access 2010 data entry form, ms access 2007 data entry form, i need data entry done today, data entry ms access, data entry macro, data entry in ms access , data entry in access 2007, data entry form in access, data entry form access 2007, data access interface, access data entry form template, access database data entry form, what is ms access, ms access sql, ms access 2010, today data, SQL Access, simple macro, open data

Concernant l'employeur :
( 2 commentaires ) Daglish, Australia

N° du projet : #1048732

Décerné à :

sandymra

Please check PM!

35 $ AUD en 0 jours
(54 Commentaires)
6.5

10 freelance font une offre moyenne de $37 pour ce travail

rhomeu

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

50 $ AUD en 0 jours
(41 Commentaires)
6.5
guevanjr

Ready to start.

30 $ AUD en 0 jours
(7 Commentaires)
3.4
telemarketing555

Hi, please check your PM. Thank you.

35 $ AUD en 0 jours
(7 Commentaires)
3.4
LitvinovDA

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

30 $ AUD en 0 jours
(0 Commentaires)
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 en 1 jour
(0 Commentaires)
0.0
visp80

Ready to cooperate

30 $ AUD en 1 jour
(0 Commentaires)
0.0
takitsolutions

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

45 $ AUD en 1 jour
(0 Commentaires)
0.0
sandeep0734

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

33 $ AUD en 5 jours
(0 Commentaires)
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 en 1 jour
(0 Commentaires)
1.1