Recent content by scooteman

If your querry holds both Home and away scores then you can add a calculated field with: High Score: IIf([HomeScore]>[AwayScore],[HomeScore],IIf([HomeScore]<[AwayScore],[AwayScore],IIf([HomeScore]=[AwayScore],[HomeScore]))) I tested it and it worked to show the high score for each record.

adamskiii, You may want to rethink your game table. Are all the teams that play, are they all in the Team table? Does a record only hold the score for one team or are your recording the scores for both teams. If all the teams are not in your Team table, them maybe it would be better to have...

I don't think queries will run with the double join you're trying to make. It should work fine with just the one join of [TeamID] to [HomeTeamID]. Are the Away Teams not in your [Team] table? If they are not, then adjust your join type to show all the [Game] records and only [Team] records...

adamskiii, Did you get your database working? Are you using Access 2007? Brianwarnock is correct in that you should enter data through forms instead of directly in the tables. Forms can be setup to look like a data sheet similar to the table if that is how you prefer to enter data. If you...

Make sure all your other fields are set to allow duplicates. The one that was the previouse primary key may still be set to not allow dulicates.

I would recommend you add a new field called [RecordID], set it to autonumber and make it the primary key field. I am guessing that the table has made your [HomeTeamID] field as the primary key field and will not allow duplicates.

I don't think you can do that type of validation on the feild level. Try it at the Table Records property level. (In table Design mode, right click on the top left corner to get to the table records property sheet) Are the ID feilds numerical? If they are a simple rule at the table records...

If you are adding the information through forms, you may be better off to use VBA than the validation property. I had a similar issue and it was suggested in this forum for me to use the DCount() function. I have a training database and a form to spot missing training. One subform on it shows...

Thanks, I will look at that. I am trying to make the database as simple as I can for my wife to use. I had her using an old customized 97 access Northwind database for the last few years, but my wife has never liked it. Then this year it wouldn't convert to Access 2007 without lots of errors...

John, I fixed the problem. I had the Open Argument in the On Current Event, when I switched it to the On Load Event, the form started to behave correctly. This is what I had in the On Current Event: If Me.NewRecord Then Me![CustID] = Me.OpenArgs

I am building a simple sales record database for my wife who sells Watkins products. I have a main form that lists all her customers. I open an Order Entry form using an OpenArg to pass the CustomerID to the order form and insert that value in the CustID field. Everything works fine except...

I have an Events Detail form for viewing the details of an event or adding a new event to the calendar. On that form is a subform that shows the time and title of any events that are on the same date that is selected. I would like to be able to click on the time of any of the events shown in...

Thanks for the suggestion. I will take a look and play with that. I originally didn't add the "Employee ID" as a where clause because it is built into the "Query_Find_Null as a criteria,(which shows me as a true novice at VBA) But it probably would be cleaner and better in the Dcount. I've...

VBAInet, Thanks so much for the help!!! The DCount() worked. This is how I did it: Private Sub Training_Name_Click() Dim trainmsg As Integer Dim LTotal As Long LTotal = DCount("Training_ID", "Query_Find_Null") If LTotal = 0 Then trainmsg = MsgBox("Are you sure you want to add this training...

I have a form that has two subforms on it in datasheet view. One shows the training an employee should have based on there job assigment and the other form shows what they actually have. I have the subform that shows what they should have with an on click event that adds the training type to...