| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 26554 | 2002-10-30 02:27:00 | Access - Displaying a sequence number for records on a form | tbacon_nz (865) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 94496 | 2002-10-30 02:27:00 | I have a form/subform that displays records from a query on the subform. What I need to be able to do is display a sequence number against each record displayed on the subform. I.E. if there are 5 records displayed, they need to be numbered 1 to 5, if there are 8, 1 to 8 etc. This has got to be simple, but I can't work out how to do it. VBA is not a problem. Cheers, Tony |
tbacon_nz (865) | ||
| 94497 | 2002-10-30 11:36:00 | Does Access not have a record count function. Sorry don't use Access, much prefer programming in Delphi. A friend had a problem with Access and ever since then decided I would stay with Delphi. | mikebartnz (21) | ||
| 94498 | 2002-10-30 20:16:00 | Is this through a query? You could try using the "count" function, though i think that might just end up giving you a total |
roofus (483) | ||
| 94499 | 2002-10-30 20:56:00 | Yes Roofus, it is from a query, and count will give me a total - it is a number against each record that I need. I can do it with a report by using the on print event for the detail line. What I need is the equivalent for a form. Tony |
tbacon_nz (865) | ||
| 1 | |||||