I have a combo box on a form that I want the content to be read only. If any
changes it should be done in the table. How can I accomplish this task? I
tried to set the locked property to true, it didn't work.
8  1820 
"Kissi Asiedu" <ki*******@aol. comwrote in message
news:2N******** ***********@fe1 8.usenetserver. com...
>I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this task?
I tried to set the locked property to true, it didn't work.
Set Locked to True and Enabled to False.
Stuart McCall wrote:
"Kissi Asiedu" <ki*******@aol. comwrote in message
news:2N******** ***********@fe1 8.usenetserver. com...
>>I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this task?
I tried to set the locked property to true, it didn't work.
Set Locked to True and Enabled to False.
That certainly will stop all changes on the combobox, to the point
there'd be no dropdown. But if I set a combobox locked status to Yes,
Enabled = Yes, even in verson A97, I can get the dropdown and scroll
thru the rosw I can't change the value.
I think Kissi's doing something wrong.
No Doctoring http://www.youtube.com/watch?v=Ch4tSwP2_4M
"Salad" <oi*@vinegar.co mwrote in message
news:13******** *****@corp.supe rnews.com...
Stuart McCall wrote:
>"Kissi Asiedu" <ki*******@aol. comwrote in message
news:2N******* ************@fe 18.usenetserver .com...
>>>I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this
task? I tried to set the locked property to true, it didn't work.
Set Locked to True and Enabled to False.
That certainly will stop all changes on the combobox, to the point there'd
be no dropdown. But if I set a combobox locked status to Yes, Enabled =
Yes, even in verson A97, I can get the dropdown and scroll thru the rosw I
can't change the value.
I think Kissi's doing something wrong.
No Doctoring
http://www.youtube.com/watch?v=Ch4tSwP2_4M
I think you're right. Sometimes I answer far too quick. But heck I enjoyed
the youtube clip, so some good came of it :)
"Stuart McCall" <sm*****@myunre albox.comwrote in message
news:fl******** ***********@new s.demon.co.uk.. .
"Kissi Asiedu" <ki*******@aol. comwrote in message
news:2N******** ***********@fe1 8.usenetserver. com...
>>I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this
task? I tried to set the locked property to true, it didn't work.
Set Locked to True and Enabled to False.
Sorry Kissi. Please ignore that last post. As Salad says, it'll only make
matters worse. Locked = True certainly ought to do the trick.
Perhaps you need to be more specific. How are you setting the locked
property? In code? In a macro? In the property sheet in design view?
When you say it didn't work, what behaviour did you observe and what did you
expect to happen?
On Dec 29, 11:41 am, "Kissi Asiedu" <kissi5...@aol. comwrote:
I have a combo box on a form that I want the content to be read only. If any
changes it should be done in the table. How can I accomplish this task? I
tried to set the locked property to true, it didn't work.
You could try that again.
Stuart McCall a écrit :
"Stuart McCall" <sm*****@myunre albox.comwrote in message
news:fl******** ***********@new s.demon.co.uk.. .
>"Kissi Asiedu" <ki*******@aol. comwrote in message
news:2N******* ************@fe 18.usenetserver .com...
>>I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this
task? I tried to set the locked property to true, it didn't work.
Set Locked to True and Enabled to False.
Sorry Kissi. Please ignore that last post. As Salad says, it'll only make
matters worse. Locked = True certainly ought to do the trick.
Perhaps you need to be more specific. How are you setting the locked
property? In code? In a macro? In the property sheet in design view?
When you say it didn't work, what behaviour did you observe and what did you
expect to happen?
Please excuse my bad English.
I believe he wants something like "limit to the list" (in French :
limiter à liste).
--
p-reine
On Sat, 29 Dec 2007 11:41:33 -0500, Kissi Asiedu wrote:
I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this
task? I tried to set the locked property to true, it didn't work.
If you don't want someone to add to the list from the combo box, only
select from the list, then set the 'Limit to List' property of the combo
box to 'True.'
Thanks everyone, setting the Limit to List worked well for me.
"Don Calloway" <dr********@ver izon.netwrote in message
news:b7Ddj.490$ jX4.488@trnddc0 7...
On Sat, 29 Dec 2007 11:41:33 -0500, Kissi Asiedu wrote:
>I have a combo box on a form that I want the content to be read only. If
any changes it should be done in the table. How can I accomplish this
task? I tried to set the locked property to true, it didn't work.
If you don't want someone to add to the list from the combo box, only
select from the list, then set the 'Limit to List' property of the combo
box to 'True.'
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: SoftWhiteDelgiht |
last post by:
Help me. I am obviously stupid! :-)
I am just starting out with VB.Net and am trying to do a simple master/detail form with a SqlServer backend.
I have created a combo box which is to populate with 'STATUS_DESC' from the STATUS table.
This works perfectly.
Now I want to populate the form with a row from the Purchase Order table
POHEADER and expect the combo box to get the 'STATUS_DESC' by looking up the STATUS table with POHEADER.STATUS_ID....
|
by: hmiller |
last post by:
Hey everyone,
I am having a hell of a time trying to set this menu system up. Here's
what I'm trying to do.
Combo Box One; is populated by names under properties "row source"
"Phase 1" through "Phase 10" (there are 10 Phases I want to sort from)
Once the phase has been selected a second combo box would populate.
|
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the second combo to
change depending on what values the user selects in the first box, it's
just that every time the user changes the first combobox, the second
combobox FOR EVERY RECORD goes blank.
|
by: jjyconsulting |
last post by:
Newbie needing some help. I have a tblParticipants. The fields
include gender, education_level, income, occupation etc., I'm trying to
create a form where a user can run a query from the form and just
choose the appropriate criterias from the combo boxes to get the
results. I also want the query to run even if there is not a value in
all the combo boxes ie., i want just all males with income level of
over $100,000...Any insights or help...
|
by: Ausclad |
last post by:
Ok, ill try again.....
It seems fairly simple.
I have two combo boxes in a datagrid. The datagrid is bound to a a table in
a dataset.
The two combo boxes are bound to a single data table in a different dataset.
One combo box is displaying the Employees payroll ID. The other is
| | |
by: sparks |
last post by:
I have a combo box that when you go to the next combo box it is
filtered based on the value in the previous one.
so if combo box 1 has fred as its value then combo box 2 has
1 2 3 for values.
this works fine the first time thru.
but later if I change combo box 1 combo box 2 list is still displaying
the list form the previous value in combo box 1.
|
by: jafarsibtain |
last post by:
hi..
I am creating a form where there are two combo Boxes (drop Down)
> Program_Combo_box
> Course_Code_Combo
in the Program Combo Box there are five items in the list >
1. BIT
2.BCA
3. MCA
|
by: Sid |
last post by:
I need some help in setting up Access combo box.
I am using three comboboxes in my form. Comb Box 1, Combo Box 2, Combo
Box 3. The row source for each of the combo box is a seperate table.
Table 1 acts as row source for Combo Box 1
Table 2 acts as row source for Combo Box 2
However for combobox 3, I was trying to use 4 different tables as row
source. I am trying to set up a criteria such that row source for comb
|
by: Dave |
last post by:
I wasn't sure how to search for previous posts about this, it felt
real specific. Ok so here's the database & problem:
I have 4 combo boxes: cboServer, cboPolicy, cboDB, and
cboApplication. The idea behind the database is for a user to search/
select desired information in any kind of combination between the 4
combo boxes. Then the user clicks a button (btnSearch) and
subsequently a query ("Search Function") is run that shows all 4...
|
by: =?Utf-8?B?amVmZmVyeQ==?= |
last post by:
i need help with a combo box and this same code works on my first tab with a
combo box. The error or problem i have is this code causes an index out of
range error when i run it on my second combo box:
(errored code) Select Case ComboBox2.text
Case Is ="Execute Program"
'code to execute program here
Case Is ="Other Command that executes code at a certain time"
' code below the same as above except that it works
But not my first(this...
|
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...
| | |
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
