Search results

I am starting to learn to use form is access and have created an unbound form because I beleive you have more control over table records. My question is, how do I validate fields on my form first and then once all validation are correct and no errors appear it saves the record? This is currently...

Thanks everyone. Appreciate it. working great :D: For Winning Team: winningTeam: IIf([homeScore]>[awayScore],[homeTeam.name],IIf([awayScore]>[homeScore],[awayTeam.name])) For Winning Score winnerScore: IIf([homeScore]>[awayScore],[game].[homeScore],[game].[awayScore]) For Losing Score...

Thanks for the help. I was able to get it working and I can now see what teams were away/home on a particular date. I am now making a query that will show the name of the winning team. This is what my tables currently look like in Access: To create the winning score I want to use...

That is not working for me. :( Here is my query: I want that empty line to be like the one above it, a many-to-one relationship. I cant figure it out. I want to show a query of game dates and which teams were away/home. Cant do it because awayTeamId is not related to the team table. :(

Thanks for all the answers. I got it to work fine now :D. Just one last question. In my relationships, how do I make so that I have my teamId in my team table connects to both the awayTeamId and homeTeamId in the game table? It says I can only have one relationship per field but I know there is...

I have added a RecordId field, made it an auto number and primary key but still the same message :(

Thank you cooteman. I got the validation to work but now if I was to insert data in again to show that a team is going to play the same one again, but on another day I get this error: Any help on how to remove this? I have allowed it to make duplicates but still nothing. Thanks

thanks for the answer but I do not know how to use the forms yet in Access. Is there any way to use the validation? Thanks

I am making a database for hockey teams and games. How can I create a validation rule so that one team cannot play itself and that a team can not play the same team more than once a day? I have tried: IIf([homeTeamId]=[awayTeamId]) But this is not working. Any help would be appreciated. Thanks:)

thank you soo much. This is exactly what I was looking for:D

thanks, but there are many rows with checkbox's that I have. if I set them all to false then only one row will show up. I want to replace all the current columns such as carlessDriv and speeding with just one. Below this column it will show the name of the checkbox's that are checked.Any idea?

I am building a query and want to show only the checkbox's that have been checked. What kind of validation rule/formula can I make so I can create my own column title and then show the name of the checkbox's checked? Here is a picture of what it currently looks like: Instead of having all the...