Search results

I have a count(*) control in a forms footer which stores its data in a field (total records) for each record. This way, when a new record is added, the count should be one greater than it was for the previous record. This gives each record a consecutive ID for the records grouped on this form...

I don't know if this will help anyone understand what I'm doing wrong, but the point of this record count control and refreshing after insert is to create a sequential number label for each group of records. For example: There main form's records are are student names. Each student can have...

Hi Wayne. I think my explanation was confusing. I actually do not want the count to start over ever. The problem is that it IS starting over. I read a post by Pat Hartman for someone else's problem that recommended to put a control with Count(*) in the form footer. I tried this and it...

I have a control with a default value of "=count([field1])" in my form header. The form is refreshed after each new record is added so the count can be stored as data for each record. (So the first record stores a 1 and the second record stores a 2 and so on). This works fine when I add all...

Ok-I'll remember that. Thank you so much!

Nevermind! I got it working using macros instead, which is much better for me! Thank you so much for your help and your patience with me! Carly

Thank you both for your reply. I will try to explain this better. I do not want to select two values from the list. I want the first control to select the first value and the second control to select the second value and so on for seven controls so that one value is stored in each control. I...

I am trying to use ItemData to fill in the first row of a combo box into control1 and the second row of the combo box to fill into control2. This is what I've tried: Private Sub Form_Load() Me!Bx1LabelBox.Requery Me!Bx1Label.Value = _ Me!Bx1LabelBox.ItemData(0) End Sub This worked for...

That link is very helpful to me, since I am extremely unfamiliar with using code. I am still having trouble, however, with this one argument. I am trying to tab from the last control on subformA to the first control on subformB, where subforms A and B are both subform controls on the...

I am trying to use setfocus to move from the last field of the first subform to the first field of the next subform. I get an error message that says it is unable to locate my second subform. I have checked that spelling is correct. Why else would I get this message? Thanks in advance! Carly

Better yet! Yes, that avoided some of the input mask problems that were still coming up. Thank you both so much! Best, Carly

Thank you That worked perfectly, I'm good to go. I appreciate your help!

Does anyone know a way to limit characters entered into a textbox control on a form? ( I have never written a code, so I am hoping there is some secret property setting that I don't know about). I have been able to accomplish this using an input mask, but that is a cumbersome way of doing...

I would like to try this first if at all possible since I am not at all familiar with writing code and this seems fairly simple. I do have one follow-up question, however. I would know how to do this for a report running sum, because I can group by the student name field and use group...

I have a table of students and their objectives. Each student has multipe objectives, so my data would look like this: Name--Objective Name1-Obective1 Name1-Objective2 Name1-Objective3 Name2-Objective1 Name2-Objective2 I would like to generate labels for these objectives like A, B, C, D...