Linking an Access form to a Word document

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

Guest

I have a need to link the forms in my database to a Word document- while I
have figured out how to do this, I need to link EACH CUSTOMER in my database
to a new Word document, because I need to record the history for each
customer- Access has a 255 character limit, and I need a whole lot more than
that to record each clients history. HELP!!!
 
Hi,

This is almost certainly the wrong way to do what you need. If you want
more than 255 characters in order to keep notes on each customer, use a
Memo field rather than a Text field.

If you want to keep a proper history of your dealings with each
customer, it's best to do so in a separate table that can have multiple
records for each record in your customers table (like the Customers and
Orders tables in the Northwind sample database that comes with Access).
 
Back
Top