Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: Push all query contents to a text box

    Hello from the New Guy! Hope you can lend a hand with this:

    Working in Access 2003

    1 field of results from a select query appear as:

    <SMITH, MARIE>2124 WOOD LN PUEBLO CO 81001
    <JONES, AARON>999 S 83RD ST CANON CITY CO 81212
    <ANYONE, SHERRI>1515 PIKE ST PUEBLO CO 81001

    I need to push these into a text box with each address on a separate line in order to copy and paste them
    into a field on a web page which will optimize my driving route. My "workaround" right now is to export the
    results into excel where I can select the entire column and copy/paste.

    I'm thinking I have to somehow walk through the results and save them to a variable somehow.

    Thanks for any help! Looks like a great forum!

    ~Bob
    Last edited by HiFromCO; 07-27-12 at 23:15. Reason: update

  2. #2
    Join Date
    Jul 2012
    Posts
    2
    I found a better workaround than exporting to excel, consisting of doing command button with:

    SendKeys "^(a)"
    SendKeys "^(c)"

    which performs the needed function. I've always heard that sendkeys was problematic but it appears nobody has the equivalent vba readily available.

    I'm dealing with a very small record set with < 75 rows and one column so maybe I can get by with send keys.

    Thanks to those that took time to at least look! Cheers!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •