MS Access

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

Guest

I have created a small database for a training provider, part of which is to
manage course schedules. Is it possible to export that data to a calendar
program that will allow us to view scheduled courses and the numbers of
students attending those courses. The database has been written in Access
2003. My knowledge of Visual Basic and Macro writting is limited and have
therefore used in-built wizards for most functions
 
Hi Skipper,

I just noticed that you've gone a couple of days with no response to
your issue.

The answer is "You can't get there from here". That is not to say
that you can never get a solution.

When you export data from within Access it is usually to a new file of
a format you select from the list Access provides for the operation.
Your options expand somewhat when you use VBA, they expand even more
if you go to low level File I/O. It will then be up to the other,
("Calendar"), application to import that file.

The SendObject action on the equivalent report in Access may be
closest to what you need. You'll have to research and try various
things.

As to the data you've already generated, we have no idea of its
organization and complexity. We also don't know anything about your
calendar application. Since this newsgroup supports Access it is not
fertile ground for discussing other platform. However, you could try
Google and other resources to see if there are newsgroups devoted to
that platform.

A word to the wise: If you intend to develop applications for the use
of others then learn to use VBA and drop the Access Macros to the
extent possible. VBA code is referred to as "macro" in all of the
other MS Office platforms and is available for other vendors to use in
their applications. Many have done.

Post back with any questions. My the way, as well as this one, there
is another newsgroup devoted to beginning Access developers:
microsoft.public.access.gettingstarted

HTH
 
I have implemented a month schedule calendar module that I developed for a
number of customers. There is a calendar form and calendar report. Both look
like a page torn from a conventional calendar. The month and year are
selectable. The calendar displays different data for each day. Data can
easily be added directly from the calendar form. One implementation was an
application very similar to yours. It was for a training department in an
eight hospital conglomerate. The calendar displayed all scheduled courses
and course times. If you are interested, I can send you a screen shot.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Here we go again.

Steve you really must be thick. You have been told many times that these
newsgroups are for FREE peer to peer support, not your own personal hunting
ground to con unsuspecting Access users of their money.

John... Visio MVP (Copenhagen)
 
Here we go again.

Steve you really must be thick. You have been told many times that these
newsgroups are for FREE peer to peer support, not your own personal hunting
ground to con unsuspecting Access users of their money.

John... Visio MVP (Copenhagen)
Click to expand...
Are you telling the world-wide readership that this person will take people's
money to develop an application, but will not deliver it?
 
Whether Steve delivers applications as promised or not isn't the issue.

These newsgroups are intended for free peer-to-peer help. Steve uses them
primarily to advertise his services, which is not their intent. (And to
forestall any complaints from Steve, yes, once in a while he does provide
some free help, and that's appreciated.)
 
Back
Top