Re: Commit Paste / Change Column Focus in Browse Window

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JJ (jjyg_at_adelphia.net)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 19:16:13 -0400

Are you saying modify the structure of the database or add a
calculated virtual column or something to my browse window?

This is not a production application. I'm just working with a lot of
data (a big contact list) using the command windows some really short
programs etc. to speed up a lot of manual cleanup.

Tabbing over or moving the cursor with the mouse is not that big of a
deal but I had hoped to automate it to speed up my work.

Just positioning the cursor outside the pasted field by tabbing, or
moving the cursor with the mouse commits the paste allowing me to
manipulate the data that was pasted.

On Wed, 18 Aug 2004 16:03:04 -0700, Cowboy
<Cowboy@discussions.microsoft.com> wrote:

>Add a new column, paste to that column, write a code snippet to parse to the
>other fields, then delete the temporary new column
>
>"JJ" wrote:
>
>> please copy
>>
>> jjyg
>> at
>> adelphia dot net
>>
>> ---------------------------------------------------------------------------------
>> Commit Paste / Change Column Focus in Browse Window
>>
>> Working from Command Prompt with a Browse Window I cut & paste a piece
>> of data from a web site into a column of the Browse Window.
>>
>> I immediately want to execute a small program using On Key Label which
>> will act on the newly pasted data, but I can't until I tab out of the
>> pasted column because the data is not commited to disk (or whatever)
>> until I leave that column.
>>
>> I.E. FoxPro thinks the field is still empty or contains whatever it
>> contained before I did the paste.
>>
>> E.G. I have two columns in the Browse Window
>>
>> From a website list I cut the name
>>
>> "Blow, Joe"
>>
>> and paste it into the first field/browse column
>>
>> LastnameFirstname
>>
>> ON KEY LABEL F11, I execute a program which will parse the newly
>> pasted data and replace the 2nd field/Browse Column
>>
>> FirstnameLastname
>>
>> with
>>
>> "Joe Blow"
>>
>> I press F11 to run the program until I commit the pasted data
>>
>> "Blow, Joe"
>>
>> to the first field/browse column
>>
>> LastnameFirstname
>>
>> To do this manually I simply tab out of the field/browse column
>>
>> LastnameFirstname
>>
>> I don't want to have to do this over an over again. I want to include
>> code in the program that executes on the pressing of F11 that will
>> either tab a field, skip a record and skip -1, refresh the browse or
>> do something to commit the pasted data.
>>
>> What's the best easiest way to do it?
>>
>> Thanks
>>
>> John "J.J." Jackson
>>

John "J.J." Jackson

Relevant Pages