send keys macro solution to linking many txt files please...

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

From: John Alexander (johnaalexander_at_comcast.net)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 07:14:40 -0800

Hello,
I am linking to many tab delimted text files, which are
not always consistent (i.e.-sometimes columns will be
missing altogether upon refresh, causing problems with
the linked data).

I may have found a solution by using the "send keys"
action Macro. This seems to work perfect all the way up
to the very end, when the final confirmation
message "finished linking table..." appears. I have
tried everything I can think of to either eliminate the
pop-up (set warnings on to "No") and hardcoding the final
{enter} or ~ to emulate clicking "OK". My understanding
is that the final message halts the macro, so a
knowledgebase article suggests moving the {enter} or ~ to
BEFORE the key which causes the confirmation pop-up. I
tried this...still doesn't work. I feel that I am SO
close with this solution. Here are the keys I am sending
after setting warnings to "No":

%fglc:\data\mel\excel stuff for john a\Pitch 35P.txt%
kdnrn%nPitch 35P%fy~

The final "~" is to simply enter "OK" after the
confirmation, but it wont work.

Please help...

Relevant Pages

  • Re: Tables wont link correctly
    ... Well, I started from scratch and made a whole new form, linking all three ... tables, their keys and data. ... working db and find yourself up the creek! ...
    (microsoft.public.access.tablesdbdesign)
  • Re: confirmation page not displayin pictures
    ... > wasn't exactly making it clear what they were asking. ... Double check the location of the pages to you'r linking to. ... >> You don't link the confirmation page to the Submit button. ... >> You designate the confirmation page in Form properties, ...
    (microsoft.public.frontpage.client)
  • Does anyone have any examples of....
    ... splitting it into normalised relations (columns ... predefined, and always the same), assigning apprpriate ... and then linking the relations together? ... so the keys from the appropriate tables are ...
    (microsoft.public.access.conversion)
  • Does anyone have any examples of...
    ... splitting it into normalised relations (columns ... predefined, and always the same), assigning apprpriate ... and then linking the relations together? ... so the keys from the appropriate tables are ...
    (microsoft.public.access.externaldata)
  • No key beep in Accesibility features
    ... I am trying to help a disabled user who needs the confirmation 'beep' when a ... click on 'Beep when keys pressed or accepted' ... I have tried this on my own XP Pro PC and get no sound from the keys either ...
    (microsoft.public.windowsxp.help_and_support)