Click here to Skip to main content
15,896,478 members

Comments by SebSCO (Top 26 by date)

SebSCO 25-Nov-20 10:25am View    
It's sorted Thank You
SebSCO 25-Nov-20 9:11am View    
same as above need to be able to set static time to HH24:MI:SS
SebSCO 7-Dec-17 19:03pm View    
That is the problem I do not getting any error...

I set Point Break and run debugging and there is Time Out ...

That's why I'm confused but I will look and use a different method and if that will show anything.

Thank You for input
SebSCO 17-Jan-15 8:11am View    
thank you

it helps me a lot

To sort the dates i wil just create tblCalendar with fields like calendardate month nr month name and same for days day nr and day name and then i will relate fields from shift by crosstab to make sure the sun to sat will be 1 to 7 ect and I pull names of the days from calendar day name field

and that i think will sort it

now i need only to sort the scripts to generate the roster from week 1 to week 52 and when all that will start work i can focus on rest

eh challenging

Thank you for ur time Sir :)
SebSCO 17-Jan-15 7:12am View    
All done no problem with that but i'm looking to be able to add more shifts and set them as day In/Off using yes/no and it puzzle me how to creat that table or relationship

relating employee with shift is not a big deal but relating the days off or days in to the shift making me a problem

as later i want to realte it as well to calendar function to show it in a grid

Whre it will lokk more like

WEEK 3 18/01/2015
18/01 19/01 .......
Employee name Sunday Monday .........

David IN OFF

and so go on all list of employees
Coz in case one of them request a day off swap i need to be able to swap it
I will build that using CrossTab Queries but first i need to get the tables right and relationships between them