Search results

i am making a db for a gym. the members pay yearly and the fact that they have paid is shown by a tick box in the members table. i therefore want to reset these boxes to 'No' at the beginning of each year. anyone got any way that this could be done. thanks

is there any way that i can delete records from two different tables using the same delete query as i have them linked in the relationships using Member ID and if i try to delete from one of the tables then and error message appears stating that key violation has occurred. Thanks

i have a make table query that filters out which members of my gym have to rejoin in that month. i have also created a mail merge using this table that is created when i run the query. however, i now want to put a command button on a form and when clciked open up word and merge the documents. is...

is there any way that i am able to get the username from combo box on the login form that i created to a text box on the switch board that appears after the user has logged in.

at the moment i am making a system that calculates the cost of gym membership cost. however, i am stuck on how i can determine whether or not the member's have paid. i have a make table query that calculates each members fees. i would like the payments to be made quarterly. does anyone have any...

i am making a project that caloculates the costs of gym memberships. i have an update query that can change the price of facilities. however, i would like a form that links to this and i can use to enter the varation in cost. anybody got any ideas on how i can do this.

i was wondering if there is any way that i could get the users name from the login form that i have just entered to the switchboard form that appears after a member has logged in.

i have designed a form that allows users to log in. the username and password section works well. however, i also added a code that should make the application shut down after a user gets their password wrong three times but it is not working at all. below is my coding: If User Enters incorrect...