Search results

How can I have my continuous form always expand to see all records instead of having a scroll wheel? The following code seems to work well when I have up to three records, but any more than three records and the subform no longer grows but only displays a vertical scroll bar. How can I...

Thank you for the response and the inciteful feedback! Right after my SeqNum column is calculated, I will immediately concatenate the SeqNum value into a combined field that will servce as the reliable value once it is established. WIll a concatenated field be updated when one of its original...

So I introduced an autonumber ([ID]) field, which no one will really see. I want to update the SeqNum field with a running number based on the ClientName field value for each existing record in my table. The autonumber value probably won't matter at all because I plan on concatenating the...

Thank you!!! this really clicked for me. Now I understand! I have an autonumber now, and found an example online that utilizes your suggestion in what might be a SELECT query, but now I am trying to figure out how to utilize the function in an Update query where the produced outcome updates...

Thanks for the response! Doesn't Autonumber get tricky though? and there will be different SamplePeriod values and so there would be a number of multiple sequences, one per unique SamplePeriod field value. Autonumber plays well having multiple sequences per table? I always hear that it's...

I have one table that gets a number of records imported into it several times a month. There are two fields I am trying to establish query programming for that will likely have to reference some VBA. I am a bit of an Access noob who sometimes has a hard time grasping how to cobble things...