Search results

Yes!!! :D brilliant, thanks alot :D

Oh, it's just an updated query for a yes/no field - not that important.

:) Sorry, but I did say I was terrible at this. Thanks alot for your help. Right, I fixed all those things you said so I'll try and explain what I'm trying to do: "qryFineAmount" is an update query which updates the field "FineAmount", however this field isn't in the form itself. So if the...

Hello, I'm terrible at VBA, but here's my problem (it's probably very simple): I have a field, and if it is not empty I want a report to open. This is what I have - DoCmd.SetWarnings False DoCmd.OpenQuery "qryAvailableYes", acNormal, acEdit DoCmd.OpenQuery "qryFineAmount"...

Ahhh got you - thanks.

Thanks for the reply, but I don't completely understand. Do you mean that tblBook should be linked to tblBookCopy which should then be linked to tblLoan? And should tblBookCopy just have like the quantity of books or something? (I had a quantity field it tblBook before but I deleted it for...

Hello, I'm trying to set up a database for a library but I'm having a lot of difficulties and I'd be very greatful of any help. Well my main problem is the loaning and returning of books (which is a pretty big problem considering...). Anyway I can't figure out a way of having multiple orders...