If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
navigating to different records in a read only form
When you have a read-only form, (one whose "Allow Edits" property is set to
"No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Thanks in advance, Paul |
#2
|
|||
|
|||
navigating to different records in a read only form
Paul wrote:
When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
navigating to different records in a read only form
Paul,
Put an Unbound Combo Box on the form, this will not lock so all users can use it as a look-up box but the ones that can edit will have no difficultly. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marshall Barton" wrote in message ... Paul wrote: When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
navigating to different records in a read only form
Gina:
An unbound combo box will still lock if AllowEdits is set to False. Marshall's answer is actually correct. -- Thanks, Bob Larson Access MVP Free Access Tutorials and Resources: http://www.btabdevelopment.com "Gina Whipp" wrote in message ... Paul, Put an Unbound Combo Box on the form, this will not lock so all users can use it as a look-up box but the ones that can edit will have no difficultly. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marshall Barton" wrote in message ... Paul wrote: When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
navigating to different records in a read only form
"Marshall Barton" wrote in message
... Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. I've always done it the way Marsh suggests, but recently it occurs to me -- probably suggested by someone else -- that it might be simpler to just set AllowEdits = True in the combo box's Enter event and set AllowEdits = False in the combo's Exit event. I haven't tried this in any practical application, but it works in a quick test, and might be handier if the form is only going to be read-only for some users, not all. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#6
|
|||
|
|||
navigating to different records in a read only form
Bob,
Not on my forms... And I just tested that theory. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bob Larson" wrote in message ... Gina: An unbound combo box will still lock if AllowEdits is set to False. Marshall's answer is actually correct. -- Thanks, Bob Larson Access MVP Free Access Tutorials and Resources: http://www.btabdevelopment.com "Gina Whipp" wrote in message ... Paul, Put an Unbound Combo Box on the form, this will not lock so all users can use it as a look-up box but the ones that can edit will have no difficultly. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marshall Barton" wrote in message ... Paul wrote: When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#7
|
|||
|
|||
MISTAKE: navigating to different records in a read only form
Bob,
MY MISTAKE... I just checked and the form it worked on has the code behind the form that keeps my unbound controld from locking no matter what the Allow Edits says. SORRY! I forogt I put that there, I must have run into this problem and found a work around. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bob Larson" wrote in message ... Gina: An unbound combo box will still lock if AllowEdits is set to False. Marshall's answer is actually correct. -- Thanks, Bob Larson Access MVP Free Access Tutorials and Resources: http://www.btabdevelopment.com "Gina Whipp" wrote in message ... Paul, Put an Unbound Combo Box on the form, this will not lock so all users can use it as a look-up box but the ones that can edit will have no difficultly. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marshall Barton" wrote in message ... Paul wrote: When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#8
|
|||
|
|||
MISTAKE: navigating to different records in a read only form
I must have run into this problem and found a work around.
share? tia, tina "Gina Whipp" wrote in message ... Bob, MY MISTAKE... I just checked and the form it worked on has the code behind the form that keeps my unbound controld from locking no matter what the Allow Edits says. SORRY! I forogt I put that there, I must have run into this problem and found a work around. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bob Larson" wrote in message ... Gina: An unbound combo box will still lock if AllowEdits is set to False. Marshall's answer is actually correct. -- Thanks, Bob Larson Access MVP Free Access Tutorials and Resources: http://www.btabdevelopment.com "Gina Whipp" wrote in message ... Paul, Put an Unbound Combo Box on the form, this will not lock so all users can use it as a look-up box but the ones that can edit will have no difficultly. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marshall Barton" wrote in message ... Paul wrote: When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#9
|
|||
|
|||
MISTAKE: navigating to different records in a read only form
Tina,
I guess that was kind of rude, slapping myself in the back of my head... I used the Tag property of the bound controls to lock the controls based on the User's SecurityID. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "tina" wrote in message ... I must have run into this problem and found a work around. share? tia, tina "Gina Whipp" wrote in message ... Bob, MY MISTAKE... I just checked and the form it worked on has the code behind the form that keeps my unbound controld from locking no matter what the Allow Edits says. SORRY! I forogt I put that there, I must have run into this problem and found a work around. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bob Larson" wrote in message ... Gina: An unbound combo box will still lock if AllowEdits is set to False. Marshall's answer is actually correct. -- Thanks, Bob Larson Access MVP Free Access Tutorials and Resources: http://www.btabdevelopment.com "Gina Whipp" wrote in message ... Paul, Put an Unbound Combo Box on the form, this will not lock so all users can use it as a look-up box but the ones that can edit will have no difficultly. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Marshall Barton" wrote in message ... Paul wrote: When you have a read-only form, (one whose "Allow Edits" property is set to "No"), how do you get a record selection combo box to work in that form? I have a form that uses a record selection combo box to select different records. For some of my users, I have VBA set Allow Edits to "Yes," and for others, "No." But when it's set to "No," the record selection combo box won't work. How do you navigate to different records when you have a read only form, if the combo box won't work? Instead of using AllowEdits, set the Locked property of all controls except the combo box. This can easily be done by holding down the Shift key and clicking on each of the bound controls. -- Marsh MVP [MS Access] |
#10
|
|||
|
|||
MISTAKE: navigating to different records in a read only form
Gina,
Can you tell me what VBA code you're using to keep the unbound control from locking regardless of the value of the AllowEdits property? My experience is that even if the Locked property of the Combo box is set to "No," it will not select a new record in the form if AllowEdits is set to yes. Thanks Paul |
Thread Tools | |
Display Modes | |
|
|