Thank you NeoPa :) i believe it is my query that is currently wrong.
your information has helped alot, and thank you for editing my previous post, I'm new to this website also and hadn't figured out how do the code text layout :)
dan munday
Last Activity: Feb 3 '11, 03:56 PM
Joined: Jan 30 '11
Location:
-
im sorry i dont know how to explain it properly.
no, the form is based on a table where each student's loans are not counted, its only in a query where i've counted them,
so when i click the save record button on this form, i want it to perform an 'If' that will look into this query, for a field called Loans, and if that answer is equal to 2, open up a message to stay they cant take out anymore,
but if it is less than...Leave a comment:
-
How to make an error box appear when a limit has been reached?
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... -
i wasnt linked to a table because i thought that having the link would stop the data being altered or entered.
i've now found out otherwise and have resolved the problem by creating a new form with this link,
thankyou :)Leave a comment:
-
do you know the code to make the connection from the text box to the fields in a table?
im sorry i'v not used access beforeLeave a comment:
-
How to saving Form data into an unlinked table as a new record?
hello,
right, i have a form (currently form1) and this is a data entry form where users write in details about borrowing a book, when i click a save button, i need this data to be saved into a unlinked table (called Loan) as a new record, under the correct field names, e.g. "loan date" on the form to be saved under the "loan date" heading in the table.
is there a way to do this?
thanks....
No activity results to display
Leave a comment: