Recent content by binksmatthew

cool. thanks for the pointers. i'll go and give that a try

thanks. ive done that now and it works great. however, is there any way that i can automate it to update on the 1st January every year

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

thanks. it works fine now. i tried just about everythng under the sun except that.

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...

thanks for the example. i am in the process of setting it up.

in your coding does 'strLogin' stand for the name of the column in which the employees Username is stored in the table. also should the form name be included in the module.

cheers for the reply but could you explain how this is done please as i am fairly new to Access. thanks

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.

cheers for the help bob but i decided to begin the form again and it works fine now.

i tried added the code to my form's On click settings but it still doesnt work. could you tell me how would i put OPTION EXPLICT as one of my database options please

no i dont have intLogonAttempts anywhere else in the coding. could this be the problem.