timesheet table to create popup if timesheet entries is not entered day before

[hillsee]

hiya, just posted a message today.

Problem, ive got a work database which employees logon to and enter time against certain projects they have been working on. What i need is to somehow create some code that will look at each of the employees names and sum up there total time for the previous day. If this is less than say 6 hours of timesheets or even zero entries have been made, I want a pop up message to pop up as soon as they logon to the datatbase the next day and jsut mention they need to fill in there timesheets.

At the moment each person when they log on to the database has there name they logged in as, placed into a field (called "First Name") within form (called "Employee Startup Screen"). *** maybe use this as a way to identify who is logged on and when to run the code.***

Timesheet table has the following columns:
Employee; Date; ProjectID; Timespent

PLEASE help im a noob at this and have tried using some code on a query that sums up the previous days times filter on a employee. When the "Employee Startup Screen" opens it runs the following code

Dim internal1 As Integer

internal1 = Me.SumOfTimeSpent

If internal1 < 6 Then

MsgBox " Less than 6 hours have been entered " & Chr(13) & " into your timesheet for yesterday. ", vbCritical, Title1

ElseIf DCount("*", Me.SumOfTimeSpent) <> 0 Then

end if

End Sub

----------------------------


BUT it doesnt work if no entries have been made on the timesheet as the query result is blank.

ANY help would be muchly appreciated.

Thanks Keith

 

[Len Boorman]

Hmmm

What if I do not fill in for two days, get pop up saying "do yesterday's you dingbat". So I do

Hmmm day before yesterday still outstanding

Suggest a slight rethink

calendar link to timesheet table

1) Days with no entries
2) Days with less than 6 hours (or whatever) total booked.

Overtime ?

you could then possibly have these as sub forms on the main entry form with a button on each sub to close them

Basically they are the first thing a user sees and hopefully they will take notice. If a user is fully up to date they will of course be blank.

Got experience of timesheets myself.

get a big stick !!!

L

 

[boblarson]

Plus, what about weekends?

 

[Len Boorman]

Bank Holidays
Barmizahs (apologies for spelling)
Maternity leave
Paternity Leave

heck its a nightmare

L

 

[hillsee]

heheh thanx guys

thanx guys, i know this could get really complicated, specially with hols and stuff. but to be honest its not for whipping the employees into submission. its just a form of reminder for peeps to fill it in. The office is run quite efficiently and most peeps do fill time in. this is only to make aware if u happen to forget in the hustle and bustle of business.

Also everyone logs into the database everyday, and stays there for the whole day, therefore the reminder would only pop up the once per day, and if the employees have filled in it there timesheets it wont popup and nag them.

If they dont fill in 2 days b4 then so be it, as I saids its just a reminder and not a means of whipping the employees to work.