Retrieve Data from Memory?

  • Thread starter Thread starter Robbie Baquiran
  • Start date Start date
R

Robbie Baquiran

I have this form which I would like to auto populate based on a string
copied from another program.
I can't figure out how to set the value of a variable to that string from
within an access vba routine.

The string copied from the other program is address information which has
been validated with USPS. This string needs to get broken out to the
appropriate fields via command button click.

Any ideas?

Thanks in Advance!
 
This string would be the last thing in memory. It comes from the "USPS
Address Verifier v1.3" widget using Konfabulator. There's a button where
you can copy output data and ctrl + v into wherever.

What I want to do is capture that ctrl + v and parsing it out into their
respective fields without having the user first paste the data into a text
field then pressing the button to populate.
 
I really don't know if there is a way to do that. You might have a look at
the Sendkeys statement in VB editor Help. It shows an example of shelling
the the calculator, adding some number, and getting a value back. It may be
possible to shell to the address verifier, give it the address to look up,
and have it return the value to you.
Don't know if that will work, but it would be an interesting experiment.
 
Thanks Klatuu for the suggestion. Shelling calc.exe and sending keys to it
from an A2k3 application still doesn't allow the value copied from calc.exe
to be assigned to a variable within the script :\

There's got to be another way to copy values in memory. If this was a perl
world - I'd be able to capture the data via stdin, I wonder VBA has to have
similar functionality, oh poo ><
 
I guess you are right. I thought I had seen an example somewhere that it
showed how to do that. Must be halucinating again. Sorry

I wonder if there is an API that would do that?
 
Back
Top