Recent content by awiezzz

Hi, I have table tblSample (IdNo, SCode, StaffNo) where IdNo is AutoNumber. This is sample of data, IdNo SCode StaffNo 10 ABC 50424 11 DEF 50424 12 GHI 50424 21 ABC 50424 22 DEF 50424 23 GHI 50424 26...

Hi John, sorry for late reply and thanx for reply, i've tested the sample..and it works..;) thanx again.. really appreciated it! regards, awiezzz

Hi, This is sample of data, No Project Action Plan 1 ProjectA XXXXXXXX 2 XXXXXX 3 ProjectB XXXXXXXXXX 4 ProjectC XXXX 5 XXXXX 6 XXX I've set Hide...

Hi all, thanx for reply..;) i've tested the code and it works..thanx again..:D

Hi, I have many records in 1 form, is it possible for me to display running number on that form? I can display running number in report by putting textbox and set its control source to =1. Is it possible to do that in form? any idea? thanx in advance..;)

Hi, I want to add data into form frmStaff. Form frmStaff has subform sfrmStaffDetails. When i click on Add button, it will open frmStaff. I can add data into frmStaff but cannot add data into sfrmStaffDetails. This is the code, Private Sub cmdAdd_Click() DoCmd.OpenForm "frmStaff", , , ...

Hi, I have Add button. When i click on the button, it will open frmstaff for me to enter new staff record. Now, i have to set DataEntry=True. It means i have 2 forms, one for data entry and another form to view previous staff records. Is it possible for me to do like this? Private Sub...

Hi, I have query with data from tblStaff and tblEntitle. I've created form just to update the ANNUAL field for each staff. This is the code, Private Sub Form_Current() If YEAR_SERVICE > 10 Then Select Case Me.GRADE Case "E1", "E2", "E3", "E4" Me.ANNUAL = 23...

Hi, I have Staff Detail and Leave Detail. One staff has many leave details. I want to check if the staff has duplicate leave details. I have StaffNo and StaffName in [Staff Detail] and StaffNo,StartDate,EndDate and LeaveCode in [Leave Detail]. Both linked by StaffNo. This is the code, Private...