Search results

If you look at the backend db you posted, you will see that none of the tables has a PK. Anyway, since you have marked the thread as solved it's a moot point.

As far as I can see, none of your tables have a Primary Key and you have no relationships defined

You could zip it and then post the zip file

I see nothing attached to your post

You could do, but you've already posted everything (forms, queries and modules) from the frontend db

Create a new db, then import the tables from the backend db that your frontend db is linked to.

Your posted db uses LINKED tables but there's no tables in the db file

I thought you might have spoilt us and included the tables

Can you post a copy of the db

I don't think my original suggestion gave the desired results when the time was 03:00 am Don't understand why you are making comments on the use of Now() function. I haven't used it:unsure:

I've looked at this again. The following works for me: =IIf(Hour([BusinessDatetime])*60+Minute([BusinessDatetime])<=180,[BusinessDatetime],[BusinessDatetime]+1)

Try: =IIf(Hour([BusinessDatetime])<=3,DateValue([BusinessDatetime])+1,DateValue([BusinessDatetime])) as the Control Source of [businessday]

Can you post a copy of your db

Welcome to the forum :)

Welcome to the forum :)

Perhaps you need to change from Tabbed Documents to Overlapping Windows. See this short video...

Well quite!! but if you simply count the number of days in the period of leave, that's what happens;)

Also, keep in mind that you would need something other than Access for the backend if the network is not a wired network.

<Phuduhutswana> When entering and calculating leave taken, will your app need to differentiate between the employee's usual working days and those that are not usual working days? i.e. if an employee usually works Mon - Fri (5 days) and goes on leave for one week, will you calculate that as 5...

Oh, George. I admire your eloquence.