S. Brooks

Hello, I have a button on my library database called 'Execute Find' that runs the script: >Loop -Set Error Capture [On] -Perform Find -Exit Loop If [Get(FoundCount) > 0] -Perform Script ["BTA_Dialog Box (Nothing Found)"] >End Loop >Go to Layout ["List View"] So if nothing is entered or no entry is found during a search, a dialog box is displayed. This is all working well, but if a search is performed and the user chooses to go back to the "New Find" layout, if they click "Execute Find" without entering anything, it displays the previous search results as opposed to a dialog box. Is there anyway to stop this happeneing? Thanks ...

Thanks for your help, but is there not a way that users can simply enter 'A' and find every result beginning with 'A' instead of results that have 'A' at the start of their second word? Thanks.

Is there any way to program a search so that it only searches the first letter of each record. For example at the moment when I search for companies beginning with 'I' in my database I get 'Aggregate Industries' because of the 'I' in the second word. Is there anyway to stop this? Thanks.

Hello I have made a database for an architecture practice's library. It only has one table and you simply click on the kind of book your looking for (e.g. windows/doors/stairs) and a list of all the related books shows. So it's a series of buttons and scripts. Pretty simple. It seems to be running smoothly but have come across two things that could make it easier to use. 1. If nothing is entered in the search fields I want an error message to appear giving the options to modify their find as opposed to just showing all the results. 2. If a search returns no results I want an error message to appear giving the options to modify their find as opposed to just showing all the results again. I've dabbled with some scripts and attached them to the find button with limited success so any help anyone can give would be greatly appreciated. Thanks!

Thank you. Worked a treat. ...

I was playing around with the file/options trying to test out the privilages I had set. I chose to log in using the guest account. Now because is starts with the guest account evert time I don't have the privilages to set it back a full access account. Can anyone help? Thanks.