Making a button limit the view of the records

[Pusher]

Hi all,



I must limit the possibility of viewing the records by day and by person. Every record has a person that entered the record and date. I want to make my button (buttons for record navigation) limit by person and by date so you can only view that current date and if you entered it today. (by date).


Thanks

 

[vbaInet]

You said you want to restrict users from viewing only their records how will they create new records?

 

[Pusher]

I am trying to figure out how to do that. I would like that they can
1. View all the records that they made (in every record there is a field for the person who entered it)
2. Enter new records, and to go true them if changes are needed
3. After they are finished with the record they can be locked (only can be viewed from that form) After locking the records they can’t be changed (they are archived)

Its hard to figure out how to do all this

 

[vbaInet]

Before step 1, how do they get to choose a customer or client if they are not allowed to view it? Before step 1 they are not yet linked to a client, customer or transaction for the current day.

Think about your logic.

 

[Pusher]

I'm in a process of figuring out how to do that. I want to go on edit form, but limiting the editing end viewing of record in the form if possible.

 

[vbaInet]

It's not a "how to do it" matter. It's a, "the logic isn't right" matter.

Once you've sorted out your logic let us know.

 

[vbaInet]

I'm in a process of figuring out how to do that. I want to go on edit form, but limiting the editing end viewing of record in the form if possible.

Why the repetition?

 

[Pusher]

There is a different Login form that gets the name of the user that enters the records, that is how i get my name of user.
The repetition is an error, didn't mean to repeat it.

 

[vbaInet]

Like I said to you, re-think your logic and let us know. I've already told you why it won't work in post #4.

 

[Pusher]

Let’s say they can see everything. That is not the problem, the information is sensitive, that once entered(marked finished in some way) it must not be changed. Let’s just make it that when the record is entered it can be locked in some way forever. Records are not limited by filing all fields and that is one of the problems and there can be a few records that are entered during the day so it can’t be made so that only new records can be made and old can’t be viewed (the data for one record can be entered during the day -8h shifts- and more records are filled and finished at the same time during the day).

 

[vbaInet]

That is not the problem, the information is sensitive, that once entered(marked finished in some way) it must not be changed. Let’s just make it that when the record is entered it can be locked in some way forever.

I think what you want to do is HIDE records marked as COMPLETED right? Do you have a Yes/No field called Completed or similar?

 

[Pusher]

Hide the records... That is an interesting idea, how do I hide a record? Can I look at it from that form?

 

[vbaInet]

If you have a Completed field, just filter your form's record source to exclude any records that are completed. I'm sure you know how.