Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Locking Records

Locking Records

Locking Records

I want to know if it is possible to lock a record as read-only once it has been created? Basically, I'mtrying to create a "Suggestions" database for people to submit their ideas about our company. I want everyone to  be able to read other entries, but not edit them, but they must be able to create their own new records, which are then locked as read-only after they are done. Ideally, they would be able to edit their own records, but not others. Can this be done in Approach?

RE: Locking Records

The way I have got around a similar problem in the past is to create an identical view to the data entry one, but make it read only.
When users enter their comments, they would be sent to the read-write view, via macros / buttons etc.
After they have submitted/entered their comments, the macro/button would redirect them to the read-only view.
It's a low-tec way of doing it, and is by no means fool-proof, but it does reduce the accidental deleting/amending of data by users.
Also, it doesn't care who the user is. (as approach isn't big on this anyway!)

I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.

RE: Locking Records

Thank-you very much for responding to my plea! Unfortunately, I'm very inexperienced at anything even remotely programming-like. Could you give me further instruction on making this "macro", or point me in the direction of some instruction in this matter?
Again, thank-you very much.

RE: Locking Records

Creating a macro within approach is quite straightforward, and doesn't really need any technical know-how.  It's all point-and-click, and selecting commands from lists.

Do a search in the Approach Help for 'Creating New Macros' and follow the steps there.  Once you see how it's done, you'll be able to create all the macros you need.

I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close