Recent content by westbandits

Gees.....thanks my dear, how sweet of you. I will buy you lunch if possible :D. Anyway, I'm still frustrated with the forms I created in how to search the damn data. Maybe I'm wrong in the steps of creating the form or I really have to back to basic. Too bad, basic don't teach this kind of...

Agnieszka, I understand what is form and what is sub-form, what I need is on how to search the record without using VBA code, cause I not very good with programming unless is Dbase. Maybe, you don't understand what I'm trying to do here, but thanks for your help. For the complex arguments, I'm...

Ok, now let me share with you, Scenario 1 : let say John comes to work punctually in a 1 week full day. on week day he work every day for 8 hours of normal time and 4 hours of OT. And on Saturday he work normal time for 4 hours and 8 hours is OT. Then on Sunday he got 12 hours of OT hours...

There are some complex calculations on taxes and bonuses based on working time, date and day. Working time are flexible and is not fix. Employee can some come to work in the morning and skip the afternoon but work on OT. So I try to make it flexible. Your method is good but not flexible. If you...

Dear Agnieszka, Thanks for the prompt response. How come you didnt invite me for dinner?? :D just joke. Ok, lets get back what I started. Attach is the form design which I believe you will understand what I'm trying to do here. FYI, 1) tblEmployee: I will create a form to input each...

Thanks Agnieska for the info. However, as a beginner I'm still blur with what your have explained. I attached the Database, if you dun mind :D please provide step by step of how to go about it. Been trying for a few times still not succeed, :mad:

Dear All, Hello, I'm from Malaysia. I need advice and guide here. Currently with my new job, involves a lot of data entry records. I'm a beginner in Access 2007,since I'm not very good with VBA, I would be appreciated if anybody could assist me in the following scenario; I have 6 Tables, I...