Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-17-2006, 09:35 PM   #1
sloaner14
Registered User
 
Join Date: Apr 2002
Location: lawton, ok, us
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
sloaner14
Race Finish Place

Is there an easy way of doing this? I have a database that I want to automatically place racers as they finish. I have four race divisions. All racers no matter the division start at the same time. I have all of this figured out, but what is getting me is the finish place (1st, 2nd, etc.) Is there a way on a continuos form to automatically place the racers? How this works is...Main form has racer info., on this form is a stop button, and after the button is clicked, it will show his/her finishing place in their division which is subform of the main form. Here is the reason I want this. Someone may have registered wrong and they are in the wrong division, and we have to change them to the correct division after they have finished and already been placed. I want to be able to move them to the right division, and then my subform requery and they placed in the correct position in the new division. Sorry this is so lenghty. Plain and simple can I make a subreport have an unbound field that shows each records place the recordset? Thanks for your help, and like I said sorry this is so long.

sloaner14 is offline   Reply With Quote
Old 01-18-2006, 03:41 AM   #2
namliam
The Mailman - AWF VIP
 
Join Date: Aug 2003
Location: Amsterdam/The Netherlands
Posts: 11,415
Thanks: 0
Thanked 805 Times in 790 Posts
namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light
Sorry mate, but your text is near unreadable....

Try again, and maybe post a small database example of what you allready have. A picture (or a database in this case) can paint a thousans words....

Greetz
namliam is offline   Reply With Quote
Old 01-18-2006, 05:44 AM   #3
sloaner14
Registered User
 
Join Date: Apr 2002
Location: lawton, ok, us
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
sloaner14
Plain and simple:

Is there a way to have an unbound text box, in a continuos form, that will show the record number of each record in that form. The record at the top of the form will be 1, the next record will be 2, and so on down the form. I also need this to renumber incase I add a record, that might fall in between existing record (I add a record between 5 and 6, so this new record should be 6, and the record that was 6 is now 7, old 7 is now 8, and so on.

sloaner14 is offline   Reply With Quote
Old 01-18-2006, 08:18 AM   #4
sloaner14
Registered User
 
Join Date: Apr 2002
Location: lawton, ok, us
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
sloaner14
Here is a jpeg of what I want. Thanks, for looking at it.
Attached Images
File Type: jpg place.jpg (43.3 KB, 84 views)
sloaner14 is offline   Reply With Quote
Old 01-18-2006, 09:08 PM   #5
sloaner14
Registered User
 
Join Date: Apr 2002
Location: lawton, ok, us
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
sloaner14
Thanks for looking, but I created a place field, and used some vba and sql to renumber the fields for me.

sloaner14 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to evaluate only one place in a string. sfoster1 Queries 6 01-07-2005 07:56 PM
Race Form nx69 Forms 1 03-07-2004 08:23 AM
Sort race results into order PeterWieland Queries 9 07-03-2003 12:31 AM
Best place for datediff? StephenB Forms 5 05-21-2002 03:49 AM




All times are GMT -8. The time now is 10:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World