Search results

Upon a user request, the following code gets executed to clean out and initialize the "Scores" table with a competitor number and an event number. Each competitor can have 20 event scores. A crosstab query is used to gather up all the appropriate scores for each competitor and calculate a final...

I'm running a database with approx 17k records of data that is associated with 2k records of users. My concern is that when I run a VBA-based calculation to extract the top 4 records for each of the users that I do not get a fully repeatable result. I have created an exception check and between...

Using Access 2000. I have a select Form with an unbound list box from table of contest participants. Each participant has a unique number. Three tables of data that use the participant number as the key. First table has name, category, etc. Second table has scores. Third table has an additional...

Simple wish to wrap to the top record in list box when bottom is reached. I stumbled across a thread for this solution once, but failed to book mark it. I have searched in vain but I know it already exists!

I'm attempting to create a form that has a checkbox in addition to some numeric entry fields. The checkbox is True/False and it is a tab stop on the form. 1. Is there a keystroke that can change from True to False (check/uncheck), or is a mouse click required? This form will be used extensively...