Search results

My guess would be that your code won't compile. Try to compile it and see if it shows some faults

Ebs solution works. See attached file

I don't know what you can do. Have you tried to attach a video file/

Have you tried creating a new db and importing the relevant form, query and table. Delete all records in the new db and then create a couple of fictitious records. Compact, zip and post the file.

From post #12 Can you be more specific

I would be surprised if you could apply conditional formatting to a field at the table level, after all, tables are for storing data, not for viewing.

Hi Rocky. Welcome to the forum :)

Try Is Not Null

Can't you share it with us? :(

In plain words, can you explain what criteria you want to apply?

Good. Always glad to help if I can ;)

In that case, I would use the following expressions as calculated fields in the query: startOfDay: DateValue(Now()) endOfDay: DateAdd("s",-1,DateAdd("d",1,[startOfDay]))

Where do you want to use it? In a query, you could use each line as an expression to create a calculated field for each value. On a form, you could use: = GetCurrentDayDates()(0) and = GetCurrentDayDates()(1) as the Control Source properties of two unbound textboxes.

Welcome to the forum :). Yes, the curve is steep but there are many knowledgeable and helpful members.

Are using Tabbed Documents rather than Overlapping Windows?

Not sure why that would happen. Have you tried Docmd.Restore it in forms open event

Welcome to the forum :)

Then why would you need to know which are missing. They should have no meaning to a user.

Are the ID's of "Auto-Number" type

You may find some of the posts in the following link to be of some help/interest: https://www.accessforums.net/showthread.php?t=82044