Copy field in form

[Tragac011]

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.

When I lock some field in properties and press button to copy all records, thats records who are locked is not copy

 

[Tragac011]

Sometimes I use blank form, sometimes I copy older data and change certain filed.

 

[GinaWhipp]

Hmm, I'm not sure how to explain. Let's try this...

Right now you Form is not locked, so what prevents a User from changing the data?

 

[Tragac011]

Hmm, I'm not sure how to explain. Let's try this...

Right now you Form is not locked, so what prevents a User from changing the data?

Nothing prevent

 

[Tragac011]

Is it possible to talk via skype or sometning else?

 

[vbaInet]

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.

Just throwing out ideas to get the OP thinking.

With the form's Allow Edits property set to No and Allow Additions set to Yes you can't edit already saved data but you can add new data. So what I was getting at is Copy current record (if it's not New), Move to New Record, Paste. At this point the form is in edit mode.

I've just had a look at the db and I can see the Excel like table you're talking about.

 

[Tragac011]

Just throwing out ideas to get the OP thinking.

With the form's Allow Edits property set to No and Allow Additions set to Yes you can't edit already saved data but you can add new data. So what I was getting at is Copy current record (if it's not New), Move to New Record, Paste. At this point the form is in edit mode.

I've just had a look at the db and I can see the Excel like table you're talking about.

I will try that. I know tht my db is not perfect but it's works I didn't go to school to learn access that only my hoby

 

[Tragac011]

Just throwing out ideas to get the OP thinking.

With the form's Allow Edits property set to No and Allow Additions set to Yes you can't edit already saved data but you can add new data. So what I was getting at is Copy current record (if it's not New), Move to New Record, Paste. At this point the form is in edit mode.

I've just had a look at the db and I can see the Excel like table you're talking about.

I think i dont have that options in 2007

 

[GinaWhipp]

That option has been around before 2007 but you need to be in Design Mode in the Properties window of the Form.

 

[Tragac011]

That option has been around before 2007 but you need to be in Design Mode in the Properties window of the Form.

In what tag, Format, Data, Event, Other...?

 

[GinaWhipp]

Look on the Data tab.

 

[vbaInet]

Some visual:

 

[Tragac011]

Look on the Data tab.

I have Enable and Lock, dont have Allow Edits Allow Additions

 

[vbaInet]

And some more visual:

...make sure you click the form.

 

[Tragac011]

And some more visual:

...make sure you click the form.

Ok find it but when I try to coy paste is not aviable now

 

[GinaWhipp]

You are correct!

vbaInet... How were you able to paste the record?

 

[vbaInet]

There are two things one can do:

1. Use the acCmdCopy and acCmdPaste or acCmdPasteAppend (don't remember which one) parameters of RunCommand method. Of course you'll need to turn off and on the Warnings (SetWarnings).
2. Use a Dictionary object, cycle through each control, get a copy, move to a new record, cycle through object again and get value.

 

[Tragac011]

There are two things one can do:

1. Use the acCmdCopy and acCmdPaste or acCmdPasteAppend (don't remember which one) parameters of RunCommand method. Of course you'll need to turn off and on the Warnings (SetWarnings).
2. Use a Dictionary object, cycle through each control, get a copy, move to a new record, cycle through object again and get value.

Where to put that, I men first thing

 

[vbaInet]

In the Click event of a button. I'll start you off:

    DoCmd.RunCommand acCmdCopy
    DoCmd.GoToRecord , , acNewRec
    DoCmd.SetWarnings False
    DoCmd.RunCommand acCmdPaste
    DoCmd.SetWarnings True

I would normally use a dictionary anyway but it's more involving. Give the above a go.

 

[Tragac011]

In the Click event of a button. I'll start you off:

    DoCmd.RunCommand acCmdCopy
    DoCmd.GoToRecord , , acNewRec
    DoCmd.SetWarnings False
    DoCmd.RunCommand acCmdPaste
    DoCmd.SetWarnings True

I would normally use a dictionary anyway but it's more involving. Give the above a go.

You mean to add button and copy this command, I try that it doesn't work