Hi All
Can anybody pls help me out with this problem.
I have a combo box control which has about 10,000 values in it. These
values in the combo box are called from a different table.
When i use a value(1 out of 10000) in the combo box for a particular
record say Record1, this value should no longer be displayed for the
next new record say Record2 and the combo box should just display only
9999 values. I am trying to do this, just because I do not want the
data entry person to use the same combo value for two different
records.
Is it possible to do this using SQL code?
Any help in this regard will be highly appreciated.
Thanks in advance.
Anita 3 1719
On 7 Oct 2004 04:21:38 -0700, ta*******@yahoo .com (anita) wrote:
10,000 is way too much for a good user experience. Find a way to
reduce that.
To answer your question: use a rowsource like:
select TheValue from TheSource where TheValue not in (select TheValue
from TheMainTable)
-Tom. Hi All
Can anybody pls help me out with this problem. I have a combo box control which has about 10,000 values in it. These values in the combo box are called from a different table. When i use a value(1 out of 10000) in the combo box for a particular record say Record1, this value should no longer be displayed for the next new record say Record2 and the combo box should just display only 9999 values. I am trying to do this, just because I do not want the data entry person to use the same combo value for two different records. Is it possible to do this using SQL code? Any help in this regard will be highly appreciated.
Thanks in advance.
Anita
anita wrote: Hi All
Can anybody pls help me out with this problem. I have a combo box control which has about 10,000 values in it.
WOW! 10,000 rows in a combo? Needing to requery to combo each time you
go to a new record? And you only want to exclude the last record entry?
Interesting.
If you are using an autonumber, I guess you can get the last entry made
when the form is first opened. Then create would own SQL rowsource and
use a line like
Me.ComboRowSour ce = strSQL
Then store the comboid for each time you are in a new record. Each time
a new record is created, create the SQL string to exclude the ID from
the variable. Each time the record is saved...in the BeforeUpdate
event, check to see if the record is new and if so, store the value of
the combo to the variable.
10,000 rows? Too much.
These values in the combo box are called from a different table. When i use a value(1 out of 10000) in the combo box for a particular record say Record1, this value should no longer be displayed for the next new record say Record2 and the combo box should just display only 9999 values. I am trying to do this, just because I do not want the data entry person to use the same combo value for two different records. Is it possible to do this using SQL code? Any help in this regard will be highly appreciated.
Thanks in advance.
Anita
This sounds like a case where using two "linked" listboxes may work - where
you select an item in the left listbox, and it moves the item to the right
listbox, eliminating it from the left listbox.
Roger Carlson created a good example of this. http://www.rogersaccesslibrary.com/
Darryl Kerkeslager
"anita" <ta*******@yaho o.com> wrote in message
news:6e******** *************** ***@posting.goo gle.com... Hi All
Can anybody pls help me out with this problem. I have a combo box control which has about 10,000 values in it. These values in the combo box are called from a different table. When i use a value(1 out of 10000) in the combo box for a particular record say Record1, this value should no longer be displayed for the next new record say Record2 and the combo box should just display only 9999 values. I am trying to do this, just because I do not want the data entry person to use the same combo value for two different records. Is it possible to do this using SQL code? Any help in this regard will be highly appreciated.
Thanks in advance.
Anita This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Nimmi Srivastav |
last post by:
There's a rather nondescript book called "Using Borland C++" by Lee
and Mark Atkinson (Que Corporation) which presents an excellent
discussion of overloaded new and delete operators. In fact there are
quite a few things that I learned that I did not know before. For
example, while I knew that the new and delete operators can be
overloaded for classes, I did not know that that the global new and
delete operators can also be overloaded. ...
|
by: Bernd Smits |
last post by:
Hi,
I would like to delete a record (with commandbutton) of a table associated
to a combobox, when I select a certain value in the combobox (the value I
select is associated with the record that I want to delete.
For example:
I have a form associated to a table, which has only one field (PatientN°),
and a combobox (within the form) that contains the list of values
(PatientN°) contained in the table. Now I would like to select a value in...
|
by: Bernd Smits |
last post by:
but now everytime I click on the "delete"
button, near a combobox, the selected record (of the combobox) will be
removed from the table but in the
combobox, in place of the the selected value (to delete) there is written
#Canceled or #Eliminated but only when I reboot the form #Eliminated and the
value are canceled.
Why does this happen? I would that when I click on the button automaticly
the value in the combobox is canceled, without the...
|
by: Zlatko Matiæ |
last post by:
There is a form (single form) and a combobox. I want that current record of
the form is adjusted according to selected value in the combobox. Cuurrent
record should be the same as the value in the combobox.
What is the solution?
Thank you in advance.
|
by: Susan Bricker |
last post by:
I have a command button on a form that is supposed to Delete the record
being displayed. The record is displayed one to a form. The form is
not a Pop-Up nor is it Modal. Tracing the btnDelete event routine shows
that AllowDeletions is TRUE.
When the Delete button is clicked (without TRACE ON), I get a 'beep',
the recordselector (vertical bar on left of form) gets dark in color,
but the record is not deleted. Also, there is no error...
| |
by: (PeteCresswell) |
last post by:
I've got apps where you *really* wouldn't want to delete certain items by
accident, but the users just have to have a "Delete" button.
My current strategies:
Plan A:
------------------------------------------------------------------------
1) Make the cmd button black and do not give it an accelerator key.
2) Issue two levels of confirmation (Do you want to delete... Do you REALLY want
|
by: Franky |
last post by:
I have a usercontrol that inherits from ComboBox
I'd like to add the feature that the user can delete any item
Best would be that he could right click an element and a messagebox would
ask if he wanted to delete that element
I can't find an event that would enable me to do that.
I could copy the items into a text box, let him edit it and put them back
|
by: Greg (codepug |
last post by:
I have a combobox with the RowSourceType set to Table/Query and the
RowSource is an SQL query that references a separate lookup table that
contains the data that can be selected in the combobox. Also,
limittolist & autoexpand are set to Yes. Control source is set to the
main table field where the data will go.
I can highlight the data that was previously selected in the combobox,
and press the delete key to remove it, but after I move...
|
by: dudeja.rajat |
last post by:
On Sat, Aug 30, 2008 at 2:32 PM, Fredrik Lundh <fredrik@pythonware.comwrote:
Fredrik, Thanks so much. That worked.
Following this, I can now see that my combo2 has no previous elements
and contains only the elements relevant to selection in combo1.
Now, as soon as I select something in combo 2 and go back to change
selection in combo1 the combo2 must get its history cleared up (i.e
the previous selection in combo2's entry subwidget)
|
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,...
|
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...
| |
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...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |