Recent content by rwwilliamson

Thanks, Dave, that's an elegant solution. And fast as you said. If the "Scores" table never gets damaged, then just doing an update makes the most sense. I can keep the existing code with an option to rebuild the table if more competitors are added or events are added. I got off track because...

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...

In my original design, one of the linked tables in the form-initiated query was actually a crosstab query of the scores table. Apparently a crosstab cannot accept an input from a form because when I replaced the crosstab with a simple "total of" query, then the form input works as expected and...

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...

Thanks Moniker, but that's not exactly what I need. I recall the code is an Event Procedure that's tied to "OnClick" for the list box. If scroll command is down, test for last record, if true, then jump to first, else continue. If command is up, test for first record, if true jump to last else...

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!

Presuming you have a table that contains the 5 fields, and each is formatted as "currency", then the simplest way is to populate the form from a query that will assemble the desired total. If the table is created correctly in the beginning, a null (blank) record isn't possible, since each field...

Even though this was not my original post, I'm quite interested, as I have the same need and had solved it by forcing the default. I did put in the recommended line of code for my listbox and when the form opens, I do see the top record surrounded by the dotted line, but the form data is empty...

Since one column in the listbox is bound, you can set the "default value" for the listbox to the first value of the bound field. Upon opening the form, the listbox will have focus and the default value will be selected. In the listbox properties, create an event procedure for "On Click" that...

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...