Search results

Just create a 2nd form that includes the field that is not entered. You can sort or filter the records however you want.

Thank you for your help. I just want to make sure that I make this as logical and stable as possible. Before I continue just one more question if you don't mind. Do you think that the relationships between tblPeople and tblEntry is okay? I have gotten some criticism for this because it...

George, Thanks again for your help. I was thinking about this. Do you think that it would be better to only put show_fk in tblShowClassEntry or put it in both tblShowClassEntry and tblEntry? Like I said earlier, I don't think it would be smart to have more than one horseshow's classes tied to...

Thank you so much for trying to understand what I am doing. The problem with using the same entry with multiple horseshows is that the information may change from show to show. For instance a horse may be sold, or the horse's rider may change from one horseshow to the next, or the horse may...

Thank you for your reply. I realize I must have expected a little mind reading. Sorry about that. Let me see if I can explain. We are having a group of horseshows in 2008, probably 8 (tblShow). Each horseshow will have the same classes (tblClasses). The same horse may or may not show at...

I am doing a database for a small horseshow circuit. I originally designed the database with an append query that filled a table to join tblShow and tblClasses. I am trying to change the database to avoid doing this. I am concerned that the users will not be able to do this correctly. I have...

syntax Rabbie, Thank you for the post. I am sure that is the correct direction. However, I need the top 2 for each division. I have entered the following in criteria: In (Select Top 3 [SumofPoints] From qryPointsByDivision Order By [SumofPoints] Desc) The select statement is: SELECT...

Currently, I have the following table: tblPointsChart PointsNum_pk EntryCountMin EntryCountMax PlacementNum Points It is used to assign points based on: tblShowClassEntry ShowClassNum_fk EntryNum_fk PlacementNum_fk and qryEntriesPerClass that returns the number of entries in a class. My...

I am creating a database for a small horseshow circuit. Here is a sample of the structure: tblShow ShowNum_pk ShowDescription ShowDate ShowLocation tblClass ClassNum_pk ClassNumber (this is the number that will print on flyers, etc.) ClassDescription DivisionNum_fk Jumping (This is a yes/no...

Thank you. That worked.

I have a form with 4 tabs. The 3rd tab is has a subform in datasheet view that lists payments. In the footer of the subform I have Text Box TotalPaid with control source: =nz(Sum([PaymentAmount])) On the form I have Text Box TotalPayments with control source...

Thanks Rabbie. I used and that fixed the problem.

I have frmEntry with control HorseNum_fk. The user types in a horse's name. If the horse is not in the table, I want the frmHorse to popup with the horse name the user just entered. After entering further information, when the user clicks on the close button at the bottom of the field, the...

Thanks. That worked. I looked at this probably a hundred times and didn't see that.

Okay, I know this is probably simple, but I am getting an error in putting a total on a form. I have the following: Subform name is EntryDetail Subform I have a field in the footer called TotalEntry that calculates the total entry. The formula is =sum([EntryAmt]) Form name is Entry I have a...