Link Access DB form to a spreadsheet or word doc.

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

Guest

I need to store data with more than 256 characters. (Basically notes that may
be up to a paragraph or two.) I have a form and a table created in Access
that stores all the data about students. I do not have enough room to add
comments in the comments field. How do my users open another application /
and attached file like Excel or Word from my form. Then save an return to the
form.

Can this be done? Is there a better way to store notes. I need to attach
these notes to each individual record.
 
Why not just use a memo field for the notes?

I need to store data with more than 256 characters. (Basically notes that may
be up to a paragraph or two.) I have a form and a table created in Access
that stores all the data about students. I do not have enough room to add
comments in the comments field. How do my users open another application /
and attached file like Excel or Word from my form. Then save an return to the
form.

Can this be done? Is there a better way to store notes. I need to attach
these notes to each individual record.
Click to expand...
 
All you need to do is define your field as Memo data type. I don't recall
the maximum on that, but you probably will not reach it.
 
Back
Top