Populate Annual Calendar Report

[oxicottin]

hold shift key down while DB opens There is also code in the frmCalendar(s) OnOpen Event to hide the menu's. Change the code below to true to enable it.

Application.CommandBars("Menu bar").Enabled = False '*****Disables Menu Bar******

 

[mafhobb]

Thank you Oxicottin. I am now looking at the code.

Do you know if there is any way to create a report so it basically exports the same way as it looks in the screen?

In other words; instead of getting an attendance report in list form, can a report be designed so basically what is on the screen is what gets reported? How would you place an absence in a specific location on a report (its date)?


mafhobb

 

[mafhobb]

Aha! I found it, your "yearly Report" does that.

Let me study how it works.

mafhobb

 

[natale]

Can I use this for my own purposes and if so what is the password? Can I make changes to this and how do I do that? I am very new at using access. I appreciate any help that can be given.

 

[oxicottin]

natale, you can use it for what ever you want also, To open the back door just hold down your shift key while opening the database and the password to get into employee stuff is "soggycashew".... Enjoy!

 

[natale]

Help. I can't find a database that has all of the things that I need in it. Is there a way to modify one to include certain things like, employee number, job code, title, status (ft/pt), next review date, last rate change?

 

[natale]

Is there any way to merge this one with the Attendance one?

 

[poucedeleon]

Oxicottin,
I would like to try and use your Calendar in a "Visiting Schedule" Program. I must admit I am not a very good programmer although working at it each day. I noticed there have not been any post in awhile on this, so I am hoping you will be open to some questions and advice. Let me explain how I will use it. Staff in housing units will take request from inmates to schedule a visit time. The receptionist will see a list of scheduled visits "by the hour" in a different front. They will click a checkbox or drop-down that says the visit happened or there was a no show. Here are some of the things I need to add and delete. I don't need all of the report for the types of attendance. I want to keep the command buttons that show how many days/visits (they only get one per day) have been used. Also I would like to change one of the buttons to show how many visits are allowed per week. Some get 3, some get less. For each housing unit (Department) the staff need to be able to set/change the number of visiting booth available. Some times one will break and be out of service. As visit are scheduled the programs needs to not allow more visits scheduled then there are booths available. As visits are scheduled there needs to be a time stamp that tells when the visit was scheduled as well as the time on the day it is for.

Thats a good start. I am planning on stealing part from other dbs I have. I will post a example as I get started or stuck on Saturday.
Thank in advance
http://gallery.me.com/poucedeleon#100164

 

[buddd]

I worked with Oxicottin on the calendar, I am attaching another calendar that does show the time. Perhaps you can use it to get the code you may need.

Dave

 

[poucedeleon]

Thanks Dave,
I will look at it. I am very close to get the other one to work. I am getting a popup because I changed the name of a field and can not find the reference anywhere, (small problem) I added a combobox for time "InputTime" on the frmInputBox. I basically copied the setup of the Select Entry conbobox. I'm not sure that I added it correctly to the code in the OK cmd buttom. I posted a copy of the db and the error message. If you get a chance take a look and let me know what you think. Hopefully I am going in the right direction.

 

[Rach!]

Hello Everyone,

I've been looking through these threads which go back quite some time but i hope you can still help. With the Annual calendar database, does anyone know how to convert it to Hours of holiday instead of days? I'm try to set up a database :banghead: for people who work shift and annual leave/Vacation is calculated in hours?

Many thanks in advance!