Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
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
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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

All times are GMT -4. The time now is 07:41 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.