Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 21st, 2011, 09:57 AM
Registered User
Join Date: Apr 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question copy and paste

NewBe, starting to use vba.

I have a sub that in a form control that opens a table using the Select Case.
When the table opens, I then select the record that I want and close the table bringing me back to the form view. the sub code then paste the data into the control, however, it also pastes the table field names. ie.....

Table A Data
IDNO : 1000
WorkItem : Fix Pipe

Form A
controlname: WorkItem

When I paste into the control text box, below is whats pasted.
Anyway I can eliminate the Table Field names being pasted.

IDNOWorkItem ...1st line
1000FixPipe.........on 2nd line

Thanx for any input to my glitch

Last edited by jbroc; April 21st, 2011 at 09:59 AM.. Reason: to make more understanding

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and Paste the value waka Excel VBA 7 October 28th, 2009 10:08 PM
copy paste !!!!!!! dpkbahuguna Beginning VB 6 1 March 30th, 2007 10:06 AM
Copy, Paste dpkbahuguna Beginning VB 6 1 October 26th, 2006 10:30 AM
copy and paste url k.manisha ASP.NET 1.0 and 1.1 Professional 1 October 14th, 2006 05:15 AM
Copy and append paste canmex Access 2 October 7th, 2003 01:25 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.