R
refreshingapathy
Hello all,
I'm not very experienced with Access, I do more of SQL. I'm creating a
database for a college radio station to keep track of the songs they
play.
They want it to email playlists for every show to their music
department managers. I've already modified a database from a program
they use called CDTrustee (it gives lists and such of ALL the music the
station owns). The idea is that for each show the DJ opens up this app
and creates a "play list" of whatever music he or she played during the
show. The play list is then saved with a unique ID to an access db
(access 97).
The box is running XP sp2, office 97 and 2000 (installing that was
fun).
I have the "playlist" report all set up, sorted, etc. I also already
found an emailing script that works quite well.
1)How do I export the report to an attachment automatically? Most of
the scripts I've seen involve the user doing something. Is this a
process I could simply record a macro for?
2) I want the report to generate automatically after every show (I
don't necessarily trust the DJs to click any buttons), that would
contain only one show's worth of playlists. If that would be too
difficult, I would settle for emails once a day with the whole day's
lists.
3) the report should email to certain managers depending on the kind of
music played - if hip hop music played on a show, the hip hop manager
gets an email, if hard rock gets played the hard rock manager gets the
email. I'm guessing I need some kind of comparison statements here?
I really appreciate any help I can get, even if it's just pointers in
the right direction.
I'm not very experienced with Access, I do more of SQL. I'm creating a
database for a college radio station to keep track of the songs they
play.
They want it to email playlists for every show to their music
department managers. I've already modified a database from a program
they use called CDTrustee (it gives lists and such of ALL the music the
station owns). The idea is that for each show the DJ opens up this app
and creates a "play list" of whatever music he or she played during the
show. The play list is then saved with a unique ID to an access db
(access 97).
The box is running XP sp2, office 97 and 2000 (installing that was
fun).
I have the "playlist" report all set up, sorted, etc. I also already
found an emailing script that works quite well.
1)How do I export the report to an attachment automatically? Most of
the scripts I've seen involve the user doing something. Is this a
process I could simply record a macro for?
2) I want the report to generate automatically after every show (I
don't necessarily trust the DJs to click any buttons), that would
contain only one show's worth of playlists. If that would be too
difficult, I would settle for emails once a day with the whole day's
lists.
3) the report should email to certain managers depending on the kind of
music played - if hip hop music played on a show, the hip hop manager
gets an email, if hard rock gets played the hard rock manager gets the
email. I'm guessing I need some kind of comparison statements here?
I really appreciate any help I can get, even if it's just pointers in
the right direction.