Search results

Null values Ancient One - thanks for the reply but alas is doesn't work. When I typed the code in it auto expanded to the following : Like IIf([Forms]![Search]![Width] Is Not Null,[Forms]![Search]![Width],([1Labels].[Width]) Like "*" And Not ([1Labels].[Width]) Is Null) Where...

Finding nulls as well as everything "*" I've had a look at the solution above but unfortunately it doesn't answer a question I've come across in my database. I'm using forms with unbound text boxes to act as criteria sources for select queries. The criteria I've been using in the select query...

Hi Jon, I'm open to any suggestion. (Access related that is!) I did come up with a solution to folk getting into design view but it is a little clunky. I've set up the group permissions so that they do not have access to design view on any form. The permissions also stop them from messing up...

Menu bar and close box removal Laurat, I'm using Access 97 and I initially found I could not get rid of the default 'menu bar'. But then I followed the instructions and made my own toolbar. I set it's properties to 'menu bar' and ticklisted it on. I left the application and then came back into...

Thanks! Jon, Thanks for the info - success. I had to make the bar type a 'menu' rather than 'toolbar' but once that was done I could turn them both off. Great, now I can go on holiday without sweating that somebody will get past the front end. Thanks again, Scott :)

Hello all, I'm in a similar position as Russi in that I'm trying to get rid of the Close X box on the menu bar when I maximise all my front end forms. I've been reading this thread and followed mission2java_78's advice : "create your own Custom bar which is very simple to do...