notes field sequencing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help, I am trying to set up an access database and on my form I want the
notes field to automatically generate an new notes page each time, with the
date added and be able to keep up with previous notes as well.

I would like each entry to be it's own, with like a counter on top, so you
can look back at past entries.

Anybody know how to help me?
 
Help, I am trying to set up an access database and on my form I want the
notes field to automatically generate an new notes page each time, with the
date added and be able to keep up with previous notes as well.

I would like each entry to be it's own, with like a counter on top, so you
can look back at past entries.

Anybody know how to help me?
Click to expand...

You need *two* tables. Access doesn't store "pages"; you store data in
tables. A Note field would typically be a Memo field type. What you
might want is one table with your non-note data (your "main table")
with a Primary Key field (I'll call it MainID, you use whatever
fieldname you have defined as the primary key); the second table would
have fields MainID (matching the datatype of the primary key, Long
Integer if you're using an autonumber). The other two fields would be
SeqNo (integer) and Note, a memo field.

You could use a Form based on your table with a Subform based on this
notes table.


John W. Vinson[MVP]
 
Back
Top