RE: Commit Paste / Change Column Focus in Browse Window
From: Cowboy (Cowboy_at_discussions.microsoft.com)
Date: 08/18/04
- Next message: Mike: "Re: Book Reccomendations"
- Previous message: Dan Freeman: "Re: Book Reccomendations"
- In reply to: JJ: "Commit Paste / Change Column Focus in Browse Window"
- Next in thread: JJ: "Re: Commit Paste / Change Column Focus in Browse Window"
- Reply: JJ: "Re: Commit Paste / Change Column Focus in Browse Window"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Aug 2004 16:03:04 -0700
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
>
- Next message: Mike: "Re: Book Reccomendations"
- Previous message: Dan Freeman: "Re: Book Reccomendations"
- In reply to: JJ: "Commit Paste / Change Column Focus in Browse Window"
- Next in thread: JJ: "Re: Commit Paste / Change Column Focus in Browse Window"
- Reply: JJ: "Re: Commit Paste / Change Column Focus in Browse Window"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|