By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Prevent changes to records when viewing data thru a form

P: 3
Hello Experts..
Im checking out the other side of the tracks here.. always been a Systems Analyst kind of guy. Developers are a touchy and unpredictible lot. I try to give them their space and never poke my finger into their cages. I was sad that Steve Erwin didn't do a spot on Developers before he left us..

Anyway.. Figured I'd be doing pretty good for myself if I could find some assistance here, then back out before I got eaten alive.

MS-Access 2003 w/ Sp1 on Windows XP Pro

Got a pretty table and a form too. The form has a combo box which displays the records associateed with combo box selection. Cannot prevent accidental changes to the records. Want users to VIEW only. NO TOUCHY Da Data. (users is so stewpud)

For editing ..my switchboard has a button which runs a macro to open the table for editing. But when 'viewing' thru the particular form mentioned above, i need the records locked down. No Edits. No Additions. No Deletions.

I've hacked at this for a couple days now. None of the results are what Im after. This has to be an easy fix.. right? ..Christ, I probably sound like a user? Im dead meat.
Sep 10 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,324
The problem with the standard switchboard is that it doesn't allow you to open a form in that manner. A work around is to create a copy of that form and set those properties that you listed and open that form instead.

Personally, I prefer to create my own switchboards. I actually didn't know that Access had a switchboard wizard until well after I've been developing for a while.
Sep 10 '07 #2

P: 3
Thanks Rabbit
When I set 'allow edits', 'allow deletions', 'allow aditions', to NO, I can no longer make a selection from my combo box. It drops down, and I can see the list, but it will not allow me to make a selection.

It makes sense, as these properties are for the form, not the record data populating it. Setting these attributes protects my record data by locking the form into a useless state.

This is one of the undesirable results I achieved in earlier attempts.
Of course I can set the DB to read only, but then I can't edit when needs be.

Perhaps there is something I can do using 'On Dirty'..?
Sep 11 '07 #3

Rabbit
Expert Mod 10K+
P: 12,324
Thanks Rabbit
When I set 'allow edits', 'allow deletions', 'allow aditions', to NO, I can no longer make a selection from my combo box. It drops down, and I can see the list, but it will not allow me to make a selection.

It makes sense, as the data in the form fields are locked down nice and tight, however, its locked down on the initially displayed record and will not allow me to even make a selection from my combo box. It must be interpreting the selection as an edit.

This is one of the undesirable results I achieved in earlier attempts.
You can set Allow Edits to Yes but lock the rest of the controls individually through the Locked and/or Enabled property. You can select all the controls but the combo box and set all the properties at once.
Sep 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.