Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

clipboard

  
   Database Forums (Home) -> Visual Basic -> DAO RSS
Next:  Long Select gets truncated  
Author Message
Erik Van De Putte

External


Since: Feb 15, 2007
Posts: 3



(Msg. 1) Posted: Thu Feb 15, 2007 12:08 pm
Post subject: clipboard
Archived from groups: microsoft>public>vb>database>dao (more info?)
SQLStr= "select id, name from patient order by id"
Set RS = DB.OpenRecordset(SQLStr, dbOpenDynaset)
rs.movefirst
clipboard.settext rs.fields("name")

When I use ctrl+V I want to paste "Bart" but it pastes "rs.fields("name")"

How to solve this?

Thanks,
Newbie Erik

 >> Stay informed about: clipboard 
Back to top
Login to vote
Erik Van De Putte

External


Since: Feb 15, 2007
Posts: 3



(Msg. 2) Posted: Thu Feb 15, 2007 12:08 pm
Post subject: clipboard
Archived from groups: per prev. post (more info?)
SQLStr= "select id, name from patient order by id"
Set RS = DB.OpenRecordset(SQLStr, dbOpenDynaset)
rs.movefirst
clipboard.settext rs.fields("name")

When I use ctrl+V I want to paste "Bart" but it pastes "rs.fields("name")"

How to solve this?

Thanks,
Newbie Erik

 >> Stay informed about: clipboard 
Back to top
Login to vote
Erik Van De Putte

External


Since: Feb 15, 2007
Posts: 3



(Msg. 3) Posted: Thu Feb 15, 2007 12:08 pm
Post subject: clipboard
Archived from groups: per prev. post (more info?)
SQLStr= "select id, name from patient order by id"
Set RS = DB.OpenRecordset(SQLStr, dbOpenDynaset)
rs.movefirst
clipboard.settext rs.fields("name")

When I use ctrl+V I want to paste "Bart" but it pastes "rs.fields("name")"

How to solve this?

Thanks,
Newbie Erik
 >> Stay informed about: clipboard 
Back to top
Login to vote
Norm Cook1

External


Since: Jun 27, 2004
Posts: 24



(Msg. 4) Posted: Thu Feb 15, 2007 12:08 pm
Post subject: Re: clipboard [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Erik Van De Putte" wrote in message

> SQLStr= "select id, name from patient order by id"
> Set RS = DB.OpenRecordset(SQLStr, dbOpenDynaset)
> rs.movefirst
> clipboard.settext rs.fields("name")
>
> When I use ctrl+V I want to paste "Bart" but it pastes "rs.fields("name")"
>
> How to solve this?
>
> Thanks,
> Newbie Erik
>
>

see if this helps
clipboard.clear
clipboard.settext rs.fields("name").value, vbcftext
 >> Stay informed about: clipboard 
Back to top
Login to vote
Thomas_Hübner

External


Since: Mar 27, 2007
Posts: 1



(Msg. 5) Posted: Tue Mar 27, 2007 4:55 pm
Post subject: Re: clipboard [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Norm Cook schrieb:
> "Erik Van De Putte" wrote in message
>
>> SQLStr= "select id, name from patient order by id"
>> Set RS = DB.OpenRecordset(SQLStr, dbOpenDynaset)
>> rs.movefirst
>> clipboard.settext rs.fields("name")
>>
>> When I use ctrl+V I want to paste "Bart" but it pastes "rs.fields("name")"
>>
>> How to solve this?
>>
>> Thanks,
>> Newbie Erik
>>
>>
>
> see if this helps
> clipboard.clear
> clipboard.settext rs.fields("name").value, vbcftext
>
>

or try this

clipboard.settext rs!name

or better this

clipboard.settext rs![name]
 >> Stay informed about: clipboard 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Clipboard content to Access field - Hello: How can I paste a bitmap image in clipboard to an Access field using VB? Thank you in advance.

strange! vb6+access2002 - I have a mdb called treesy.mdb.There is a table,named transcipt with three fields:serial_no, eng,sound serial_no:1-10 (10 numbers) eng: 1.The movie has been on for 15 minutes, madam.@ 2.Oh, my god!@ It's 7:45 now!@ 3.Is Helen coming?@ It¡¯s 6:50 now.@..

Authentication Error??? - Ok so heres the code.. for some reason I kept getting the no permissions message, so I attempted to add the access workgroup file. Now I get the "Authentication Failed" message. This is a secure database. HELP.. I know I'm writing (adding) som...

Database Access Crashes on Windows 2003 Terminal Server - I have been running a Microsoft Access 97 application on Windows 2003 Terminal Server for almost a year now, with no problems. About two weeks ago, I started to get the following errors in my event log: Application Error; EventID: 1000 Faulting..

Software Engineers required for USA - Dear Sir, Kraftware Inc. Software Engineers required for USA We are a leading software consulting company based in Nebraska (Omaha) Growing in business for the past 9 yrs. We are currently Experiencing Growth and we are Hiring Software Engineers for..
   Database Forums (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]