Search results

To prevent user to forget to enter data I put in table option that field is required. Now when I copy and leave that option I get message that field required and I must enter value

You mean something like this? Private Sub Kopiranje_podataka_Click() With DoCmd .RunCommand acCmdSelectRecord .RunCommand acCmdCopy .GoToRecord , , acNewRec Me.AllowEdits = True .SetWarnings False .RunCommand acCmdPaste .SetWarnings True...

I like first idea Where to put that it is done automaticle after copy?

I made mistake, I want to copy 80 fields I have about 100 fields. I dont want that fields to be copy but I want to be able to enter data in that fields

About 80 fields,

You are right

No I want to copy all but to be able to change data in some field or not to copy that field.

If I can one more question, Its copy all data, it is ok. How to prevent to copy or change just some of data, is that possible?

It's works Thank You very much

It show copy is not avaible

If You have time I wolud ask you for a favour, can You put that command in db that I posted and attach so I can download

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

Where to put that, I men first thing

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

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

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

I think i dont have that options in 2007

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

Is it possible to talk via skype or sometning else?

Nothing prevent