Outlook and Access

[Stephen Glynn]

I'm trying to build a patient appointments system in MS Access 2000
(though we could upgrade to XP if that would make life easier).

It occurs to me that I *should* be able to keep the patients' names and
addresses in Outlook 2000 and make appointments for them there and
handle the treatment records and billing in Access.

However, I don't know how to do this. While I know how to link and
import tables from Outlook to Access, I'm then stuck. I've just tried
importing my calendar into Access and ended up with a table that tells
me all my appointments and when I made them but doesn't tell me when I
made them for.

Anyone know where I can find out more about this?

Steve

 

[Milly Staples [MVP - Outlook]]

I would try a good book on programming Access and Outlook. I know that
Outlook has a few web pages devoted to programming (slipstick,
outlook-tips,howto-outlook, etc.) but I am not aware of any Access web pages
with code samples and simple primers.

Have you posted this to an Access or Outlook programming group?


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, Stephen Glynn
asked:

| I'm trying to build a patient appointments system in MS Access 2000
| (though we could upgrade to XP if that would make life easier).
|
| It occurs to me that I *should* be able to keep the patients' names
| and addresses in Outlook 2000 and make appointments for them there and
| handle the treatment records and billing in Access.
|
| However, I don't know how to do this. While I know how to link and
| import tables from Outlook to Access, I'm then stuck. I've just
| tried importing my calendar into Access and ended up with a table
| that tells me all my appointments and when I made them but doesn't
| tell me when I made them for.
|
| Anyone know where I can find out more about this?
|
| Steve

 

[Stephen Glynn]

I would try a good book on programming Access and Outlook. I know that
Outlook has a few web pages devoted to programming (slipstick,
outlook-tips,howto-outlook, etc.) but I am not aware of any Access web pages
with code samples and simple primers.

Have you posted this to an Access or Outlook programming group?

Not as yet but I will do. I've tried M.P.A.GettingStarted since
they're usually good at steering you to the most appropriate specialist
pages but the only suggestion I've had from there so far is to look at
slipstick, which I have done but couldn't find anything particularly
relevant.

It shouldn't, at least as far as I can see, be a particularly
complicated programming problem. I could work it out myself if only I
understood Outlook's table structure, which I don't (I'm not completely
sure where it keeps them).

I probably shouldn't say this in a Microsoft group but the headaches
that Outlook gives people working in Access really is a serious flaw, at
least to my mind, in the whole Office suite, particularly since Access,
Word and Excel work together so easily. It just seems silly that you
can very easily find your contacts' names and addresses in the Outlook
address book from Access but you can't readily find out what
appointments you've made with them.

Steve

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, Stephen Glynn
asked:

| I'm trying to build a patient appointments system in MS Access 2000
| (though we could upgrade to XP if that would make life easier).
|
| It occurs to me that I *should* be able to keep the patients' names
| and addresses in Outlook 2000 and make appointments for them there and
| handle the treatment records and billing in Access.
|
| However, I don't know how to do this. While I know how to link and
| import tables from Outlook to Access, I'm then stuck. I've just
| tried importing my calendar into Access and ended up with a table
| that tells me all my appointments and when I made them but doesn't
| tell me when I made them for.
|
| Anyone know where I can find out more about this?
|
| Steve

 

[Milly Staples [MVP - Outlook]]

Easy answer is that Outlook provides the ability to check activities with
contacts.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, Stephen Glynn
asked:

| Milly Staples [MVP - Outlook] wrote:
|| I would try a good book on programming Access and Outlook. I know
|| that Outlook has a few web pages devoted to programming (slipstick,
|| outlook-tips,howto-outlook, etc.) but I am not aware of any Access
|| web pages with code samples and simple primers.
||
|| Have you posted this to an Access or Outlook programming group?
||
||
|
| Not as yet but I will do. I've tried M.P.A.GettingStarted since
| they're usually good at steering you to the most appropriate
| specialist
| pages but the only suggestion I've had from there so far is to look at
| slipstick, which I have done but couldn't find anything particularly
| relevant.
|
| It shouldn't, at least as far as I can see, be a particularly
| complicated programming problem. I could work it out myself if
| only I understood Outlook's table structure, which I don't (I'm not
| completely
| sure where it keeps them).
|
| I probably shouldn't say this in a Microsoft group but the headaches
| that Outlook gives people working in Access really is a serious flaw,
| at least to my mind, in the whole Office suite, particularly since
| Access,
| Word and Excel work together so easily. It just seems silly that
| you
| can very easily find your contacts' names and addresses in the Outlook
| address book from Access but you can't readily find out what
| appointments you've made with them.
|
| Steve
|
|| --
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. Due to
|| the (insert latest virus name here) virus, all mail sent to my
|| personal account will be deleted without reading.
||
|| After searching google.groups.com and finding no answer, Stephen
|| Glynn asked:
||
||| I'm trying to build a patient appointments system in MS Access 2000
||| (though we could upgrade to XP if that would make life easier).
|||
||| It occurs to me that I *should* be able to keep the patients' names
||| and addresses in Outlook 2000 and make appointments for them there
||| and handle the treatment records and billing in Access.
|||
||| However, I don't know how to do this. While I know how to link and
||| import tables from Outlook to Access, I'm then stuck. I've just
||| tried importing my calendar into Access and ended up with a table
||| that tells me all my appointments and when I made them but doesn't
||| tell me when I made them for.
|||
||| Anyone know where I can find out more about this?
|||
||| Steve

 

[Stephen Glynn]

Sorry, I don't quite understand. I want to make appointments for
patients in Outlook and then use Access to store details of their
treatment sessions, medical records and so on and to handle the billing.

All I need to know, I think, is how Outlook's table structure is set up
and where to find the tables.

Steve

Easy answer is that Outlook provides the ability to check activities with
contacts.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, Stephen Glynn
asked:

| Milly Staples [MVP - Outlook] wrote:
|| I would try a good book on programming Access and Outlook. I know
|| that Outlook has a few web pages devoted to programming (slipstick,
|| outlook-tips,howto-outlook, etc.) but I am not aware of any Access
|| web pages with code samples and simple primers.
||
|| Have you posted this to an Access or Outlook programming group?
||
||
|
| Not as yet but I will do. I've tried M.P.A.GettingStarted since
| they're usually good at steering you to the most appropriate
| specialist
| pages but the only suggestion I've had from there so far is to look at
| slipstick, which I have done but couldn't find anything particularly
| relevant.
|
| It shouldn't, at least as far as I can see, be a particularly
| complicated programming problem. I could work it out myself if
| only I understood Outlook's table structure, which I don't (I'm not
| completely
| sure where it keeps them).
|
| I probably shouldn't say this in a Microsoft group but the headaches
| that Outlook gives people working in Access really is a serious flaw,
| at least to my mind, in the whole Office suite, particularly since
| Access,
| Word and Excel work together so easily. It just seems silly that
| you
| can very easily find your contacts' names and addresses in the Outlook
| address book from Access but you can't readily find out what
| appointments you've made with them.
|
| Steve
|
|| --
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. Due to
|| the (insert latest virus name here) virus, all mail sent to my
|| personal account will be deleted without reading.
||
|| After searching google.groups.com and finding no answer, Stephen
|| Glynn asked:
||
||| I'm trying to build a patient appointments system in MS Access 2000
||| (though we could upgrade to XP if that would make life easier).
|||
||| It occurs to me that I *should* be able to keep the patients' names
||| and addresses in Outlook 2000 and make appointments for them there
||| and handle the treatment records and billing in Access.
|||
||| However, I don't know how to do this. While I know how to link and
||| import tables from Outlook to Access, I'm then stuck. I've just
||| tried importing my calendar into Access and ended up with a table
||| that tells me all my appointments and when I made them but doesn't
||| tell me when I made them for.
|||
||| Anyone know where I can find out more about this?
|||
||| Steve