how do I set up multiple diaries in MS Access?

[Guest]

I have many different resources which each require scheduling. I am
developing a simple MS Access application to control these resources. I need
to schedule a date and time for these resources and pass that date into the
rest of my application for further processing.

 

[John W. Vinson]

I have many different resources which each require scheduling. I am
developing a simple MS Access application to control these resources. I need
to schedule a date and time for these resources and pass that date into the
rest of my application for further processing.

It sounds like you need a table of Resources, related one to many to a table
of Schedules. The Resources table would have a ResourceID primary key, and any
descriptive info about the resource; the Schedules table would have a
ResourceID (as a link to the resource), and a date/time field for the
schedule. You may well want a TimeStart and TimeEnd field, I don't know if
you're scheduling points in time or blocks of time.

John W. Vinson [MVP]

 

[Guest]

Thanks John, that would work but ideally I am looking for a visual display as
close as I can get to an Outlook calender so that I can see which resource is
available and when. I have since discovered a company called DBI Technologies
who create ActiveX controls doing almost exactly what I need but I need to
pass the diary entry information into Access record fields so that I can tie
it up with other data. These controls don't show a source field in their
properties so I don't see how I can get into the information recorded. Should
I follow up on the ActiveX line of thinking?

 

[Larry Linson]

Thanks John, that would work but ideally I am looking for a visual display
as
close as I can get to an Outlook calender so that I can see which resource
is
available and when. I have since discovered a company called DBI
Technologies
who create ActiveX controls doing almost exactly what I need but I need to
pass the diary entry information into Access record fields so that I can
tie
it up with other data. These controls don't show a source field in their
properties so I don't see how I can get into the information recorded.
Should
I follow up on the ActiveX line of thinking?

Many companies who create ActiveX controls do not create them for Access, so
there is no way to bind data to them from Access (which works differently in
that regard than classic VB, in which you bound data to a Data Control, not
to a Form as in Access; and also differently from DotNet languages). I
don't use the Outlook Calendar, and, if there's any possible alternative,
don't use ActiveX Controls because that's another complication in
distributing an Access application.

There are various Calendar examples, many done with Access forms and
controls. Several links are on MVP Tony Toews' site at
http://www.granite.ab.ca/access/calendars.htm. MVP Albert Kallal has
something at http://www.members.shaw.ca/AlbertKallal/ and MVP Stephen Lebans
has, at least, a date picker, at http://www.lebans.com.

Larry Linson
Microsoft Access MVP

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.