Monday, February 28, 2011

Class and Coach details added

Few days ago I've been trying to add details and a new box for coach input in the class details page, allowing users to enter their all sorts of information and save it.

Monday, February 14, 2011

15th, Feb, 2011: Problem Solved

After few days of struggle I've finally managed to link the entry box of class number in the input data form to a selection of class numbers generated in another form separately. I've learned to create relationships in between tables, and also in order for the program to look for existed values in another table/query when inputting new data, I'd go to design view of the table and hit the lookup tab when the box is selected. Set 'Display Control' to List Box, 'Row Source Type' to Table/Query, and 'Row Source' to the table/query you want the values to be looked up from.

Wednesday, February 9, 2011

Progress 10th, Feb, 2011

Research how to make the form pop up in a window when opened by setting the form properties. Looked at form property table and learned the wide options you could do with it.

Finalizing the design of Home page and also details of classes and association with coaches.

Monday, February 7, 2011

Progress 7th, Feb, 2011

-Added a toggle filter to the Paid status form so user can quickly check who haven't paid yet by hitting one click.
-Working on how to let the program notify you when the date it is of currently matches any of the birthday dates saved in the database so user gets notified for customer's birthday.