Read Only Form Version

B

billgyrotech

Banned
Local time
Today, 00:01
Joined
Apr 18, 2013
Messages
258
Hello,


On my Main Form (database open) click on the 'Research'.


This form is intended to be read only including the AFRs Parts tab.


On AFR Number 88942 which has Status "Open" the AFRs Parts can be edited but should not be.


Is there a way to not allow editing on this version of the AFRs Input form for the parts? I already have the AFRs Input form part to not allow editing but can't figure out how to do this for the parts.


Can someone please help?


Thanks,
Bill
 
Last edited:
Because of this line in the current event:

Me.AFRsParts1.Form.AllowEdits = Me.cmbStatus <> "Closed"

The other tab stays read only because the textboxes are locked.
 
Thanks for replying.


I have 3 other versions of the AFRs form which can be edited somewhat.


I want this version (AFRs4) to not be edited at all including the subform parts just for this version.
 
Then set the locked property of those textboxes as you have on the other tab. Or take out the code that conditionally sets the allow edits property.
 
Pbaldy,


I need to allow the edits for the subform parts on the other AFRs forms though.


Maybe there needs to be another version of the AFRsParts?


Thanks,
Bill
 
bastanu,


There is no parts subform on that version sorry. The parts need to be there for research but not allow to be edited.


There are 4 versions of the AFRs from the Main Form:


Administrative

Clerk
Technician
Research


The Research one is supposed to be allowed to view but not edit the details.


Thank you very much for helping
 
billgyrotech said:
I need to allow the edits for the subform parts on the other AFRs forms though.

Maybe there needs to be another version of the AFRsParts?
Click to expand...

I wouldn't have another copy of the form if I could avoid it. Change the code in the main form's current event so it doesn't unlock the subform when the status changes. I assume that's a leftover.
 
Pbaldy,


I commented out the code for the On Current and it works the way it should now. I was copying versions and forget to take out the code. It is hard to remember all the details.


Thanks so much for helping me.
 
billgyrotech said:
There are 4 versions of the AFRs from the Main Form:


Administrative

Clerk
Technician
Research


The Research one is supposed to be allowed to view but not edit the details.
Click to expand...

What differentiates the 4 versions? I would be more likely to have a single form and handle the different needs via code. You can pass the "mode" in OpenArgs.
 
In order to get into the Adminstrative the password is "admin"


Clerk is "clerk"
Technician is "tech"
Research has no password.


I was having so much trouble with logins so I did it this way.
 
billgyrotech said:
Pbaldy,


I commented out the code for the On Current and it works the way it should now. I was copying versions and forget to take out the code. It is hard to remember all the details.


Thanks so much for helping me.
Click to expand...

No problem. Having 4 versions of the form will be a maintenance headache. I'm lazy, I only want to make changes to one form, not four. :p
 
Did you look at the code in the open event of the subform on the version I;ve sent you:
Code: 
Private Sub Form_Open(Cancel As Integer)
If Me.Parent.Form.Name = "AFRs4" Then
Me.AllowEdits = False
End If
End Sub

Comment out the reference to it on the OnCurrentevent of the research form and it should work the way you wanted.

Cheers,
Vlad
 
I tend to agree with that for maintenance purposes but I don't possess the skills yet. Maybe one day!
 
You must log in or register to reply here.

Similar threads

J
Read Only Message
Replies
6
Views
430
Gasman
Gasman
M
Problem with AFR (Automatic Form Resizing)
Replies
8
Views
940
Marshall Brooks
M
J
Version Control for MS Access: Using the MSAccess-VCS Add-in
2
Replies
37
Views
1,889
Josef P.
J
isladogs
Mousewheel Event Bug in Version 2412
Replies
3
Views
679
isladogs
isladogs
S
Problem to run Access database
Replies
3
Views
382
mike60smart
mike60smart

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom