How do I suppress the properties box on database startup?
Thanks.
Thanks.
-
-
Re: Hiding the Properties Box
<troy_lee@comca st.netwrote in message
news:c7ff8190-6e3c-4988-9229-dce5d67b6d30@a1 g2000hsb.google groups.com...Open each form in design view, and set the:How do I suppress the properties box on database startup?
Allow Design Changes
property to No.
Save the forms. The properties box won't open when you run these forms.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
-
Re: Hiding the Properties Box
On Aug 22, 11:43 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:Thanks Allen.<troy_...@comca st.netwrote in message
>
news:c7ff8190-6e3c-4988-9229-dce5d67b6d30@a1 g2000hsb.google groups.com...
>>How do I suppress the properties box on database startup?
Open each form in design view, and set the:
Allow Design Changes
property to No.
>
Save the forms. The properties box won't open when you run these forms.
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
Just to let you know, I LOVE your website. I just used your code for
building a dynamic WHERE string to produce a custom report generator.
It absolutely rocks and our Sr. developer is blown away. He has no
idea where I get my secret powers from.
BTW, I know you did a separate listbox tutorial for generating a WHERE
statement, but it would have been great if you would have put that as
an example on the main Search Criteria tutorial. I'm about to create
another report generator incorporating a listbox along with combo
boxes. It is going to be a little daunting but after the success I had
with this last project, I have high hopes.
I also have a couple of questions on the search criteria:
I want to offer some alternatives in a combo box for use in strWhere-
things like 'Is Null', 'Is Not Null', or a combination of values. For
instance, we have three priority ratings- 1, 3 or 5. I already offer a
choice for each separate priority rating, but not for all of them
together- '1,3 and 5'. (There can be null values in this field, so it
does me little good to leave it empty.) I'm a little unsure of how to
do this.
Also, do you have any plans for making a search criteria using AND and/
or OR?
Thanks for all the great info you have on Access. You have no idea how
much your site has helped me out. I'm a big fan.
Troy Lee
Comment
-
Re: Hiding the Properties Box
Responses in-line.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<troy_lee@comca st.netreplied in message
news:2a200496-da9b-491a-a3a2-a952f728afba@d1 g2000hsg.google groups.com...Excellent. Great to know it's being put to good use. That particular example>
Just to let you know, I LOVE your website. I just used your code for
building a dynamic WHERE string to produce a custom report generator.
It absolutely rocks and our Sr. developer is blown away. He has no
idea where I get my secret powers from.
is a technique I use over and over in different contexts.
Too many new ideas in one example can lead people to just give up, so IBTW, I know you did a separate listbox tutorial for generating a WHERE
statement, but it would have been great if you would have put that as
an example on the main Search Criteria tutorial. I'm about to create
another report generator incorporating a listbox along with combo
boxes. It is going to be a little daunting but after the success I had
with this last project, I have high hopes.
think the examples are best separately. It's not hard to combine them
though: just declere 2 different string variables, so you can build up the
list box string first, and then concatenate it into the main filter string
and extra brackets and and AND on the end.
Yes, I use an unbound combo box for the operator. User selects a value, andI also have a couple of questions on the search criteria:
>
I want to offer some alternatives in a combo box for use in strWhere-
things like 'Is Null', 'Is Not Null', or a combination of values. For
instance, we have three priority ratings- 1, 3 or 5. I already offer a
choice for each separate priority rating, but not for all of them
together- '1,3 and 5'. (There can be null values in this field, so it
does me little good to leave it empty.) I'm a little unsure of how to
do this.
you use it to build the filter string the the appropriate wildcards.
For a Text field, the combo has properties like this:
Column Count: 2
Column Widths: 0
Bound Column: 1
Row Source Type: Value List
Row Source: 0;"Is";1;"Is Not";4;"Begins" ;5;"Not
Begin";6;"Conta ins";7;"Not Contain";8;"End s";9;"Not End";10;"Blank" ;11;"Not
Blank"
The code then does a Select Case on the combo's value, and builds the string
using = for 0, <for 1, Like "xx*" for 2, ... and Is Not Null for 11.
The problem here is the way to interface the bracketing, since:Also, do you have any plans for making a search criteria using AND
and/or OR?
a AND (b OR c)
is not the same as:
(a AND b) OR c
where a, b, and c are criteria expressions such as "SomeField Is Null")
As you found, the multi-select list box is one easy way to offer an OR
within a bunch of ANDs.
Great. All the best as you develop your Access understanding, and put it toThanks for all the great info you have on Access. You have no idea
how much your site has helped me out. I'm a big fan.
good use, Troy.
Comment
Comment