VB Copy information from IBM Reflection and Paste info to MS Access RecordSet

[usmcwhitaker]

Good Morning,

Currently I am trying to copy information from the IBM
Reflection
program and paste it into a recordset in Access Database. I am
trying
to figure out how to write the code. I have everything I need, how
to
write the coordinates, copy the selection, I just need to know the
command to make Access accept the information, paste the information
in the specific columns and go to the next line until a screen comes
up. This is an example of the code I am trying to write:


dim db as database
dim rst as recordset


set db = currentdatabase()
set rst = db.openrecordset("TEST1")


with rst


S = ![SDN]


I have the information to copy the information from Reflection,
If I run the macros and stop after the highlight and copy portion,
then go to access and push ctrl + v, the information I want is there.


Can someone tell me, with vb code, how do I set up this VB Code to
paste
at all? If I have that information, I can figure the rest out.


This is the line I am thinking right now:


..edit
![SDN] = .paste 'acpaste 'accmdpaste 'accmdpastspecial
..update


Please someone help,
It is driving me crazy.


If you dont know but know where to find the answer,
Please also send me the link or where I can go to find out.


Thank you very much,
Shayne

 

[John Nurick]

Maybe you need
DoCmd.RunCommand acCmdPasteAppend

Good Morning,

Currently I am trying to copy information from the IBM
Reflection
program and paste it into a recordset in Access Database. I am
trying
to figure out how to write the code. I have everything I need, how
to
write the coordinates, copy the selection, I just need to know the
command to make Access accept the information, paste the information
in the specific columns and go to the next line until a screen comes
up. This is an example of the code I am trying to write:


dim db as database
dim rst as recordset


set db = currentdatabase()
set rst = db.openrecordset("TEST1")


with rst


S = ![SDN]


I have the information to copy the information from Reflection,
If I run the macros and stop after the highlight and copy portion,
then go to access and push ctrl + v, the information I want is there.


Can someone tell me, with vb code, how do I set up this VB Code to
paste
at all? If I have that information, I can figure the rest out.


This is the line I am thinking right now:


.edit
![SDN] = .paste 'acpaste 'accmdpaste 'accmdpastspecial
.update


Please someone help,
It is driving me crazy.


If you dont know but know where to find the answer,
Please also send me the link or where I can go to find out.


Thank you very much,
Shayne