ms access copy paste issue

Question

http://answers.microsoft.com/en-us/office/forum/office\_2013\_release-access/unknown-problem-in-ms-access/194c00e3-45a5-4f13-b4ab-74747b2b3263

here is my question and full detail please someone help me i dont know what to do to solve this problem i am totally new to ms access.

thank you

Answer 1

i need your Email Address that i will send my database copy to you

Answer 2

Can i attache my database copy here that you can look at it?

Answer 3

To add on to what Ken said, this is not the best methodology. First, it implies you are working directly with tables which is not a good idea. Second, it implies that your tables are not designed properly if you need to duplicate a lot of info. 

So you need to explain more fully. What does your database do? What is the structure of the table(s) you are working with? How many fields actually need to be duplicated and how many edited? A sample of the data may help.

Answer 4

I am copying current row and pasting it last in the record.  And after that i  am changing the information. Sometimes its working fine but some time i am facing this problem.

Answer 5

What are you trying to achieve in real life terms?  Copying and pasting an entire row from a table as a new row is a crude and risky methodology.  I assume that the intention is to then edit the new row as necessary.  Normally in situations like this the values from only some of the columns would be appropriately carried forward to a new row, in which case a better solution would be to set the DefaultValue property of the relevant controls to the values of those controls in the current row, then navigate to a new record.  The default values would then be in place ready for values to be entered in other controls.

If you can explain what you are trying to do rather than how you are trying to do it we might be able to advise you better.