Copy field in form

[Tragac011]

I have records that can be use several times and they dont change and record that change everey time. I want to be able to copy all records but also to locked older records to prevent users to change them.

Can someone help me about that?

 

[Tragac011]

No,I cant make it work

 

[GinaWhipp]

Copy all the records to where, Excel?

Do you have a field in your table to indicate a record should be locked?

 

[vbaInet]

I think the OP is trying to copy from one record to another and at the same time prevent users from editing certain fields whilst viewed.

If that's the case then you can use the Default Value property of a control or field? Or if there's a lot repetition between a few fields you could create another form that holds the repeats and a foreign key to link with your table.

As for the "locking" problem you can use the Locked property of a control to stop users from editing data in a particular record. If you want to lock an entire record, use the form's Allow Edits property.

 

[Tragac011]

Copy all the records to where, Excel?

Do you have a field in your table to indicate a record should be locked?

I try to explain, my english is not that good. In the form I have many data for one record, for one row in the table. I fish to be able to copy that records to another record but to prevent user to make change in older record

 

[GinaWhipp]

Okay, well still need to know...

Do you have field to indicate that a record should be locked? Hmm, let me see if this helps. I have a table in which I have a field cStatusID. If the Status is *C* the record is closed and locked. It gets that way when the User clicks the Submit button and the only person that can *unlock* it is an ADMIN. So, is there a field like that in your table?

Side note: The act of copying a record does not eidt the existing record in any way.

 

[vbaInet]

Let's begin with the second part preventing users i.e. "preventing users from editing saved records", have a look at the Data Entry property of the form and see if it meets your needs.

What that means is, it will only allow users enter data and that's it. It won't allow them view old data. Is this what you're after?

 

[GinaWhipp]

@vbaInet

I think they have to view it in order to copy it to another record, which is part two of the requirement.

 

[vbaInet]

@GineWhipp: Hmmm... you could be right. I wonder if s/he was talking about copying parts of the record that was just filled in. That was where I was coming from.

 

[GinaWhipp]

@vbaInet
Well, won't know till they post back...

 

[Tragac011]

@vbaInet

I think they have to view it in order to copy it to another record, which is part two of the requirement.

Yes I are right

 

[Tragac011]

Can I send someone of you database to see what I want?

 

[GinaWhipp]

You can post it here for us to review, you just need to remove any sensitive information.

 

[Tragac011]

I dont have any so important information

 

[GinaWhipp]

Hmm, sorry, I don't speak the language so I can't tell if there's a field in there to indicate when a record is locked or not. I am also a little concerned that your database is set up like a spreadsheet because of the amount of fields in a table and calculated fields that are in the table.

What real world issue are you trying to solve?

So, I am back to the same question... how do you know when a record should be locked for editing?

 

[Tragac011]

Hmm, sorry, I don't speak the language so I can't tell if there's a field in there to indicate when a record is locked or not. I am also a little concerned that your database is set up like a spreadsheet because of the amount of fields in a table and calculated fields that are in the table.

What real world issue are you trying to solve?

So, I am back to the same question... how do you know when a record should be locked for editing?

You see in form "Ugovor o prijemu aktuelan" when You open it You see varius data, I want to copy all off that data, There a Copy button "Prebaci podatke u novi ugovor", but to forbid changing the data in form from whom you copy

 

[GinaWhipp]

Okay... please answer this question...

Do you have field to indicate that a record should be locked?

 

[vbaInet]

I could be wrong again Gina but it sounds like he wants to be able to highlight a record on a locked form and copy it into a new record. Allow Edits = No, Allow Additions = Yes sort of thing as well.

 

[GinaWhipp]

vbaInet,

However from his first post I got the impression he want's to be able to edit the newly copied ones but not the old ones. I could do your way but then how would he edit the newly copied ones without some sort of *trigger* to indicate this one is editable? See what I mean?

Side note, the Form is not locked now and even if I lock it, you can still copy/paste to the new record but then the new record is not editable. That is why I am asking what determines what locks a record.

 

[Tragac011]

Okay... please answer this question...

Do you have field to indicate that a record should be locked?

Sorry I dont understand what are you asking for?

What kind of field?