473,834 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.A utoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....sc rolling 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******@bellso uth.net
Nov 13 '05 #1
6 1809
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******@bells outh.net> wrote in message
news:vT******** **********@bign ews6.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.A utoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....sc rolling 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******@bellso uth.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*********@wd n.com> wrote in message
news:fF******** *********@monge r.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******@bells outh.net> wrote in message
news:vT******** **********@bign ews6.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.A utoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....sc rolling 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******@bellso uth.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.A utoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....sc rolling 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******@bellso uth.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.Samp leID, tblSamplesMissi ng.SampleID
FROM tblSamplesMissi ng INNER JOIN tblSamples ON tblSamplesMissi ng.SampleID =
tblSamples.Samp leID
WITH OWNERACCESS OPTION;)
- what does this tell me?

Andi

<ji********@com pumarc.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.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.A utoexpand=true" in the GotFocus Event.

Eventually the list of SampleID's is going to get rather lengthy, so the
AutoExpand feature is necessary....sc rolling 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******@bellso uth.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.Samp leID, tblSamplesMissi ng.SampleID
FROM tblSamplesMissi ng INNER JOIN tblSamples ON tblSamplesMissi ng.SampleID =
tblSamples.Samp leID
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 tblSamplesMissi ng 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.md b).

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******@bellso uth.net
404-321-9459

<ji********@com pumarc.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.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.Samp leID, tblSamplesMissi ng.SampleID
FROM tblSamplesMissi ng INNER JOIN tblSamples ON tblSamplesMissi ng.SampleID = tblSamples.Samp leID
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 tblSamplesMissi ng 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
3769
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 (ClassB* b; b->func(); ) the base-class function is called instead of the new function in the derived class. All other similar functions (virtual in the base class and overwritten in the the derived class) work fine, it's just this one function. ...
16
2667
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 with the same A or B value. But there can be more than one object with A = null or B = null in the bucket. Sometimes there is only one valid solution, sometimes there are more valid solutions, and sometimes there isn't a complete solution at...
2
1422
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 I'm designing, there is a combo-box for the names of 535 Members of Congress. The Recordsource is a table. The Autoexpand property is on. When I enter the first few letters of the last name, the field fills beautifully. My problem: How can I...
2
6398
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 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...
4
2380
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 dynamically position static/absolute and sel.size - cannot google it out though. Also some GNU/copyleft widget would be equally great.
1
2696
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 situation. The problem is hard to nail down because 1) the combo box misbehaves only for certain combo box entries and 2) it won't necessarily misbehave when it's copied to another machine. I'm attempting to get Microsoft to acknowledge the problem on...
9
3666
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 need your able help in this activity. Objective - In this activity you will design a framework capable of solving any puzzle of a specific type and, as a test of this framework, use the framework to solve a very simple puzzle. In this first...
0
1418
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 column is hidden. Autoexpand and Limit to List is on. After closing of the database and reopening, autoexpand does not work any longer. After having made changes of the query forward and back again, autoexpand may work again, but only until the...
1
1843
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
9799
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9646
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10793
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10510
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10219
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9331
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7758
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5794
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4427
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.