Recent content by scukaf

Guys, this works great! Thanks for helping me, I can only set this thread as Solved :)

The whole database has been reworked. Thanks on suggestions. I forgot to thank you all and make this thread as solved...

Hi guys, i have a little problem regarding the code that i wish to use on my form: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Status = "Installed" Then If IsNull(Me.[Install Date]) Then MsgBox "If status is Installed, you have to enter Date value", vbOKOnly...

thanks to everyone on your suggestions. tomorrow i start with my 5-day night shifts and will certainly try to do something with this unfortunate db. i'll keep you posted ;)

okay, i get the point and obviously I'll have to completely rework database (or make separate query for every [name], which is clumsy - I agree), no matter what users will say. As mentioned, from the beginning the whole db was set wrong, but it was the only way I could have done it. Guys I...

Yes I'm aware of this and I'd usually do something like this, but users who will use this DB will have to see all the names for all the dates exact like I showed you in the attachment (for example dates for current month). As this DB is practically finished and many person/days were spent...

Sure Minty: So the structure of table is like in attachment "Table_preview" : 1, 2, 3 are shifts, empty space is non-working day.

Hi everyone, I introduced myself as I am a new member (although reading this forum for a quite a time now)... guys I have (for me) a serious problem that i cannot solve: So, I have a table which tracks employees shift schedule (shifts are like 1 - morning shift, 2 - afternoon shift, 3 - night...

Hi everyone. Until now I have been just surfing and finding solutions at this God's giving forum and finally took courage to register an account here. So, cheers! -- scukaf