Forms and Memos

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.
 
J

John W. Vinson

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.

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.

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.
 
S

Skip

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top