* Edit post
* Delete post
* Report this post
* Reply with quote
Footnotes/Endnotes In Access
Post by Sundog » 12 May 2010, 05:51
I am creating an Access data entry form to populate an Access database. Many of the records require source info, like a footnote/endnote in Word.
I plan to have a text field in each record to capture this reference info; some sources may have data there; some may not; and some data may not be entered sequentially (That is, as the user fills in the form, records 2, 9, and 21 may have a "footnote." Later, more data entry is done, and a footnote is added to record 13.)
Is there a way to autonumber these text fields, the way Word does, so insertion between "footnotes" causes a renumbering? The end product of this effort will be a report that looks, to the extent possible, like a Word document, with endnote numbers corresponding to reference numbers for records in the text.
Lastly, would Access 2007 be favored over Access 2003 to accomplish this effort?
Any hints, tips, or pointers welcome.
* Delete post
* Report this post
* Reply with quote
Footnotes/Endnotes In Access
Post by Sundog » 12 May 2010, 05:51
I am creating an Access data entry form to populate an Access database. Many of the records require source info, like a footnote/endnote in Word.
I plan to have a text field in each record to capture this reference info; some sources may have data there; some may not; and some data may not be entered sequentially (That is, as the user fills in the form, records 2, 9, and 21 may have a "footnote." Later, more data entry is done, and a footnote is added to record 13.)
Is there a way to autonumber these text fields, the way Word does, so insertion between "footnotes" causes a renumbering? The end product of this effort will be a report that looks, to the extent possible, like a Word document, with endnote numbers corresponding to reference numbers for records in the text.
Lastly, would Access 2007 be favored over Access 2003 to accomplish this effort?
Any hints, tips, or pointers welcome.