Forms and Memos

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I am trying to put a simple db together for my wife. I have a table and form
for her clients. I have all the basic information that she needs. What I want
to do is add either a large enough Memo with date time stamp and her notes or
be able to pull up a blank page from Word and keep it keyed to the client.
The second part is I need to tie in the Outlook Calendar to this db so when
she sets the next appointment, it will show in the Memo and the Calendar.
Any help or direction would be greatly appreciated.
 
I am trying to put a simple db together for my wife. I have a table and form
for her clients. I have all the basic information that she needs. What I want
to do is add either a large enough Memo with date time stamp and her notes or
be able to pull up a blank page from Word and keep it keyed to the client.
Click to expand...

I'd suggest a Notes table with a ClientID (a link to the clients table), a
NoteDateTime field with a default value of =Now(), and a Note memo field. You
can display this table using a query (sorted by NoteDateTime) on a Subform of
your Clients form.
The second part is I need to tie in the Outlook Calendar to this db so when
she sets the next appointment, it will show in the Memo and the Calendar.
Any help or direction would be greatly appreciated.
Click to expand...

That's a LOT more work - you'll need to use VBA code and get more familiar
than I am with the Outlook object model.
 
John,
Thanks for the help. It work very well for me. Now to conquer the easy one,
tying the db memo to Outlooks calendar.

Skip
 
Back
Top