(School project) Some code that doesn't work for some weird reasons

[Laetilae]

Hi everyone,
I need help for a computing project.
I do not know if I am in the right topic so forgive me if that is not the case. I am used to Visual Basic programming but ni am really not used to MS Access code.



Please have a look at the attachment!


Basically the problems are in the login and Clients forms. Please Have a look at the code and tell me what is wrong.

-Login form: the program seems to not be able to enabled the objects i want in the client form when I login. (The objects are in a subform, maybe I am not using the right calling procedure?). You need to have a look at the login command button code.

-Clients form: I asked my teacher but he doesn't know how to make the calendar works. Basiccally i want the calendar to display the event (if any) on when the user clicks on any dates on the ActiveX object. The calendar is in a subform on a page in the Client Form.

If anyone one of you have any suggestions on how to make the program better, please do so.

Thank you in advance for your help!

[jgelpi16]

Couple things I have noticed...

1) You need to "Dim" your database the same way you have done so for your recordsets. There is a DAO.Database just like a DAO.Recordset.

2) To get the calendar to appear you just need to set your datatype to a date. I noticed in one of your fields you had defined it as a Short Date but also had an input mask. When I removed the input mask for some reason the calendar would appear.

3) General good practice is to name your bound text boxes a different name than the field they are bound to. Also I strongly suggest you exclude spaces from all object and field names. They will cause you some serious problems down the road.

Let me know if this solves all your questions or if you have some more questions.

[Laetilae]

Thank you very much. It is working!

[jgelpi16]

Great, good luck!