Search results

Forgive me if I've misunderstood you, but when you create/edit a relationship in the relationship window, you are presented with a dialog box that allows you to set referential integrity.

Not sure about graphics or Active X labels but for native Access controls you can set the "ControlTip Text" property of the control using the Other tab of the property sheet.

Have you tried: DoCmd.Close acForm, "FrmFrontEnd" DoCmd.OpenForm "FrmEmployees", acNormal

I think that the OP is a new member. Perhaps he doesn't realise how helpful it might be ;)

Perhaps try: DoCmd.OpenForm "frmFrontEnd" Also, the "acSaveNo" in the following line is not required DoCmd.Close acForm, Me.Name, acSaveNo

try stepping through the code As far as I can see "stLinkCriteria" has no value

Why not sort it by the appropriate column?

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