Hi and TIA! I have a bound combobox with rowsource set to value list, limit
to list=true and NotInList procedure to add(or not) a value the user types
in. This works fine and it does add the value to the combo and the value
added is available the whole time the form is open, however, when I close
the form that newly added value wasn't added to the RowSource of the combo
box. My questions is, is it possible to change the Rowsource value, during
runtime, so that should I open the form in design and view the rowsource the
new value is there. I know this could lead to bogus info as my row source,
but the customer asked, I tried, and have yet to come up with a solution.
Thanks for your time.
--
Reggie
----------
6  3920 
On Thu, 15 Jul 2004 01:29:54 -0700, "Reggie"
<No**********@NoSpamsmittysinet.com> wrote:
The obvious: store the data in a table, and set the RowSourceType to
Table/Query.
-Tom. Hi and TIA! I have a bound combobox with rowsource set to value list, limit
to list=true and NotInList procedure to add(or not) a value the user types
in. This works fine and it does add the value to the combo and the value
added is available the whole time the form is open, however, when I close
the form that newly added value wasn't added to the RowSource of the combo
box. My questions is, is it possible to change the Rowsource value, during
runtime, so that should I open the form in design and view the rowsource the
new value is there. I know this could lead to bogus info as my row source,
but the customer asked, I tried, and have yet to come up with a solution.
Thanks for your time.
--
Tom, thanks for your time. That is "The Obvious" and simplest, however, my
question is, is it possible to change the combo box value list at runtime.
I'm with you and explained this to my customer, but they want me to try it
this way if possible. I've tried many ways without success and was just
checking to see if it was even possible. Thanks again!
Reggie
----------
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:g2********************************@4ax.com... On Thu, 15 Jul 2004 01:29:54 -0700, "Reggie"
<No**********@NoSpamsmittysinet.com> wrote:
The obvious: store the data in a table, and set the RowSourceType to
Table/Query.
-Tom.
Hi and TIA! I have a bound combobox with rowsource set to value list,
limitto list=true and NotInList procedure to add(or not) a value the user
typesin. This works fine and it does add the value to the combo and the value
added is available the whole time the form is open, however, when I close
the form that newly added value wasn't added to the RowSource of the
combobox. My questions is, is it possible to change the Rowsource value,
duringruntime, so that should I open the form in design and view the rowsource
thenew value is there. I know this could lead to bogus info as my row
source,but the customer asked, I tried, and have yet to come up with a solution.
Thanks for your time.
No, to permanently change the list you have to change it with the form in
design view. It can be done through code with the form opened in design view
if you wish. If you are going to need to change the list, use a table to
store the values.
--
Wayne Morgan
Microsoft Access MVP
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:L-********************@comcast.com...
--
Tom, thanks for your time. That is "The Obvious" and simplest, however,
my
question is, is it possible to change the combo box value list at runtime.
I'm with you and explained this to my customer, but they want me to try it
this way if possible. I've tried many ways without success and was just
checking to see if it was even possible. Thanks again!
Reggie
----------
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:g2********************************@4ax.com... On Thu, 15 Jul 2004 01:29:54 -0700, "Reggie"
<No**********@NoSpamsmittysinet.com> wrote:
The obvious: store the data in a table, and set the RowSourceType to
Table/Query.
-Tom.
>Hi and TIA! I have a bound combobox with rowsource set to value list, limit >to list=true and NotInList procedure to add(or not) a value the user types >in. This works fine and it does add the value to the combo and the
>value
>added is available the whole time the form is open, however, when I
>close
>the form that newly added value wasn't added to the RowSource of the combo >box. My questions is, is it possible to change the Rowsource value, during >runtime, so that should I open the form in design and view the rowsource the >new value is there. I know this could lead to bogus info as my row source, >but the customer asked, I tried, and have yet to come up with a
>solution.
>Thanks for your time.
Wayne/Tom, Thanks for you replies. Didn't think it was possible, but never
hurts to ask. Thanks again!
--
Reggie
----------
"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:%t*****************@newssvr17.news.prodigy.co m... No, to permanently change the list you have to change it with the form in
design view. It can be done through code with the form opened in design
view if you wish. If you are going to need to change the list, use a table to
store the values.
--
Wayne Morgan
Microsoft Access MVP
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:L-********************@comcast.com...
--
Tom, thanks for your time. That is "The Obvious" and simplest, however,
my
question is, is it possible to change the combo box value list at
runtime. I'm with you and explained this to my customer, but they want me to try
it this way if possible. I've tried many ways without success and was just
checking to see if it was even possible. Thanks again!
Reggie
----------
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:g2********************************@4ax.com... On Thu, 15 Jul 2004 01:29:54 -0700, "Reggie"
<No**********@NoSpamsmittysinet.com> wrote:
The obvious: store the data in a table, and set the RowSourceType to
Table/Query.
-Tom.
>Hi and TIA! I have a bound combobox with rowsource set to value list,
limit >to list=true and NotInList procedure to add(or not) a value the user
types >in. This works fine and it does add the value to the combo and the
>value
>added is available the whole time the form is open, however, when I
>close
>the form that newly added value wasn't added to the RowSource of the
combo >box. My questions is, is it possible to change the Rowsource value,
during >runtime, so that should I open the form in design and view the
rowsource the >new value is there. I know this could lead to bogus info as my row
source, >but the customer asked, I tried, and have yet to come up with a
>solution.
>Thanks for your time.
I was only just reading some info on this
try going to www.utteraccess.com/links/ and go to the link
Access 97 Expert solutions and there is some info in chapter 13 i think
might help
John
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:Tq********************@comcast.com... Wayne/Tom, Thanks for you replies. Didn't think it was possible, but
never hurts to ask. Thanks again!
--
Reggie
----------
"Wayne Morgan" <co***************************@hotmail.com> wrote in
message news:%t*****************@newssvr17.news.prodigy.co m... No, to permanently change the list you have to change it with the form
in design view. It can be done through code with the form opened in design view if you wish. If you are going to need to change the list, use a table to
store the values.
--
Wayne Morgan
Microsoft Access MVP
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:L-********************@comcast.com...
--
Tom, thanks for your time. That is "The Obvious" and simplest,
however, my
question is, is it possible to change the combo box value list at
runtime. I'm with you and explained this to my customer, but they want me to
try it this way if possible. I've tried many ways without success and was
just checking to see if it was even possible. Thanks again!
Reggie
----------
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:g2********************************@4ax.com...
> On Thu, 15 Jul 2004 01:29:54 -0700, "Reggie"
> <No**********@NoSpamsmittysinet.com> wrote:
>
> The obvious: store the data in a table, and set the RowSourceType to
> Table/Query.
>
> -Tom.
>
>
> >Hi and TIA! I have a bound combobox with rowsource set to value
list, limit
> >to list=true and NotInList procedure to add(or not) a value the user
types
> >in. This works fine and it does add the value to the combo and the
> >value
> >added is available the whole time the form is open, however, when I
> >close
> >the form that newly added value wasn't added to the RowSource of the
combo
> >box. My questions is, is it possible to change the Rowsource value,
during
> >runtime, so that should I open the form in design and view the
rowsource the
> >new value is there. I know this could lead to bogus info as my row
source,
> >but the customer asked, I tried, and have yet to come up with a
> >solution.
> >Thanks for your time.
>
John, Thanks! I wasn't aware of this site. Some awesome info available!
--
Reggie
----------
"John M" <jo*****@bigpond.com> wrote in message
news:fU***************@news-server.bigpond.net.au... I was only just reading some info on this
try going to www.utteraccess.com/links/ and go to the link
Access 97 Expert solutions and there is some info in chapter 13 i think
might help
John
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:Tq********************@comcast.com... Wayne/Tom, Thanks for you replies. Didn't think it was possible, but
never hurts to ask. Thanks again!
--
Reggie
----------
"Wayne Morgan" <co***************************@hotmail.com> wrote in
message news:%t*****************@newssvr17.news.prodigy.co m... No, to permanently change the list you have to change it with the form in design view. It can be done through code with the form opened in
design view if you wish. If you are going to need to change the list, use a table
to store the values.
--
Wayne Morgan
Microsoft Access MVP
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:L-********************@comcast.com...
>
>
> --
> Tom, thanks for your time. That is "The Obvious" and simplest,
however, > my
> question is, is it possible to change the combo box value list at
runtime. > I'm with you and explained this to my customer, but they want me to try it > this way if possible. I've tried many ways without success and was
just > checking to see if it was even possible. Thanks again!
>
> Reggie
>
> ----------
> "Tom van Stiphout" <no*************@cox.net> wrote in message
> news:g2********************************@4ax.com...
>> On Thu, 15 Jul 2004 01:29:54 -0700, "Reggie"
>> <No**********@NoSpamsmittysinet.com> wrote:
>>
>> The obvious: store the data in a table, and set the RowSourceType
to >> Table/Query.
>>
>> -Tom.
>>
>>
>> >Hi and TIA! I have a bound combobox with rowsource set to value list, > limit
>> >to list=true and NotInList procedure to add(or not) a value the
user > types
>> >in. This works fine and it does add the value to the combo and
the >> >value
>> >added is available the whole time the form is open, however, when
I >> >close
>> >the form that newly added value wasn't added to the RowSource of
the > combo
>> >box. My questions is, is it possible to change the Rowsource
value, > during
>> >runtime, so that should I open the form in design and view the
rowsource > the
>> >new value is there. I know this could lead to bogus info as my
row > source,
>> >but the customer asked, I tried, and have yet to come up with a
>> >solution.
>> >Thanks for your time.
>>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Duncan Spence |
last post by:
Hi all,
I'm sure I'm doing something silly here, but can't see it!
I'm creating a series of combo boxes on a Windows Form in VB.NET.
The lists of all of the comboboxes are identical and are...
|
by: Shannan Casteel via AccessMonster.com |
last post by:
I set up two tables (one with the regular claim
info and another with ClaimNumber, PartNumber, and QuantityReplaced). The
ClaimNumber is an autonumber and the primary key in both tables. I made a...
|
by: Gav |
last post by:
I am using VS 2005 and am trying to add items to a combo box using C#. I
know how to add simple text items but I am trying to add a value and some
text ie.
Value Text
A First Text
B ...
|
by: Craig G |
last post by:
i use the following to populate a combo in a datagrid but was wondering how
i would add a blank entry to the top of the combo so that on first load it
has no value selected?
<asp:DropDownList...
|
by: Aaron Ackerman |
last post by:
I have a bound combobox the appears on a cell within the column of my bound
grid when the user clicks on a cell n(In my vb.net WinForm app).
I am trying to allow the adding of an item to that bound...
|
by: stinehelferw |
last post by:
I need a right-click menu on a form list control with combobox
controls.
I used View->Toolbars->Customize to create a toolbar.
I added ComboBox through commands tab.
I set properties to Popup...
|
by: The Eclectic Electric |
last post by:
I'd be very grateful if anyone could help me with this. From my limited
knowledge of Javascript I don't think it is possible, but I'll punt anyway.
I downloaded and very slightly adapted this...
|
by: mysore |
last post by:
I am using VB6.0
I have two combo boxes , namely combo1 and combo2.
For E.g, I say Combo1.AddItem Combo1.Text to add a new item to the list during run time. In the drop down I do see the new item...
|
by: Mr Gray |
last post by:
HI guys,
I am developing a winform and need to update the contents of a combo box at runtime. I currently click a button that brings up a new dialog and click save. I then return to the parent...
|
by: AccessBeetle |
last post by:
I am using this "append2table" function from Allen Browne to add an item to the combobox that is not already in the list.
Here is the function, with my fields and table names
Function...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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...
|
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...
| |
