A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

navigating to different records in a read only form



 
 
Thread Tools Display Modes
  #1  
Old January 29th, 2009, 11:40 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Paul
external usenet poster
 
Posts: 126
Default 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  
Old January 30th, 2009, 01:22 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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  
Old January 30th, 2009, 01:30 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old January 30th, 2009, 03:35 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Bob Larson
external usenet poster
 
Posts: 89
Default 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  
Old January 30th, 2009, 03:58 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default 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  
Old January 30th, 2009, 05:13 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old January 30th, 2009, 05:56 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old January 31st, 2009, 05:17 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
tina
external usenet poster
 
Posts: 1,997
Default 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  
Old January 31st, 2009, 05:25 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old January 31st, 2009, 05:30 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Paul
external usenet poster
 
Posts: 68
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.