Search results

Thanks Telecom That is exactly what I wanted Many Thanks again

telecom thanks for your speedy reply. I can do the message bit, the part I am having trouble with is knowing if any records are associated with the record I want to delete, so i can display a user friendly message and not the access one which says (relationships that specify cascading deletes...

I want to replace the standard Access Delete Messages, with my own. I know how to use set warnings. I have cascading deletes option turned on. I need to tell if a record I am about to delete has associated records, so i can change the access message to a more user friendly one. eg "Deleting...

Hi I have added some command buttons to a form and added some extra code behind them. I want to use the same buttons and code in several other forms within my database. Is there a simple way for me to be able to do this, as copy and paste only copies the buttons and not the code behind them...

Thanks for all your help Scott I now have it working

Sorry what field do i use in the player table to make the link to the Junction table. If i use adultid, surly this will only link to one adult record,with many roles. A player can be attached to more than one adult. Apologies if i am missing the point here.

I am still a little confused. As a player can have more than 1 guardian, what fields do I need in the player table to make the link to the adult table entries. Thanks

Thanks Scott

I am trying to build a database for a local football team, and am having trouble with the design of the tables. The database contains numerous tables but my main problem is that within the database there are 4 types of people information: Players: (a player can have more than 1 guardian...

A guardian could also be a member of staff. How do i deal with that. Thanks again for your help

i have not used junction tables before. If all my people are in one table, how can i show what guradians(can be more then one), are resonsible for a player, in a form. I used seperate tables so the guardian info, would be shown as a subform on a player main form. Sorry if i sound nieve. Thanks...

i am creating a database for a local football club. I want to show player information (the main focus of the database), such as, what guardians are responsible for this player, what are the Doctors details for this player, what team does the player play for etc. I have seperate tables for the...

Thanks again Scott. If I add a button to open the New Guardian form from the player form how does the Junction table record get created. Sorry If I am being daft here, I have never used Junction tables before. Thanks in advance

Thanks for that Scott, but I am trying to add a New Guardian, so at present that Guardian name will not apper in a combo Box. A Player Record must exist for a Guardian record to be addded, so I have placed an Add New Guradian command button on this form. Is this the best way to add these...

I have created a junction table in my database.the tables being linked are tblplayerInfo to tblGuardianInfo. The junction table containd the PK of both these tables. A player can have more than one guardian (Mum,Dad, etc) and a Guardian can have more than one player (two sons, etc) On my form i...