Recent content by darrenislearning

Thank You so much. Appreciate it

Thanks, it works. If I want to expand the course list, which value should i change in the afterupdate? E.g. I got 10 courses. Edit: I tried on new record, when i select the listbox item, it will be reflected at the 2nd item. (with a line break before value)

Thanks for advise.

@theDBguy , I tried to follow your sample file and will have error when empty and it does not work like yours (e.g. move to the first line) when remove.

Expanding with more fields and placed into tab control. For now, I have tables for student particulars, courses taken, student nok details. All will linked from studentID I have messed up my db and currently it is not working so I am unable to share my db

Hi, I'm back again and I'm still struggling with the work. May I know can I don't do with a sub form as my form will be expanding and I am considering to have navigation control in the future. And the listbox value is not referencing to table. The purpose of the navigation form is to split the...

Yes, thank you so much.

Hi, I have a deactivate user form and the form is able to update the deactivation status. However, I faced this problem and need some advise 1) After I update, my tblUser first record user name is changed (E.g. after i update amy, the first row record user will change to amy and I will have 2...

Thanks. Much appreciate it

I just managed to resolve the two navigation form. But still stuck at the error for creating new user with the error above

Thanks. I saw something similar from other thread on this

Yes, the form is able to open and when login with normal user, the create new user is greyed out. Is it possible if I create 2 different navigation form (1 for admin and 1 for normal user). If login with admin, it will show the admin navigation form? I tried to create new user and i have an...

I have tried your Access file and still trying to digest. But at the same time, I added in security level in create new user form. However, I have some difficulties in saving the combo box value to the table. And with the security level, I will have a navigation form. How do I allow only Admin...

Thanks. Looks like a lot of function need to be use. Will explore on it. Appreciate it

Thanks, I realised i mistype my sql. Will try to google for the hash function