Recent content by Jgrant@soilsafe.com

Good luck with the race, hope all goes well. Glad I could help.

You can make a a new table, put the runner numbers in it through the routine above and then run an update query linking the two tables by ID I'll think about it a bit and get back to you.

Ok then this is what I suggest It looks complicated but should only take you a couple of minutes to do. In your registration table make sure you have a field for Runner Number Then on your form put Two new text boxes. Leave them unbound. (it'll drop onto the screen that way). write down the...

Vmortimer, This is a cheap and sneaky way to do it. In your table you have a field called ID. The program wants to put the ID field in to keep track of records. This number increases by 1 each time you enter a record. It's not good from what I understand to mess around with this number so...

Pat, I did notice that you pointed out I was saving the record before manipulating the data. If I don't save the record and the record is still dirty (I tried the If me.dirty then me.dirty=false routine and it didn't work) then how will access know the value of the applet field? I'm not sure...

I have 17 if then statements in the code for various options (facilities) I think the recordset code is left over from trying other things that didn't work. The data is being input in a subform and the if then statements are based on the answer to a question on the main form. What I was...

I addressed the same thing but put it in the code behind a button. I set up a field named last number. I needed to add a number of records at once so set up a loop. I added 1 to last number each iteration. Not sure if its the same thing as what you want to do but here's some code: Dim...

I have a subform connected to a main form. The subform is a tab form with a one to many relationship. The subform directs data from one of the fields in my subform into another hidden field in the record. it is based on an if then statement based on a field in my main form. THe problem is...