Search results

I have two tables that I do not believe I can join, but I need data from one of the tables during a query. Here is goes: In one table I have offensive football statistics, in another, I have player information. In the Offense Statistics tables, players are identified by number only. In the...

Got it I did a bit more digging on the site and found the following solution: In the Properties menu, set Data Entry to Yes. Why the default would be No, I haven't a clue. Thanks!

This seems to happen to me a lot. I use a command button to check various parameters, then open another form based on these parameters. However, I cannot seem to get the current form I am on to add a new record. Here is the code I am using that is part of a command button: If...

Got it Just posting to this forum seems to magically help the answer to appear. I put the following statement into the Criteria section Like Nz("Interception","*") Which changed all the the null values to 0 when I did a summation of the Return Yards.

In my database, I need to be able to search for a text value, then add the numbers associated with that text value. For example, if I search for Interceptions, I then want to add up all of the Return Yards associated with those interceptions. The problem I have is when there are no...

Excellent! I have no clue what the "(1)" in Count(1) does or means, but the SQL now works great! Thanks.

Tim, You have game planned wonderfully. Your assumptions about how I have bound the tables to the forms is correct. I will try all of your suggestions tonight and replay later. I as well will refrain from any more football metaphors! Thanks a bunch.

When I query a column in a table for a specific word (I want to COUNT how many times the word is in the list) and that word is not in the list, how do I get the query to return a value of zero instead of a null value? I am sure that NZ (or Iif) must be part of this and written in SQL, but I...

Hi Tim, The defense had you scouted, heard your audible and adjusted to stop you! The form frmOffense sends the information to frmScoring. frmScoring is bound to the table tblScoring and that is where the queries are calculated. Can this code be adjusted either in frmOffense or frmScoring...

Hi Tim, Thanks for the reply. Where do I put these bits of code? In the OnOpen part of the form? I have tried them in the OnOpen and still no requery when the form opens ....

I use access to gather statistics for football games. Let's suppose the home team scores a touchdown. The form that was used to gather the play by play information (frmOffense) then opens another form (frmScoring) to store what type of score, how long, the time, who, etc. frmScoring also...

I just stumbled onto the Nz expression to convert nulls to zeros. This is certainly what I need to do, but Expr1: Nz([qryFQDefScoreUs]![SumOfFQScoreUs])+Nz([qryFQOffScoreUs]![SumOfFQScoreUs])+Nz([qryFQSpecTeamUs]![SumOfFQScoreUs]) still returns a null value. When I do my original queries...

I am baffled without an example, your explanation does not help. I do not know what "just include some field which describes your summary" means to do. I have figured out what the problem is though. If any one of the individual summaries do not have any values that are greater than...

I have three different queries that find the sum of columns in three different tables. How can I then create another query that adds those columns together? I tried to build an expression that looked like thie in the field portion of the query builder Expr1...

Got it! Dim Opponent As String Opponent = Forms![Switchboard Items]![Opponent] DoCmd.ApplyFilter , "[Opponent] LIKE '" & Opponent & "*'" I have to admit, I do not know what the "*" wildcard stands for (extra columns maybe?), but this filtered my forms successfuly based on a combo box...

On my switchboard, I have a combo box where I select a team to keep football statistics for. I then click a command button to open what type of statistics to input (offense, defense or special teams). When I arrive at the new form, I would like to have it filtered so that only the records...

Excellent! Hey that worked perfectly! Thanks much.

In my football statistics database, I would like a message box to popup that indicates who scored. For example, if Detroit scores a touchdown, a message box would appear saying Touchdown Detroit. I know that I can simply code MsgBox("Touchdown Detroit", vbOKCancel) = vbOK but the teams that...

GOT IT I used a list box (rather than a text box) and put the query right into the RowSource box. I do have to write some requery code but that is easy!

No The form is based on a table. I just cannot seem to get a text box to show the results of this query with out coding it in VB.