If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record # shown in the navigational buttons
I am using Access 2003 to build a database that stores information for every
intubation performed on patients. I use a subform in a main form to capture the information for each intubation that is performed. For example, on the main form I have patient A's demographics. I then enter the first set of intubation information for patient A in the subform. If the intubation was unsuccessful then I need to perform a 2nd attempt on patient A, so I click the navigational button on the subform to move to the 2nd record and so on. I move to a new record on the main form for patient B and repeat the above steps. Is it possible to store the record # that is displayed by the navigational button on the subform, to my table? I need to report how many 1st, attempts, 2nd attempts, 3rd attempts etc. are done on each patient. I have some Access programming experience and would appreciate any help out there, or a better suggestions that what I have created. Thanks, Michael |
#2
|
|||
|
|||
Record # shown in the navigational buttons
Michael:
The "record number" that is shown in the navigation buttons really have no meaning whatsoever outside of the current session that you have. Access does not store the records in any meaningful order, but they can be displayed in a consistent order IF you assign a way to do it. You can set an autonumber primary key but autonumbers can actually skip around as they only really guarantee a unique number. The best way is to include a date/time stamp (date and time in ONE field) at the time your record is created. That way you can have the form display based on a query with the sort on the date/time created. -- Bob Larson Access World Forums Super Moderator Tutorials at http://www.btabdevelopment.com __________________________________ "Zortact" wrote: I am using Access 2003 to build a database that stores information for every intubation performed on patients. I use a subform in a main form to capture the information for each intubation that is performed. For example, on the main form I have patient A's demographics. I then enter the first set of intubation information for patient A in the subform. If the intubation was unsuccessful then I need to perform a 2nd attempt on patient A, so I click the navigational button on the subform to move to the 2nd record and so on. I move to a new record on the main form for patient B and repeat the above steps. Is it possible to store the record # that is displayed by the navigational button on the subform, to my table? I need to report how many 1st, attempts, 2nd attempts, 3rd attempts etc. are done on each patient. I have some Access programming experience and would appreciate any help out there, or a better suggestions that what I have created. Thanks, Michael |
Thread Tools | |
Display Modes | |
|
|