zombiezoom
Last Activity: Apr 13 '10, 04:20 AM
Joined: Apr 3 '10
Location:
-
Thank you all for your help. The reason that I don't want to combine runnerid and raceid is because bib number are suppose be a tag number that runner wear on their shirt to identify their runner number. It cannot be a runner ID in my database because a race may only have 200 people while my database has information for more runners. I was thinking about generating a random number for a particular race and thus limiting bib number from say 1 to 250... -
Assigning autonumber
I am creating a runner table. I need help in assigning a bib number. I could have used runner id as a bib number However, a runner id is assigned to all runners in my database. Hence, it is not unique to a particular race. What I would like to do is input bib number unique to a particular race. I may have 10,000 runners in my database but only 200 runner running a particular race on certain date. Bib Number is a field that is part of race & runner... -
I am not exactly sure what you mean by RecordSource. However I selected the form that I am trying to input all data and copied and pasted the RecordSource. Hopefully this is what you are looking for. If not, please let me know. Sorry, but I a newbie to ms access and vba. Thanks for your help.
here is the RecordSource:
SELECT runner.runnerid , runner.firstnam e, runner.lastname , runner.streetad dress, runner.city, runner.state,...Leave a comment:
-
Yes, the values passed on from OpenArgs should give me eventid and raceid. However, the runnerid is autogenerated value coming from runner table. What I am trying to do here is input all three ID values into event-race-runner table. To do so, I wanted to use values in text boxes and insert into the event runner table. I tried using the following SQL command but I get an error message saying I have incorrect INSERT statement.
CurrentDb.Execu te...Leave a comment:
-
event-race-runner is a table.Leave a comment:
-
Hi RuralGuy,
I am still unable to solve the error message and I could really use some help. Here is additional explanation about my error:
I get error when I try to assign values into text fields "Me.txtAddRunne rEventid.Text" and "txtAddRunnerRa ceid". The text fields are part of an associative table (event-race-runner table). What I am trying to do is assign the value that I extract from a prior form...Leave a comment:
-
I use it to separate the arguments that I am passing from one form to another....Leave a comment:
-
Thank you. This is definitely lot easier and I am using this instead of my old VBA code....Leave a comment:
-
Thank you for your response. I am new to VBA and am not sure what exactly you mean by tags.
I get error when I try to assign values into text fields "Me.txtAddRunne rEventid.Text" and "txtAddRunnerRa ceid". The text fields are part of an associative table (event-race-runner table). What I am trying to do is assign the value that I extract from a prior form and insert into the event-race-runner associative table -...Leave a comment:
-
Help with error 2448: You can't assign value to this object
I need help with error 2448: You can't assign value to this object. What I am trying to do is allow user to select event id and race id from combo option. Once the user selects those, then the id associated with those is suppose to be carried over to a new form which should associated those two ids with runner id from runner table. Thus, I will have all three ids in event-race-runner table (which is an associative table). However when I do that I...
No activity results to display
Leave a comment: