Search results

Hi jzwp22, I've decided not to make another list box on the calander, with the shifts changing regularly I don't think it would be effective to add it in, for now. On a side note. How easy would it be to add a couple more leave types? E. Holiday, Late and Other. With E. Holiday and...

Thats ALOT of work to do! Maybe I could cut a corner and make a report per week rota and just add a click box on each week to show the shifts for each team leader.

I've created them 2 tables as suggested apart from dtestart and dteen. Looking at the excel sheet how the shifts are set out, whats the best way to define them?

My company produces an update of sales each day for a month to date overview using SAS to generate a html intranet page which we can all view. Up until now I have been copying and pasting these SAS driven tables off the intranet, into excel and then linking the cells from the pasted table into...

We usually have a shift review every 12 months, though having said that we have had 3 in the last 6 months... I can't see them changing them again for another 12 months. I've actually attached the excel sheet so you can see the types of shifts they have. 4 team leaders are on 'main...

This is almost right... in the current design the combo box/fields will only show if a team leader has holiday booked, is there anyway to have the combo box show all team leaders entitlement and remaning, regardless of booked holidays? Just another quick question, more for direction rather...

Just for all employees, a combo box to choose the employee will do. I'm able to add a sub form into the calander, its just a matter of linking the child and to a combo box

Hmm.. On the main form we have the entitlement subform displayed. This will show employees entitlement when chosen from the drop down box, it shows Year, Entitlement, entitlement remaning. I'm thinking that this subform would also be helpful to have attached to the calander form, the reason...

That seems to have done the trick. I've tried various dates and it seems to work. I guess the fail safe way is to input dates as dd/mmm/yyyy. On a side note, this might seem a bit over ambitious... Like on the main holiday booking form is there a way to add an entitlement subform to the...

jzwp22, Sorry to bother you yet again but I have ran into a problem and am stuck! I started to update the Db with past holidays etc getting it up to date year to date. But there seems to be a couple of problems. When I enter a holiday I am using the USA syntax of mm/dd/yyyy as previous...

It works like a dream. Thank you

Hi jzwp22! Just a quick question to see if its possible. Currently the code which you added to check if 2 managers have a day off below is as below: rivate Sub Form_BeforeUpdate(Cancel As Integer) Dim holdcount As Long holdcount = DCount("datebooked", "HolidayBookings"...

jzwp22 you're a star! I guess all I need to do is add the code when the calander button is clicked. Easy enough! As for the list box, in the orginal DB and the one which you have just uploaded, if you click on a day of the month where there is a holiday booked it will display the detials, it...

Hi, Once again thank you for your patiences with me. Attached is the DB.

Seems whatever I do I still cant do either :(

Its me... again... I've created the addtional reports, thats fine :) I'm trying to amend the entitlement sub form to add another coloum for entitlement remaining. I've linked the boxes control source to the qryHolidaySummery using the expression building, but it doesn't want to work...

Will do...thanks again.. I'll try and do them reports and re implament the calander. Any problems I'm sure I'll let you know!

One of the most helpful persons I know on this forum. Top respect. Jay.

You have been extemely helpful to a access starter! If I could give you more rep I would! But it won't let me!

Wow...just...wow. I don't know what to say! Would it be easy for me to re add in the calander feature? I know the report you made shows all the details in regards to that managers entitlement, but can i also add something on the main form to show what that managers entitlement is left...