Double paste

[jamesfranklin]

Hi,
i'm having 3 column in a table


its a correct updation

department orgname country

Department of physics California university usa




its a wrong updation

department orgname

Department of physics Department of physics California university

country
usa


Thank u............

 

[pr2-eugin]

Hello James, you might want to look at THIS THREAD..

 

[jamesfranklin]

Hi pr2-eugin,

I read the thread.

 

[boblarson]

Hi pr2-eugin,

I read the thread.

And didn't come away with anything?

The hint is - you haven't included sufficient information to even have a clue as to what you are doing. We can't see what you see so we don't know if you are working in a table, query, form, etc. And a lot more things.

As Johnny 5 in the movie Short Circuit would say - "NEED INPUT."

 

[jamesfranklin]

Hi boblarson,
Thanks for ur quick reply. ya sure am working in query. Probably am doing data entry work. I have already include that am having 3 columns in a table. During my careless mistake i double pasted in a field. i have already mention example above.


Thank u.....

 

[boblarson]

Ok you have a double entry. What is your question? You didn't state what it is that you want to happen or even exactly how this is being done. You say you are doing data entry. You say with a query. But since we can't see what you see you are leaving out a LOT of needed information.

Please answer in greater detail.

I'm going to state what I think you need to do. Click in the field and delete the double pasted data.

 

[jamesfranklin]

Hi boblarson,
thank u for ur reply. i attached one file u just see that and u can find what i needed. i already told u that i'm doing data entry work and simply copy from website and paste into appropriate column. when i'm doing this in continues this mistake happen double paste on the single field.


I don't no how to explain apart from this

Thank u..

 

[jdraw]

You are telling us HOW you are doing whatever it is.
Please tell us as clearly and simply as possible -- WHAT are you trying to do?

 

[boblarson]

How are you pasting the data in? Are you using right click and select PASTE? Are you using CTRL + V? How are you doing that. And if you are pasting directly into the table instead of a form? It looks like you are hitting something more than once.

 

[jamesfranklin]

I,m directly pasting into the table using (Ctrl + V)

Thank u..

 

[boblarson]

I,m directly pasting into the table using (Ctrl + V)

Thank u..

So, it would appear that it has nothing to do with Access and would have to do with your keyboard possibly pasting multiple times.

If you want to keep this from happening, use a FORM to enter data to the table and instead of using your keyboard to paste have a button on the form you can click to paste into the control you want it into. And, the code would be something like this in that button's click event. You would click in the control you want to paste into and then hit that button.

Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdPaste

 

[jamesfranklin]

Hi boblarson,
thank u for ur reply...