In Progress

Simple Editing Fuctionality to my Acess2010 Client Database

Microsoft Access 2010 Database. I have a simple client manager database that holds client info. It requires two additions to the functionality

The parts that need doing is when you edit a client contact there are two listboxes. One with Deposits paid the other with containers rented. I have already made the forms and the command buttons I just need them linking up.

Containers

---------------

1) When + button is clicked add a new container rental associated to that customer. The start date should be default todays date.

3) When you double click on a container from the list box it will allow you to edit that record.

4) when adding or editing it will refresh the client view.

5) Currently the listbox is displaying containers this should use the container_transaction table

6) the format for the containers listbox should be : containername - start date

7) in [url removed, login to view] history page this should show inactive containers only. format of the listbox shouldbe ... container name - start date - end date

Please note#

1) the database attached lists the containers from the containers table, this should be listing it from the contrainer transaction list instead.

2) the containers transaction table has a container ID this refers to the container table.

Depostis

------------

1) When + button is clicked add a new deposit transaction to that customer.

2) When you double click on a deposit from the list box it will allow you to edit the info and have an option to delete the record too.

3) when adding, editing or deleting it will refresh the client view.

4) the deposits have an option where if its a paymentor a refund. If it's a payment the transaction total will be a positive figure e.g. £10 if it's a refund it will be negative figure e.g -£10

5) When deleting a record it must display an.... are you sure popup Yes/No.

Simple! Attached is the Database that needs the alterations.

Any questions please ask, if anything is unclear please ask.

Skills: Microsoft Access

See more: questions to ask, parts database access, paid to edit, other name for editing, microsoft access parts database, editing needs, containers c, c containers, access parts database, acess2010, access listbox, transaction history, refund button, access delete, microsoft client, simple contact database, access database transaction, 2010 access client database, rental access, forms buttons, list box access, customer access database, client database access 2010, simple figure, access client database

About the Employer:
( 15 reviews ) Rhuddlan, United Kingdom

Project ID: #1086955

Awarded to:

rbenfield

Hi, I'm a uk-based Microsoft Certified Systems Engineer and professional Access developer. I can make the changes you need and quickly too. If you award the project to me, I'll begin work on it the same day. Many More

£50 GBP in 3 days
(9 Reviews)
4.7

7 freelancers are bidding on average £79 for this job

rhomeu

Advanced MS Access developer here. I can help you with your requirements. Please check private message box. Thanks!

£100 GBP in 1 day
(49 Reviews)
6.7
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

£30 GBP in 1 day
(25 Reviews)
4.4
frehmanpk

Respected Sir, MS Access Expert Here. You can see most of the required features already working in my attached application. Moreover I can do that all in just single sitting and no problem if you are intrested to comp More

£30 GBP in 0 days
(14 Reviews)
4.4
PerfectSquare

please see the PM

£90 GBP in 5 days
(15 Reviews)
3.4
bestappdev

I have over 12 years experience with Access development. This project should be able to be done very quickly.

£100 GBP in 1 day
(1 Review)
1.2
ConsultOne

Please see my PM covering the details of my bid

£150 GBP in 7 days
(0 Reviews)
0.0