Llimit Listbox from Textbox dynamically

#11

On Oct 21, 4:04*pm, JackonLI wrote:

Quote:

I have seen your name here over the years and I have to believe that
you are an expert in Access. *Unfortunately this seems to have given
you an arrogance that I really do not understand. *

There is nothing listed in this group or its name that indicates it is
for professionals only. *And just because you don't see a "need" to do
something one way, as opposed to another, does not mean it is wrong.

Access is a hobby for me. *I enjoy creating databases. * Mostly for my
own use, and some for friends. * I sometimes spend hours trying to get
something to work. *Most of the time I succeed. *When I am totally
stumped, since I don't have a "Manager" to ask, I look for help on the
internet, and the Newsgroups.

If you have trouble with this, don't respond to my posts.

Have a great day. *;-)

On Thu, 20 Oct 2011 20:12:52 -0600, "Access Developer"

accde... (AT) gmail (DOT) com> wrote:
You are welcome.

The only reason I can imagine for going to the extra effort to duplicate
functionality that is built-in to one of the Access controls would be ifit
were a school assignment, and we are not here to do homework for students.
But surely you aren't a student wanting your homework done.

Good luck, and when you get it done, good luck in your manager not having
found out in the meanwhile that all your effort was unnecessary.

Larry Linson, Microsoft Office Access MVP

JackonLI> wrote in message
news:ja6v97lkguks6leblintogoo28pqok1j48 (AT) 4ax (DOT) com...
Thanks for the reply. * Unfortunately I was looking for a way to do
what I mentioned, not what your opinion is of doing it.

On Mon, 17 Oct 2011 22:47:15 -0600, "Access Developer"
accde... (AT) gmail (DOT) com> wrote:

The functionality you describe can be implemented using VBA code with a
List
Box, but it is built-in to the Combo Box control, and I've always thought
it
a tremendous waste to re-implement functionality that is included in the
product right out-of-the-box.

Larry Linson, Microsoft Office Access MVP
"Microsoft Access Small Business Solutions", pub by Wiley, 2010
Access Newsgroup: alive and well in comp.databases.ms-access

JackonLI> wrote in message
news

g9p97tupi03dckcsc99c9l3a6jb50u14c (AT) 4ax (DOT) com...
I have a form used to enter items. *On the form I have a list box with
items already entered listed, and a few text boxes to enter new items
and info about them. *I am trying to filter the list box as I typenew
items. into a text box. *Each letter entered would filter the listbox
as it is entered.
Example
Enter a and all items starting with a are shown in list box
Enter b and all items starting with ab are shown, etc.

If the Item I'm looking for is not found, ENTER adds what I have typed
into the list.

If it is found I would cancel the entry.

Is this possible?

Thanks for any help.

JackonLI

Are you known as "Petulant Baby" at work?

#12

On Sat, 22 Oct 2011 11:17:00 -0700 (PDT), Patrick Finucane
<patrickfinucanetx (AT) gmail (DOT) com> wrote:

Quote:

On Oct 21, 4:04*pm, JackonLI wrote:
I have seen your name here over the years and I have to believe that
you are an expert in Access. *Unfortunately this seems to have given
you an arrogance that I really do not understand. *

There is nothing listed in this group or its name that indicates it is
for professionals only. *And just because you don't see a "need" to do
something one way, as opposed to another, does not mean it is wrong.

Access is a hobby for me. *I enjoy creating databases. * Mostly for my
own use, and some for friends. * I sometimes spend hours trying to get
something to work. *Most of the time I succeed. *When I am totally
stumped, since I don't have a "Manager" to ask, I look for help on the
internet, and the Newsgroups.

If you have trouble with this, don't respond to my posts.

Have a great day. *;-)

On Thu, 20 Oct 2011 20:12:52 -0600, "Access Developer"

accde... (AT) gmail (DOT) com> wrote:
You are welcome.

The only reason I can imagine for going to the extra effort to duplicate
functionality that is built-in to one of the Access controls would be if it
were a school assignment, and we are not here to do homework for students.
But surely you aren't a student wanting your homework done.

Good luck, and when you get it done, good luck in your manager not having
found out in the meanwhile that all your effort was unnecessary.

Larry Linson, Microsoft Office Access MVP

JackonLI> wrote in message
news:ja6v97lkguks6leblintogoo28pqok1j48 (AT) 4ax (DOT) com...
Thanks for the reply. * Unfortunately I was looking for a way to do
what I mentioned, not what your opinion is of doing it.

On Mon, 17 Oct 2011 22:47:15 -0600, "Access Developer"
accde... (AT) gmail (DOT) com> wrote:

The functionality you describe can be implemented using VBA code with a
List
Box, but it is built-in to the Combo Box control, and I've always thought
it
a tremendous waste to re-implement functionality that is included in the
product right out-of-the-box.

Larry Linson, Microsoft Office Access MVP
"Microsoft Access Small Business Solutions", pub by Wiley, 2010
Access Newsgroup: alive and well in comp.databases.ms-access

JackonLI> wrote in message
news

g9p97tupi03dckcsc99c9l3a6jb50u14c (AT) 4ax (DOT) com...
I have a form used to enter items. *On the form I have a list box with
items already entered listed, and a few text boxes to enter new items
and info about them. *I am trying to filter the list box as I type new
items. into a text box. *Each letter entered would filter the listbox
as it is entered.
Example
Enter a and all items starting with a are shown in list box
Enter b and all items starting with ab are shown, etc.

If the Item I'm looking for is not found, ENTER adds what I have typed
into the list.

If it is found I would cancel the entry.

Is this possible?

Thanks for any help.

JackonLI

Are you known as "Petulant Baby" at work?

Not sure if this is directed at me but I will assume it is.

All I did was post a request to find out if something can be done in
Access.

What I got was arrogant assumptions about who and what I am.

I have never worked or taken any classes on Access. I have "played"
with it for a long time and enjoy trying to figure out how to do
things. I search the internet for help and post here as a last
resort.

Why anyone would waste there time posting an attack on someone asking
a question is beyond me.

I have been using this group for years. I have asked the lamest
questions and gotten responses on how to occomplish what I wanted to
do, or that it could not be done, and sometimes no response at all.

The response I recieved to my post was immature, arrogant and useless.
Basically "It can be done, but I can't think of any reason someone
would want to so I am not going to answer. But I will try to make you
feel stupid for asking. What an ASS!

I have never seen anything proclaiming that this group is for
Professionals only. If it is then change the name.

#13

<JackonLI> wrote

Quote:

Basically "It can be done, but I can't
think of any reason someone
would want to so I am not going to answer.

Jackon, I do not provide answers to help people do something the wrong way
(a way that will cause them problems in the future), when there is a simple,
easy, correct way.

Quote:

But I will try to make you
feel stupid for asking. What an ASS!

I am quite certain I did not say that. However, FYI, out of consideration
for your personal feelings, I have set a message rule to mark your posts --
now, in my newsreader, they stand out to remind me that you do not wish to
have me answer your technical questions, henceforth.

Larry Linson

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Llimit Listbox from Textbox dynamically

comp.databases.ms-access comp.databases.ms-access

Re: Llimit Listbox from Textbox dynamically - 10-22-2011 , 01:17 PM

Re: Llimit Listbox from Textbox dynamically - 10-31-2011 , 05:06 PM

Re: Llimit Listbox from Textbox dynamically - 11-01-2011 , 02:19 PM