By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Clipboard to table question

P: 17
I am working with a Reflections HP session and i created a macro within the VBA editor in Reflections where i copy to the clipboard the information i need. Now the issue is that i do not know how to get it from the clipbaord to either the table i need or on the form i have, either one will work really, Form would probably be easiest. Any assistance on this topic would be great and appreciated.


Expand|Select|Wrap|Line Numbers
  1.  
  2. Public Sub PasteData()
  3.         '****Copy starts here
  4.  
  5.     'CR = Chr(Reflection1.ControlCodes.rcCR)
  6.     'ESC = Chr(Reflection1.ControlCodes.rcESC)
  7.     Dim Tcode As String
  8.         Tcode = Session.GetText(3, 28, 3, 31)
  9.  
  10.     With Session
  11.  
  12.  
  13.             'rst!Taxcode = strtaxcode
  14.             'rst!Quarter = Quarter
  15.             'rst!year = year
  16.             'rst![Payee ID] = Trim(CStr(.GetText(8, 6, 8, 36)))
  17.  
  18.  
  19.         .Transmit "58FR" & CR
  20.         .StatusBar = "Waiting for Prompt: PRESS <RETURN> TO CONTINUE"
  21.         .WaitForString ESC & "&a23y00C                                                   PRESS <RETURN> TO CONTINUE", NEVER_TIME_OUT, rcAllowKeystrokes
  22.         .StatusBar = ""
  23.         .GetText 3, 28, 3, 31
  24.         '.SelectText StartRow:=3, StartColumn:=28, EndRow:=3, EndColumn:=31
  25.         ' Press EditCopy (Copy the selection and put it on the Clipboard).
  26.         .Copy rcSelection, 0
  27.         'DoCmd.TransferText acImportFixed, , "tblPayeeCNET"
  28.         rst!payeeidcent = Tcode
Jan 9 '09 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
See this link for Functions to copy to and from the clipboard and an ms access form.

Microsoft Access tips: Clipboard Functions (32-bit)
Jan 11 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.