Search results

I have searched the forum without success for a solution to this problem. I have a vocabulary list (in one column of a table) and each word's meaning (in the second column). I would like to create a quiz for my students where a vocabulary word is randomly selected. Then I would like to...

I use access to keep score during trivia games in my class. I have textboxes with spin buttons that updates the score. What I need is another text box above each of the previously named textboxes that rank each score. I could write a monster code that compared each text box to each other and...

Is it possible to show a PowerPoint show inside of access. If so, is it possible to code a form to direct the show (advance, back, etc.) Thanks.

Here it is Here is a bit of it. I click a command button called Kickoff. The form then instructs the user to select a kicker. I want the code to then wait until a kicker is selected from the text box. Then the code instructs the user to input where the ball was kicked to. I want to code...

Reply below .

I have an OnClick event that has several inputs before the form adds a new record. How do I get the code to wait for a text box selection until it moves on to the next line in the code?

Yes that works! and so does this which you posted elsewhere: Sum(IIf([Pass Play Status]="Interception",1,0)) used in the control box in the report gives individual statistics and gives 0 for when there are no interceptions. Both of which can be attributed to you. You have no idea how many...

GOT IT!!!!!!!!!!!!1 Took quite a bit of looking, but (again thanks to Pat H.) Sum(IIf([Pass Play Status]="Complete",1,0)) gives the number of completions for each quarterback individually on my report!!! Thanks to all!!!

Here is my setup I have a table that holds all of my offense information. The fields in use to count the number of completions, incompletions and interceptions are: Opponent Quarterback Pass Play Status Pass Play Status is a text field that can be null, "Complete", "Incomplete" or...

Tried that While the stats for each QB showup, the are the total overall statistics. I need individual totals for each quarterback. Here is what I use in the control box in the report to find total yards passing: =NZ(Sum([Passing Yards Gained]),0) This gives the total of all yards...

I have tried to gather information for reports using calculations in queries, but have not had a lot of luck. So I tried to do most of the calculations in a report using a most basic query. This is a lot easier, but there is just one snag: Here is some sample data my simple query generates...

If one quarterback throws 2 interceptions during a game and another throws 1 interception during the same game, I want my report to indicate that. I did try a different approach. Rather than doing the calculations in a query, and then having to tie different queries together, I did a simple...

That works except for... My quarterbacks are not showing up. Here is the SQL: SELECT Count(*) AS CountOfIncomplete FROM [Offense Game Input Table] WHERE ((([Offense Game Input Table].[Pass Play Status])="Incomplete")); I replaced PlayerID with [Offense Game Input Table].Quarterback (the...

Yes and to no avail I have tried a variety of different things and got some of them to work ... sort of. Below the column "Pass Play Status" I put "Incomplete" and then Is Null in the "or" section. The problem is when there is a complete pass, the query returns two rows - one for the count...

I have a query that looks for the number of incompletions that a quarterback throws. If there are no incompletions, then I want to return a value of zero. In the Field "Pass Play Status" I have set the criteria of "Incompletion" If there are incompletions, then the following expression...

I am trying to put three reports together on one page as one report. I opened a blank report that has no record source. I then added the three reports as subreports. None of them show up. The three reports are calcuated queries and are not related to each other in any way. I tried to put...

I totally understand this and knew it would be coming. I did use your advice from another post and created a query of the table so that the plays are in sequence according to the time and quarter they are scored in. I then look up the previous row in the query (that contains the touchdown...

On some of my forms, my SpinButtons are not visible until I record a new record or minimize then maximze the window. They simply show up as white boxes when I am in Form view. Their behavior seems totally random. On some forms, they always show up and on others, sometimes they do when I open...

In my football statistics database, I need to be able to add text from a current field to text in the previous record. For example: If a team scores a touchdown, then I have it coded to describe what happened: If Me.Score_Type_Description = "Rushing Touchdown" Then describe = "#" &...

Does anyone else experiece this? As soon as you post to the forum, the solution (or error in this case) appears out of thin air! My players numbers were numbers in one form and text in another. Grrr!!