Full Version: Calendar Report Control?
UtterAccess Forums > Microsoft® Access > Access Forms
MerryB
Hello,
Thank you in advance for looking at my post.
would like to create a report using MSA2007, that has a simple calendar displayed on the detail line.
The first page of this report has to have months 1-6 , the second page 7-12.
This calendar does not have to have any other information embedded into it.
(simply a calendar).
Would something like this be considered an "add-in" ? Any suggestions would be appreciated
Thank you again
M.Berg
jmcwk
Merry,
Sorry I do not have an answer for you but what is the purpose of this display ?
MerryB
It's for nurses to X off the day they give a patient a shot. (each patient has there own calendar)
So the boxes on the calendar, will have to be big enough for them to "X", initial, and a code for the injection site.
sad.gif
MerryB
I"m considering embedding a word document ..
Has the "calendar is hand made in word now"
FOr perhaps I'll do a data transfer into word..
mmm
maybe that's the way to do this..
lol
jmcwk
Merry,
think what you need is a Form rather than a report . What do you table Structures look like ?
Something like
tblPatient
pkPatientID
fname
lname
etc.
tblPatientDetail
pkDetailID
fkPatientID
fkInjectionID
InjectionDate
etc.
tblkInjectionID
pkInjectionID
Site
jmcwk
Merry,
Maybe something like the attached will work for you and you can adapt to your needs ???
Double click a date and a form will open to add an entry to
MerryB
I do not capture the injection or the injection site inside the database.
HAs the nurses do not do data entry(nor does it need to be tracked).
The purpose of this report is to create fresh calendar yearly for each patient to store in there med chart.
Also gives a reference for the nurses to view injection schedules.
eing that we have a lot of people that are long term care, each year, this calendar sheet gets replaced in the chart.
sad.gif So my structure is fine,
I just need a calendar embedded into the report, but I just might use MS Word, and pragmatically send patient info into the header of the word document.
Unless there's an easy way to get this in an Access report.
Thank you,
MBerg
MerryB
Wowzers,
Thank you for the example sad.gif
I will glean as much as possible from it.
I especially like the Report_Fill() sub.
Nice code!
It's probably a little bit more that what I need at this point but still an excellent reference still the same.
Mberg
jmcwk
Your welcome Merry if you do an advanced Search in the Code Archive for Calendars you will find MANY examples, I just provided the one sad.gif Good Luck with you project and if help is needed just post up
MerryB
"Search in the Code Archive for Calendars you will find MANY examples"
Oknow way tooo many!
It's like a sea of calendar questions ! teehee
Thanks again!
Merry
jmcwk
thumbup.gif thumbup.gif
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.