I currently have a form, where the users enter data and loan out books.
I need some way of limiting each user to just 2 books, I have a loan count in a Query called "Bookloans" ,
when the save record button is clicked, im looking to have an "IF" in the Vba codes that refers to the specific field with the users id, and how many books they have, if this value is equal to 2, then bring up a message error box...
2 results in 0.0036 seconds.
-
How to make an error box appear when a limit has been reached?
-
Limit Fields in Query to Ascending
I have made a query with a custom field of:
LocName: ["LOCATION_D ESC] & " ~ " & [LOCATION_CODE]
How do I make the [LOCATION_CODE]; ascending? and not make the LOCATION_DESC ascending. While keeping the field the same? When I run this it doesn't know how to arrange it because there are 2 categories.
Thanks
