Read Only Form Is not Read only

lryckman · June 11th, 2007, 12:54 PM

This is a little odd.
I have a form that I have created my "frmMainMenu" out of. Many buttons exist taking the user into different forms to input information on.
For the users who are not allowed to modify the data, I created a form "frmMainMenu_ro", I used DoCmd.OpenForm.....acFormReadOnly... for all the buttons on that menu, but two of my buttons are opening the form and allowing the user to edit the first record. Then after they scroll off the first record, it acts as read only. The code between these two buttons and all the rest that are working properly is identical (except the form name, of course). I don't want to change the setting directly on the form because then the users who are allowed to enter information will not be able to either.
Even once I create the .mde file, it still reacts the same.
Has anyone seen or heard of this happening? I am clueless on how to fix this.

Thanks!

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

mmcdonal · June 11th, 2007, 01:53 PM

Where are you getting the user information from that you can tell they are not allowed to edit data? I am assuming you are using account types, and you can tell by account type, and not by user name. If that is accessible, then do this on the On Current event of the form:

If UserGroup <> "Editor" Then 'for example
   Me.btn1.Visible = False
   Me.btn2.Visible = False
   Me.txtBox1.Enabled = False
   etc
Else
   Me.btn1.Visible = True
   Me.btn2.Visible = True
   Me.txtBox1.Enabled = True
   etc
End If

You can use various conditions based on your user information. I did this backwards since you will want to to default to a negative condition if information is missing. But you get the idea.

Did that help?

mmcdonal

lryckman · June 11th, 2007, 03:19 PM

Actually, I'm not pulling user names. I created different Main Menu's based on the two groups. Then changed the start-up form depending on which .mde interface I was creating. Then I control which one they use based on which one I e-mail to the user. Sounds a little generic and dorky, I know...but I haven't used security in any other way yet. I bought that book on Access Security that you suggested in the last topic I had, but I haven't had much time to play around and learn it yet.

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

mmcdonal · June 12th, 2007, 06:30 AM

Well, if you have different versions of the front end, then just do this on the forms where you don't want the users doing data entry:

On Current:
Me.btn1.Visible = False
Me.btn2.Visible = False
Me.txtBox1.Enabled = False

Alternatively, you can just disconnect the tables and use local tables so it doesn't matter if they get into the tables and start to mess around. Also, in the this interface, select each table etc, and then right click and select Properties, and check the hidden box. Then if they open the database window they won't be able to see the tables - unless they know how to view them etc.

mmcdonal