Is it possible to be in Table mode and to only edit certain records. E.g: There are 10 records but I only want 5 to be editable, but at the same time I want all users to be able to view. I tried using the access privilages but 'Edit Limit editable records' the fields just come up 'Access denied'?

In layout mode, select the fields you want as uneditable, and select 'format', 'field format'

At the bottom of the format window, under 'behaviour', is a check box for 'allow entry into field'. Deselect the check box. Users can see the field, but not access it.

If i use the 'Do not alow entry command' then all the records will be locked. I need all the old recods as read only, but what ever is created after today as Read/Write.

hi there, I used three ways to do that.

First in editing limited fields you can put the CASE() and ask if the record was created before today, can not be editable (that

Thanks for all your ideas, but none of them work for what i need. If I use the Access privilages then the fields that are read only come up with access denied but I need people to be able browse. I tried the idea with 2 layouts but that won't work either (I would explain but I wouldn't finish till mornng). If I don'y sort it soon then my system is going to be thrown against the wall!!

GOT IT!

field1 = text field (this is the field) you dont want modified

Field1_auto = text field (auto enter calculation field1)

Date Created = date field (auto entered date created)

Field1 validation = Case( Status( CurrentDate) <> date created, field1_auto = field1,1=1)

the above will only let you modify the field on the date it was created

If you want I can e-mail you the fp5 solution.. Drop me a line

Stu

Hi,

here's my suggestion:

First disallow entry in your fields.

Than create script for every field that could be accessed:

Script "Enter"

if ["Status( CurrentDate) = date created"]

Go to Field [field name]

end if

HTH

Dj

and attach the field to a button!! Thats alot simpler than my solution although it does not work in table view. Great Idea for field level access based on a user password field entered at login against a hard coded password in the script.. We can use this in our solution here at my company..

AHHH you learn something every day

Stu

i wrote similar scripts to protect the data from being modified in our solution. basicvally, the warning dialog pops up, asking the user if they're sure...bla bla.

unless they are in the find mode, off course.

Hello Noddy;

YES... it is possible to be in the TABLE view of the BROWSE mode and limit EDITing to certain records...

In Define Fields...

- add a text field "EDIT"

In Access Privileges>Passwords...

- add password "A" with ALL privileges

- add password "B" with NO EDIT privileges

- add password "C" with EDIT>LIMITED...

-- when prompted to create a calculation...

--- enter this <EDIT="Yes">

In Browse mode...

- go to each record and enter "Yes" or "No" in the EDIT field

Close File

Open file

Enter "A" password...

- you should be able to EDIT ALL records in TABLE view

Enter "B" password...

- you should be able to EDIT NO records in TABLE view

Enter "A" password...

- you should be able to EDIT SOME records in TABLE view

-- those with "Yes" in the EDIT field

I would recommend creating a 'Test' file to experiment and get comfortable with this. E-mail me if you would like a sample file.

Hope this helps...

Bob