Search results

I notice that you are using "Lookups" in your tables which can lead to problems. See: http://access.mvps.org/access/lookupfields.htm

Perhaps you could use a query to calculate the count of weekdays. Something like: SELECT Count(YourTableName.FieldNameToCount) AS NumOfWDays FROM YourTableName WHERE (((YourTableName.YourDateFieldName) Between [Start Date] And Date()) AND ((Weekday([YourDateFieldName]))<>1 And...

You could add a "LeavingDate" date field to one of your tables.

What's that all about?

Cross-Posted: https://www.accessforums.net/showthread.php?t=88649 Please read: https://excelguru.ca/a-message-to-forum-cross-posters/

Search YouTube for videos on: "access table relationships". There are lots of them. Here's one I found:

I would advise against the use of Lookup fields in tables. See: http://access.mvps.org/access/lookupfields.htm

Glad you have it working :D

Not sure that "MUST" is quite right. I thought that expressions without them would still work if the field name had NO spaces in it. I would agree that they are advisable though.

If you post a copy of the db one of us may be able to find the problem. The last code that I posted worked when I tested it.

Can you post a copy of the db with just a couple of fictitious records.

Then perhaps: Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & " (Student)", BillingFirstname & " " & BillingLastname & " (Billing)")

Try: Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & ", '" & (Student) & "'", BillingFirstname & " " & BillingLastname & ", '" & (Billing) & "'")

Try: MsgBox ("Wrong Password.", vbInformation + vbOkOnly, "Operation Cancelled")

Glad you have a solution. Always pleased to help if I can :)

Perhaps: TotalQty: Nz([Day1Qty],0)+Nz([Day2Qty],0)+Nz([Day3Qty],0)+Nz([Day4Qty],0)+Nz([Day5Qty],0)+Nz([Day6Qty],0)+Nz([Day7Qty],0)

Take a look at the "similar threads" section below

What is the value of Me.Filter when the code runs

Try: DoCmd.OpenReport "myreport", acViewReport, "", Me.Filter, acNormal

Perhaps you could set the sub form as Not enabled. Then put your validation code in the Main forms Before Update event and in the Main forms On Current event