SendKeys: Repeating Keystrokes in ASP Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I'm trying to transfer information with the SendKeys from my Access
database to a .aspx web form. The problem i'm having is that some of my text
string show repeating characters in the web form randomly. An example of
what happens is below. I've tried sending one character at a time (with a
delay between each character) but still have the problem with certain
characters repeating. Does anyone have any suggestions?

ACCESS DATABASE SHOWS:
First Name: Joseph
Last Name: Smith
Address: 123 Easy Street
City: Mountain View
St: CA

WEB FORM DISPLAYS:
First Name: Jossephh
Last Name: SSmitth
Address: 1223 Eassy SStreet
City: Mounnttttttain Viewww
ST: CC
 
Hi, Aaron.
I'm trying to transfer information with the SendKeys from my Access
database to a .aspx web form.
Click to expand...

This is not recommended. SendKeys is not reliable in that it doesn't
guarantee execution of the code when it's intended to be executed. Besides,
when the operating system is upgraded to Vista, if UAC is turned on,
SendKeys won't work. At all.
Does anyone have any suggestions?
Click to expand...

Are you the author of the ASPX Web page? If so, you can rewrite the Web
page to accept parameters within the URL, read those parameters and insert
them into the form's text boxes.

If not, do you have FTP access to the Web server? You could write such an
ASPX file, upload it to the Web server, and call it with your Access
database application using an URL containing the appropriate parameters and
data. Or you could write an ASPX file on the fly (from a template) that
already has the text boxes filled with the appropriate data, upload this
file to the Web server, call it from your Access application, and post the
data to the Web server's database through, say, a button on the Web form.
Or you could write an ASPX file on the fly (again, from a template) that
produces an INSERT INTO SQL query that, when called, will execute the SQL
statement with the appropriate data. Then upload this file to the Web
server, and call the Web page from your Access database application.

If not, then you'll have to look for other alternatives, because SendKeys
isn't going to be reliable enough.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top