NotInList Event-Event Procedures

[Reggie]

I have a combo box on a form that provides a drop down list of city names. I
am currently unable to add new names to the list. I need to be able to add
new city names as I find them. The Access "Help" topic on how to build an
"event procedure" is confusing to this novice. The Help menu gives the
following as the appropriate Event Procedure I need. Can someone tell me
what I need to plug in. I think I have two of the three items correct but
would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As Integer)

My control name would be: Combo 74 (Name that appears on top of the combo
box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Sandra Daigle]

Hi Reggie,

NewData is the text that the user has typed into the combo which does not
match an entry in the combo's rowsource (In other words it is the value you
are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm

 

[Reggie]

Well, I guess I am confused. I thought the event procedure I described below
did the job. The help menu did not mention additional language stated in the
MVP article you referred me to.

Hi Reggie,

NewData is the text that the user has typed into the combo which does not
match an entry in the combo's rowsource (In other words it is the value you
are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have a combo box on a form that provides a drop down list of city
names. I am currently unable to add new names to the list. I need to be
able to add new city names as I find them. The Access "Help" topic on how
to build an "event procedure" is confusing to this novice. The Help menu
gives the following as the appropriate Event Procedure I need. Can
someone tell me what I need to plug in. I think I have two of the three
items correct but would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As Integer)

My control name would be: Combo 74 (Name that appears on top of the combo
box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Sandra Daigle]

I was afraid that that might be part of the problem. Since you didn't say
which version of Access you are using I just took a wild guess that it may
be one of the later versions. The help on this topic is a bit weak.

Post back if you need more help after using the referenced article.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Well, I guess I am confused. I thought the event procedure I described
below did the job. The help menu did not mention additional language
stated in the MVP article you referred me to.

Hi Reggie,

NewData is the text that the user has typed into the combo which does not
match an entry in the combo's rowsource (In other words it is the value
you are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have a combo box on a form that provides a drop down list of city
names. I am currently unable to add new names to the list. I need to be
able to add new city names as I find them. The Access "Help" topic on
how to build an "event procedure" is confusing to this novice. The Help
menu gives the following as the appropriate Event Procedure I need. Can
someone tell me what I need to plug in. I think I have two of the three
items correct but would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As Integer)

My control name would be: Combo 74 (Name that appears on top of the
combo box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Sandra Daigle]

FWIW, I just checked and the help on this topic in A2003 seems much
improved.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I was afraid that that might be part of the problem. Since you didn't say
which version of Access you are using I just took a wild guess that it may
be one of the later versions. The help on this topic is a bit weak.

Post back if you need more help after using the referenced article.

Well, I guess I am confused. I thought the event procedure I described
below did the job. The help menu did not mention additional language
stated in the MVP article you referred me to.

Hi Reggie,

NewData is the text that the user has typed into the combo which does
not match an entry in the combo's rowsource (In other words it is the
value you are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Reggie wrote:
I have a combo box on a form that provides a drop down list of city
names. I am currently unable to add new names to the list. I need to be
able to add new city names as I find them. The Access "Help" topic on
how to build an "event procedure" is confusing to this novice. The Help
menu gives the following as the appropriate Event Procedure I need. Can
someone tell me what I need to plug in. I think I have two of the three
items correct but would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As
Integer)

My control name would be: Combo 74 (Name that appears on top of the
combo box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Reggie]

I have Access 2000. I typed in the language per the MVP article but got an
error. Am I supposed to substitute anything? It had problems with the very
first line and the second too.

rr

FWIW, I just checked and the help on this topic in A2003 seems much
improved.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I was afraid that that might be part of the problem. Since you didn't say
which version of Access you are using I just took a wild guess that it may
be one of the later versions. The help on this topic is a bit weak.

Post back if you need more help after using the referenced article.

Well, I guess I am confused. I thought the event procedure I described
below did the job. The help menu did not mention additional language
stated in the MVP article you referred me to.


Hi Reggie,

NewData is the text that the user has typed into the combo which does
not match an entry in the combo's rowsource (In other words it is the
value you are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Reggie wrote:
I have a combo box on a form that provides a drop down list of city
names. I am currently unable to add new names to the list. I need to be
able to add new city names as I find them. The Access "Help" topic on
how to build an "event procedure" is confusing to this novice. The Help
menu gives the following as the appropriate Event Procedure I need. Can
someone tell me what I need to plug in. I think I have two of the three
items correct but would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As
Integer)

My control name would be: Combo 74 (Name that appears on top of the
combo box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Sandra Daigle]

Hi Reggie,

Check your references, chances are that you're missing the reference to the
DAO Library. Open the module in the Visual Basic Editor (VBE) then click
Tools->References. Make sure that the Microsoft DAO 3.x Object Library is
checked. You might also want to check this article details and info on how
to fix the problem:

http://www.mvps.org/access/bugs/bugs0031.htm

Note that whenever you are posting about issues with code it is very
important to include *your* code in the post along with the error number and
description and the line that is causing the problem. It is very difficult
to help when we don't know exactly what you have - it's a bit like taking
pot shots in the dark

In this case the missing DAO references are a pretty common problem so if
I'm right, it was an educated pot shot ;-)

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have Access 2000. I typed in the language per the MVP article but
got an error. Am I supposed to substitute anything? It had problems
with the very first line and the second too.

rr

FWIW, I just checked and the help on this topic in A2003 seems much
improved.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I was afraid that that might be part of the problem. Since you
didn't say which version of Access you are using I just took a wild
guess that it may be one of the later versions. The help on this
topic is a bit weak.

Post back if you need more help after using the referenced article.


Reggie wrote:
Well, I guess I am confused. I thought the event procedure I
described below did the job. The help menu did not mention
additional language stated in the MVP article you referred me to.


Hi Reggie,

NewData is the text that the user has typed into the combo which
does not match an entry in the combo's rowsource (In other words
it is the value you are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

Reggie wrote:
I have a combo box on a form that provides a drop down list of
city names. I am currently unable to add new names to the list.
I need to be able to add new city names as I find them. The
Access "Help" topic on how to build an "event procedure" is
confusing to this novice. The Help menu gives the following as
the appropriate Event Procedure I need. Can someone tell me what
I need to plug in. I think I have two of the three items correct
but would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As
Integer)

My control name would be: Combo 74 (Name that appears on top of
the combo box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Reggie]

Well Sandra, I guess this is it. I know less than nothing about VBA.All I
want to do is get my data base working so I can get on with my project. Are
you aware of an online tutorial that can teach me enough so that I can
understand how to get these event procedures working? Microsoft sure has
made work out of it. It kind of like having to take a course in
refrigeration just because you to keep your beer cold in the fridge. Do I
sound frustrated?

Thanks

Hi Reggie,

Check your references, chances are that you're missing the reference to the
DAO Library. Open the module in the Visual Basic Editor (VBE) then click
Tools->References. Make sure that the Microsoft DAO 3.x Object Library is
checked. You might also want to check this article details and info on how
to fix the problem:

http://www.mvps.org/access/bugs/bugs0031.htm

Note that whenever you are posting about issues with code it is very
important to include *your* code in the post along with the error number and
description and the line that is causing the problem. It is very difficult
to help when we don't know exactly what you have - it's a bit like taking
pot shots in the dark

In this case the missing DAO references are a pretty common problem so if
I'm right, it was an educated pot shot ;-)

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have Access 2000. I typed in the language per the MVP article but
got an error. Am I supposed to substitute anything? It had problems
with the very first line and the second too.

rr

FWIW, I just checked and the help on this topic in A2003 seems much
improved.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Sandra Daigle wrote:
I was afraid that that might be part of the problem. Since you
didn't say which version of Access you are using I just took a wild
guess that it may be one of the later versions. The help on this
topic is a bit weak.

Post back if you need more help after using the referenced article.


Reggie wrote:
Well, I guess I am confused. I thought the event procedure I
described below did the job. The help menu did not mention
additional language stated in the MVP article you referred me to.


Hi Reggie,

NewData is the text that the user has typed into the combo which
does not match an entry in the combo's rowsource (In other words
it is the value you are trying to add to the list).

Here's a link to an article that might also be helpful:

http://www.mvps.org/access/forms/frm0015.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.

Reggie wrote:
I have a combo box on a form that provides a drop down list of
city names. I am currently unable to add new names to the list.
I need to be able to add new city names as I find them. The
Access "Help" topic on how to build an "event procedure" is
confusing to this novice. The Help menu gives the following as
the appropriate Event Procedure I need. Can someone tell me what
I need to plug in. I think I have two of the three items correct
but would like an answer before I go on.

Private Sub controlname_NotInList(NewData As Sting, Response As
Integer)

My control name would be: Combo 74 (Name that appears on top of
the combo box properties box.
NewData is what?
Response would be:acDataErrAdded

Thanks.

 

[Sandra Daigle]

Hi Reggie,

I'm sorry that you are frustrated and believe me, I can understand.
Unfortunately many people are mislead into believing that Access will solve
all their database problems without requiring any experience or knowledge of
the product. It will solve most of your database problems but you do need to
have some knowledge of the product first.

So, I take it that correcting the references didn't solve your problem. If
you want to persue this particular issue further just let me know and I'll
try to help you if you want to tell me where you are with it.

Regarding tutorials, start by looking here:

http://www.mvps.org/access/

On this page is a nice list of resources:
http://www.mvps.org/access/resources/othersites.htm#English

And even more links:
http://www.mvps.org/links.html#Access

And a couple more:

 

[Sandra Daigle]

Hit send too soon - here are a couple more:

http://www.fgcu.edu/support/office2000/access/
http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

For more just Google on "Access Tutorial" - there are tons of them!

 

[Reggie]

Thanks. The SFU.Ca site looks promising. I will check it out.

Reggie

Hit send too soon - here are a couple more:

http://www.fgcu.edu/support/office2000/access/
http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

For more just Google on "Access Tutorial" - there are tons of them!


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Hi Reggie,

I'm sorry that you are frustrated and believe me, I can understand.
Unfortunately many people are mislead into believing that Access will
solve all their database problems without requiring any experience or
knowledge of the product. It will solve most of your database problems
but you do need to have some knowledge of the product first.

So, I take it that correcting the references didn't solve your problem. If
you want to persue this particular issue further just let me know and I'll
try to help you if you want to tell me where you are with it.

Regarding tutorials, start by looking here:

http://www.mvps.org/access/

On this page is a nice list of resources:
http://www.mvps.org/access/resources/othersites.htm#English

And even more links:
http://www.mvps.org/links.html#Access

And a couple more: