Find Jobs
Hire Freelancers

Worker Time Attendance Database

R210-1750 ZAR

Pågår
Lagt ut omtrent 6 år siden

R210-1750 ZAR

Betalt ved levering
Please see the word document attached. An SMS to me will prompt me to email you any explanations you may need, as I am not always at my computer. [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions] I hope you can Help me. QUESTIONS 1. The Database and Main Menu Form: On opening the Database, you must have a Macro which runs and automatically opens the “Menu Form” in full screen view of the Menu Form, with no possible view or any other forms, Tables, Queries or reports, or any menus. Closing this form must only be possible using a button with a macro which will close the entire database. (After this is done, Pressing Shift P will I think, gives you the design view of the Database for developers to work on a. Buttons on this Menu Form must open to other forms each with a Password Required on the open form macro. I will put all the macro VBA on the buttons. I just need you to do the password on the open form Macro for the existing button called “Worker - Time Card Recorder - Department Heads”. b. When these forms are closed with the ordinary close form button (X) we go back to the menu form automatically (as we never closed it) 2. Tables: You can check the four Tables but I think they are Ok as they are. a. Form: Worker - Time Card Recorder - Department Heads i. All forms are opened from buttons on the menu form with Passwords (all must open and close the same – Full screen view, no menu &no way of going anywhere except closing and going to main menu) ii. Worker - Time Card Recorder - Department Heads 1. Show one record on the screen at a time and navigate using the record selectors 2. The forms must do some calculations in some boxes. In the caption field I have explained this clearly 3. They must also allow adding and editing the records as well as validation to ensure each record is correct and all calculated properly. No deletion of records allowed 4. You must see the form in full screen and not be able to go anywhere except close and go back to Menu Form. The only buttons you have are to navigate through the records and to add new records a. Firstly make sure we can add time format figures together and get a meaningful result. b. Eg: 3:00 + 4:45 + 8:00 = 15:45 hh:mm c. Eg: 13:00 + 14:45 + 18:00 = 01:21:45 hh:mm (this will happen when we group many days records) in a query d. We need to divide one Time result with another to get an overall utilization result as a % e. If we cannot achieve this we will have to get a Decimal Dime result per day per record – but this should not be necessary as excel can handles such formats, so should MS Access 5. The field “Works_Order_Number_Reference” and field[D] are mutually dependant. If one of them >0 or null then the other is required and give a message to say so. If both are blank then you can continue to the next field 6. The same applies as for point 5 above to field “Job_Card_Number_Reference” and field [E] 7. Time Worked - Basis for Utilization = [SUM OF D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R, and S] But NOT [A,B,C] - FOR UTILIZATION BASIS.A hidden and Calculated Field 8. Time Worked - Basis for Pay = [SUM OF A,B,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R, and S] But NOT [C] - FOR PAY BASIS.A hidden and Calculated Field 9. Worker_Utilization = A hidden and Calculated Field = [U / Time Worked - Basis for Utilization] 10. The record can only be saved when the last field is entered (required) and it = A calcutated field = Sum(A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S). This calculation is done repeatedly after any entry so it is a running total. This Calculated field will be on the form, as a guide to the user but will not update the table as it is not a field on the table b. Form: Workers Names and Hourly Rates – Fay i. Table View ii. No duplicates allowed on any Worker name irrespective of what Worker Type or Department Name iii. Select the Department and Worker type as a Lookup field (this field is not in the table but will come from a query, and see the worker names already entered for that Department. You cannot dupl
Prosjekt-ID: 16345721

Om prosjektet

4 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
4 freelancers are bidding on average R1 211 ZAR for this job
Brukeravatar
A proposal has not yet been provided
R1 666 ZAR om 1 dag
4,9 (13 omtaler)
5,1
5,1
Brukeravatar
I'd like to work with you on the project,Having 9+ Years of Experience as a Software Developer, successfully completed many projects (please see my reviews). Experienced in ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server, MYSQL, Oracle, MS Access, Crystal Report, Telerik, Bootstrap, HTML 5, CSS,Java Script.
R1 000 ZAR om 3 dager
5,0 (33 omtaler)
5,0
5,0

Om klienten

SOUTH AFRICAs flagg
Margate, South Africa
4,9
2
Betalingsmetode bekreftet
Medlem siden feb. 21, 2018

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.