Paste clipboard item to field through VBA?

MS Office Access


  • 1. VBA Code to open Wxcel from within Access
    Hi, can anyone help please . . I thought it would be quite straightforward .. I want to write the code to open an excel spreadsheet from with Access. I can see how to do it with the RunApp Action in a macro, but not in code. Thanks!
  • 2. Controls in form
    Hi, I am trying to get the details of controls within a form. This code works when the form is loaded, but if it isnt, then it doenst. Dim frm As Form Set frm = Forms("frm_policies") For Each ctl In frm Debug.Print ctl.Name Next ctl Thanks in advance.
  • 3. Splitting tables
    I saved my database as an .mdb file and I splitted my tables successfully. But when I save my database as an .accdb (Access 2007) database, it wont work anymore. Could it be an incompatibilty with my DAO-code?
  • 4. Open PDF File with VBA
    Hi, Can anyone please help me with code to open an existing PDF file withVBA? Thanks. Alan

Re: Paste clipboard item to field through VBA?

Postby SmFpbWUgTmVsc29u » Sat, 03 Apr 2004 03:56:09 GMT

Whoops! What a noobie's mistake that was! Thanks Dirk. I feel rather sheepish right now

I did find anotherissue, but I will take it over to the Word forum, as my Access problems have been fixed. Thank you all! :)

Similar Threads:

1.Out of Memory adding items to listbox from clipboard-pasted textbox

I have a form with a listbox, a textbox, and a button. I paste a multi-
line chunk of text into the textbox and push the button to parse the
text into a listbox.

I us the following code:


Dim sTmp As String, iPos1 As Integer, iPos2 As Integer

sTmp = UserForm1.TextBox476.Text
iPos1 = 1
iPos2 = InStr(sTmp, vbCrLf)
Do While iPos2
UserForm1.ListBox3.AddItem Mid$(sTmp, iPos1, iPos2 - iPos1)
iPos1 = iPos2 + 1
iPos2 = InStr(iPos1, sTmp, vbCrLf)

The first time the form runs, it seems to work fine. Subsequent
loadings of the form result in Out of Memory errors that persist until
I quit an restart Outlook 2007.

Any ideas? Can the textbox hold all the clipboard characters?

2.Clipboard items not pasting in any Office app

User has pasted 5 items into the clipboard from Outlook 
message text.  User wants to be able to paste one of 
these items when creating a new message.  The clipboard 
does not paste in Outlook, nor Word, nor Excel.

Are there any formats that cannot be saved to the 
clipboard for pasting?

3.items from clipboard don't paste into my Office 2003 program

I can get items to copy into the clipboard.  But then I often cannot get 
those items to paste into an Office 2003 program ... Access, Outlook, Word 
... until I reboot.  This happens about twice a week.  I do a LOT of cut and 
paste in my work so I really use the clipboard feature.

4.Clipboard: pasting last two (or all) items from Word clipboard and clearing clipboard.

I copy two pices of text from another program and need some VBA way of
1    pasting them into Word in the order copied, then clearing the
2    adding various other stuff below the pastes (have macro for this),
3    manually entering three bits of text in separate positions in the table
formed by (2),
4    format the text, and print the page (have another macro for this).

What I'd like to do is combine the lot into one macro. I think I know how to
do (3) [but suggestions welcome!], but how do I do (1)??? It is not
something I can macro record.
The pastes contain different info but are always the same number of lines
and the manually typed stuff varies but is always in the same places.


5.PPT How do I paste clipboard info to a specific location with VBA

I want paste specific ranges in an Excel spreadsheet to a 
powerpoint slide at a specific location on the slide. I 
have sucessfully pasted to a slide but I cannot figure out 
how to position the pasted item where I want it.

6. Office Clipboard shows icon(s) when first opened, and can't paste XP clipboard contents

7. How do I paste from clipboard to range using Excel VBA

8. Pasting from the clipboard to the address box of inserthyperlink dialog window in vba

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 39 guest