Search results

Hi there.. I need a simple query... I want all the records to appear which have some text in that particular field. So if there is no text in that field, it won't come up. What would I need to write under that field in the query?

Ok, I've prevented Duplicates. How do I put in a customized message saying "There already exists a Radion"?

Ok, figured it out. Lol, I should get slapped on the wrist for that!

Hi again, thanks to all for the help given so far. Is there anyway (other than making that field a primary key) to prevent the same value being entered into a different record? E.g. If under 'Name' Radion has already been written, I want an error message coming up saying there is already a...

Thanks for the suggestion. Just one more question. Is it possible that when I type in a something in a field, I can change the value of another (yes/no) field? So if the field is empty, the field will be set as Yes. And if something is typed in, it'll be set to No.

Hi all, I'm working on a library database for a small collection. I have two fields, 'Date Out' and 'Date IN'. Is it possible that whatever date is written for the date taken out, I can set the 'Date IN' to be 7 days later than that date? Thanks in advance.

Yeah, I have another (yes/no) field, to be selected once the books have been returned. Thanks for that! Much appreciated!

Hi there, I'm making a database for a small library collection. I want to make a query for all overdue books, so if the Date which the book is due has passed, it will come up in the query. What do I put beneath the 'Date due' field? So If 1 day has passed that date, it will be overdue...