473,287 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Problem with AutoExpand - Still Need Help

Hi - I sent this request last week, but didn't get an answer to my problem -
let's try again:

In my A2K database, I have a form with 2 Unbound Comboboxes, both of which
open up forms to a particular record. One of these comboboxes works
perfectly. For some reason the 2nd one WILL NOT autofill. If I enter a
number to lookup by typing it in, it ALWAYS says it's not in the list (Error
2237) - but if I select the item, it works fine. I only have 1 field in this
combobox - the SampleID. It is set up with the following Properties:

LimitToList=YES
Auto Expand=YES
Column Count=1
Bound Column=1
Row Source Type=Table/Query
Row Source=SELECT DISTINCT [tblSamples].[SampleID] FROM tblSamples ORDER BY
[tblSamples].[SampleID];

(I have also tried with multiple fields, but the bound column was always 1).

I have tried the following:
1) removing the combobox and putting on a fresh one, running repair, making
an entire 2nd form from scratch, etc.
2) making the NOT IN LIST property=NO, which will allow me to enter an
item - but if it's not a valid SampleID, I get an error msg when it tries to
open it up (and it doesn't auto expand).
3) Coding "cboSampleRef.Autoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....scrolling wouldn't work.
Is there some unwritten rule that you can only have ONE of this type of
combobox per form? Am I missing some obvious step? (I do these all the
time....)

Someone, PLEEEEEEZ, have a solution ......

Thanks!

Andi Plotsky

--
Andi Plotsky
IRIS, LLC
2859 Galahad Drive
Atlanta, GA 30345

404-321-9459 (office)
404-636-2331 (fax)
ir******@bellsouth.net
Nov 13 '05 #1
6 1779
Is [SampleID] a text or number field type? If it's a number, have you set a
format and/or input property on the combo-box that matches that set on the
table field?
-Ed

"Andi Plotsky" <ir******@bellsouth.net> wrote in message
news:vT******************@bignews6.bellsouth.net.. .
Hi - I sent this request last week, but didn't get an answer to my
problem -
let's try again:

In my A2K database, I have a form with 2 Unbound Comboboxes, both of
which
open up forms to a particular record. One of these comboboxes works
perfectly. For some reason the 2nd one WILL NOT autofill. If I enter a
number to lookup by typing it in, it ALWAYS says it's not in the list
(Error
2237) - but if I select the item, it works fine. I only have 1 field in
this
combobox - the SampleID. It is set up with the following Properties:

LimitToList=YES
Auto Expand=YES
Column Count=1
Bound Column=1
Row Source Type=Table/Query
Row Source=SELECT DISTINCT [tblSamples].[SampleID] FROM tblSamples ORDER
BY
[tblSamples].[SampleID];

(I have also tried with multiple fields, but the bound column was always
1).

I have tried the following:
1) removing the combobox and putting on a fresh one, running repair,
making
an entire 2nd form from scratch, etc.
2) making the NOT IN LIST property=NO, which will allow me to enter an
item - but if it's not a valid SampleID, I get an error msg when it tries
to
open it up (and it doesn't auto expand).
3) Coding "cboSampleRef.Autoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....scrolling wouldn't work.
Is there some unwritten rule that you can only have ONE of this type of
combobox per form? Am I missing some obvious step? (I do these all the
time....)

Someone, PLEEEEEEZ, have a solution ......

Thanks!

Andi Plotsky

--
Andi Plotsky
IRIS, LLC
2859 Galahad Drive
Atlanta, GA 30345

404-321-9459 (office)
404-636-2331 (fax)
ir******@bellsouth.net

Nov 13 '05 #2
SampleID was set as a Long Integer. I didn't have anything in the Format
Property; the Decimal Places property was set to Auto. I tried changing it
to General Number and 0, respectively....but it didn't make a difference.

I should note that SampleID is not the Primary Key in the table - will that
matter?

Thanks for the suggestion, anyway....

Andi

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:fF*****************@monger.newsread.com...
Is [SampleID] a text or number field type? If it's a number, have you set a format and/or input property on the combo-box that matches that set on the
table field?
-Ed

"Andi Plotsky" <ir******@bellsouth.net> wrote in message
news:vT******************@bignews6.bellsouth.net.. .
Hi - I sent this request last week, but didn't get an answer to my
problem -
let's try again:

In my A2K database, I have a form with 2 Unbound Comboboxes, both of
which
open up forms to a particular record. One of these comboboxes works
perfectly. For some reason the 2nd one WILL NOT autofill. If I enter a
number to lookup by typing it in, it ALWAYS says it's not in the list
(Error
2237) - but if I select the item, it works fine. I only have 1 field in
this
combobox - the SampleID. It is set up with the following Properties:

LimitToList=YES
Auto Expand=YES
Column Count=1
Bound Column=1
Row Source Type=Table/Query
Row Source=SELECT DISTINCT [tblSamples].[SampleID] FROM tblSamples ORDER
BY
[tblSamples].[SampleID];

(I have also tried with multiple fields, but the bound column was always
1).

I have tried the following:
1) removing the combobox and putting on a fresh one, running repair,
making
an entire 2nd form from scratch, etc.
2) making the NOT IN LIST property=NO, which will allow me to enter an
item - but if it's not a valid SampleID, I get an error msg when it tries to
open it up (and it doesn't auto expand).
3) Coding "cboSampleRef.Autoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....scrolling wouldn't work.
Is there some unwritten rule that you can only have ONE of this type of
combobox per form? Am I missing some obvious step? (I do these all the
time....)

Someone, PLEEEEEEZ, have a solution ......

Thanks!

Andi Plotsky

--
Andi Plotsky
IRIS, LLC
2859 Galahad Drive
Atlanta, GA 30345

404-321-9459 (office)
404-636-2331 (fax)
ir******@bellsouth.net


Nov 13 '05 #3
Andi Plotsky wrote:
Hi - I sent this request last week, but didn't get an answer to my problem -
let's try again:

In my A2K database, I have a form with 2 Unbound Comboboxes, both of which
open up forms to a particular record. One of these comboboxes works
perfectly. For some reason the 2nd one WILL NOT autofill. If I enter a
number to lookup by typing it in, it ALWAYS says it's not in the list (Error
2237) - but if I select the item, it works fine. I only have 1 field in this
combobox - the SampleID. It is set up with the following Properties:

LimitToList=YES
Auto Expand=YES
Column Count=1
Bound Column=1
Row Source Type=Table/Query
Row Source=SELECT DISTINCT [tblSamples].[SampleID] FROM tblSamples ORDER BY
[tblSamples].[SampleID];

(I have also tried with multiple fields, but the bound column was always 1).

I have tried the following:
1) removing the combobox and putting on a fresh one, running repair, making
an entire 2nd form from scratch, etc.
2) making the NOT IN LIST property=NO, which will allow me to enter an
item - but if it's not a valid SampleID, I get an error msg when it tries to
open it up (and it doesn't auto expand).
3) Coding "cboSampleRef.Autoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....scrolling wouldn't work.
Is there some unwritten rule that you can only have ONE of this type of
combobox per form? Am I missing some obvious step? (I do these all the
time....)

Someone, PLEEEEEEZ, have a solution ......

Thanks!

Andi Plotsky

--
Andi Plotsky
IRIS, LLC
2859 Galahad Drive
Atlanta, GA 30345

404-321-9459 (office)
404-636-2331 (fax)
ir******@bellsouth.net


Here are a few tests to try:

Does the second combobox work when the first one is removed?

Does a second combobox that is exactly like the first one except for
the name work when both are present?

Can you execute a query that uses an inner join on SampleID from
tblSamples and another table containing SampleID?

James A. Fortune

CNN/Money best places to live:
http://money.cnn.com/best/bplive/top100_1.html

Nov 13 '05 #4
In answer to your questions:
Here are a few tests to try:

Does the second combobox work when the first one is removed? NO

Does a second combobox that is exactly like the first one except for
the name work when both are present? YES

Can you execute a query that uses an inner join on SampleID from
tblSamples and another table containing SampleID? YES, the following query works fine -
(SELECT tblSamples.SampleID, tblSamplesMissing.SampleID
FROM tblSamplesMissing INNER JOIN tblSamples ON tblSamplesMissing.SampleID =
tblSamples.SampleID
WITH OWNERACCESS OPTION;)
- what does this tell me?

Andi

<ji********@compumarc.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com... Andi Plotsky wrote:
Hi - I sent this request last week, but didn't get an answer to my problem - let's try again:

In my A2K database, I have a form with 2 Unbound Comboboxes, both of which open up forms to a particular record. One of these comboboxes works
perfectly. For some reason the 2nd one WILL NOT autofill. If I enter a
number to lookup by typing it in, it ALWAYS says it's not in the list (Error 2237) - but if I select the item, it works fine. I only have 1 field in this combobox - the SampleID. It is set up with the following Properties:

LimitToList=YES
Auto Expand=YES
Column Count=1
Bound Column=1
Row Source Type=Table/Query
Row Source=SELECT DISTINCT [tblSamples].[SampleID] FROM tblSamples ORDER BY [tblSamples].[SampleID];

(I have also tried with multiple fields, but the bound column was always 1).
I have tried the following:
1) removing the combobox and putting on a fresh one, running repair, making an entire 2nd form from scratch, etc.
2) making the NOT IN LIST property=NO, which will allow me to enter an
item - but if it's not a valid SampleID, I get an error msg when it tries to open it up (and it doesn't auto expand).
3) Coding "cboSampleRef.Autoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....scrolling wouldn't work.
Is there some unwritten rule that you can only have ONE of this type of
combobox per form? Am I missing some obvious step? (I do these all the
time....)

Someone, PLEEEEEEZ, have a solution ......

Thanks!

Andi Plotsky

--
Andi Plotsky
IRIS, LLC
2859 Galahad Drive
Atlanta, GA 30345

404-321-9459 (office)
404-636-2331 (fax)
ir******@bellsouth.net


Here are a few tests to try:

Does the second combobox work when the first one is removed?

Does a second combobox that is exactly like the first one except for
the name work when both are present?

Can you execute a query that uses an inner join on SampleID from
tblSamples and another table containing SampleID?

James A. Fortune

CNN/Money best places to live:
http://money.cnn.com/best/bplive/top100_1.html

Nov 13 '05 #5
Andi Plotsky wrote:
In answer to your questions:
Here are a few tests to try:

Does the second combobox work when the first one is removed? NO

Does a second combobox that is exactly like the first one except for
the name work when both are present? YES

Can you execute a query that uses an inner join on SampleID from
tblSamples and another table containing SampleID? YES, the following

query works fine -
(SELECT tblSamples.SampleID, tblSamplesMissing.SampleID
FROM tblSamplesMissing INNER JOIN tblSamples ON tblSamplesMissing.SampleID =
tblSamples.SampleID
WITH OWNERACCESS OPTION;)
- what does this tell me?

Andi


The first two tests show that an unwritten rule is not causing the
problem and that the unwritten rule doesn't even exist. The inner join
was a way of finding out if the SampleID in tblSamples can be equated
by SQL to the SampleID in the other tables to test for weirdness in
tblSamples. Something weird happening in the data could cause Access
to think that the value is not in the list since the typed value would
not match the weird value but the value in the dropdown would. Make
sure tblSamplesMissing was not created from tblSamples. That would
defeat the purpose of the test for weirdness. The SQL in your
RowSource looks O.K. except that I don't think you need the ORDER BY
with SELECT DISTINCT. Are you using the latest service packs for A2K?
Can the error be duplicated when the database is copied to a different
machine? Does it occur after converting the database to A97 or A2K2 or
A2K3? I can also send you a valid email address if you'd like to send
me a sample with just the essentials required to get the error so that
I can try to duplicate the error.

James A. Fortune

Nov 13 '05 #6
Hi, Jim -

I opened it up in another database, on another computer, and in A2K2. The
problem persists. I don't have Access97, so I couldn't do that one. I just
recently upgraded my Access2000 SP for Windows2000 on one of my computers.
Tried opening up the database on the un-upgraded one, but the problem is
there.

I would like to send you a mini-base so you can see if anything pops up that
you notice. There are two files - the form and the back-end data
(DataTablesR.mdb).

I should say that this combobox DID work at one point in time. I have tried
replacing it with another, but to no avail.

Let me know where to send the datafiles to.

Thanks!

Andi Plotsky
ir******@bellsouth.net
404-321-9459

<ji********@compumarc.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Andi Plotsky wrote:
In answer to your questions:
Here are a few tests to try:

Does the second combobox work when the first one is removed? NO

Does a second combobox that is exactly like the first one except for
the name work when both are present? YES

Can you execute a query that uses an inner join on SampleID from
tblSamples and another table containing SampleID? YES, the following

query works fine -
(SELECT tblSamples.SampleID, tblSamplesMissing.SampleID
FROM tblSamplesMissing INNER JOIN tblSamples ON tblSamplesMissing.SampleID = tblSamples.SampleID
WITH OWNERACCESS OPTION;)
- what does this tell me?

Andi


The first two tests show that an unwritten rule is not causing the
problem and that the unwritten rule doesn't even exist. The inner join
was a way of finding out if the SampleID in tblSamples can be equated
by SQL to the SampleID in the other tables to test for weirdness in
tblSamples. Something weird happening in the data could cause Access
to think that the value is not in the list since the typed value would
not match the weird value but the value in the dropdown would. Make
sure tblSamplesMissing was not created from tblSamples. That would
defeat the purpose of the test for weirdness. The SQL in your
RowSource looks O.K. except that I don't think you need the ORDER BY
with SELECT DISTINCT. Are you using the latest service packs for A2K?
Can the error be duplicated when the database is copied to a different
machine? Does it occur after converting the database to A97 or A2K2 or
A2K3? I can also send you a valid email address if you'd like to send
me a sample with just the essentials required to get the error so that
I can try to duplicate the error.

James A. Fortune

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Kostatus | last post by:
I have a virtual function in a base class, which is then overwritten by a function of the same name in a publically derived class. When I call the function using a pointer to the derived class...
16
by: cody | last post by:
I have to write an algorithm with must ensure that objects are put in buckets (which are always 4 in size). The objects have two properties: A and B. It is not allowed that in a bucket are objects...
2
by: David Savageau | last post by:
Can anyone help with the following problem? The solution will likely be elementary to many members of this newsgroup, but, Duh! I've been struggling to find it all day. On an Access 2000 form...
2
by: DBQueen | last post by:
Hi - In my A2K database, I have a form with 2 Unbound Comboboxes, both of which open up forms to a particular record. One of these comboboxes works perfectly. For some reason the 2nd one WILL...
4
by: VK | last post by:
I'm looking for autoexpand <select> list onfocus and collapse it back onselect/onblur (the list is select-one type) I know it is not possible directly, but I've seen here a hack by changing...
1
by: pemigh | last post by:
In a prior posting (too old to reply directly), Jim Devenish described exactly what my client has seen, both in terms of AutoExpand behaving oddly and the way that caps lock relates to the...
9
by: AceKnocks | last post by:
I am working on a framework design problem in which I have to design a C++ based framework capable of solving three puzzles for now but actually it should work with a general puzzle of any kind and I...
0
by: Ture Bergstrøm | last post by:
In my database (Access2003 SP3) I have a combo box, which has a query as row source. This query gets its values from a table with the fields id and field1. Field1 is shown in the box, the key...
1
by: tbeers | last post by:
Quick questions Is there a way to create an autoexpand property in a text or memo field? Thanks Tomb
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.