[python-win32] Newbie Access question

Heath Lang Heath@unterlaw.com
Mon, 21 Jan 2002 12:35:28 -0600


Any ideas on how to trap the keystroke events?  I'm having problems finding
any detail online.  Thanks again.

-----Original Message-----
From: Jorgensen, Jens [mailto:jens.jorgensen@tallan.com]
Sent: Sunday, January 20, 2002 2:13 PM
To: Heath Lang
Cc: python-win32@python.org.
Subject: Re: [python-win32] Newbie Access question


Heath Lang wrote:

>I recently started writing an interface to an Access table using Python.
>Everything is proceeding fine, but I'm having problems Autofilling an entry
>box.  I was considering executing a sql command everytime the user entered
a
>letter in the entrybox.  And the SQL command would fill the subsequent
menu.
>But there has to be an easier way.  Any suggestions would be greatly
>appreciated.  Thanks.
>
>_______________________________________________
>Python-win32 mailing list
>Python-win32@python.org
>http://mail.python.org/mailman/listinfo/python-win32
>
I don't think there really is an easier way. That is, there really isn't 
any magic to this kind of thing. What you probably want to do is preload 
the values for the column and then trap keystroke events as they are 
typed and match up to the typed characters. I'm sure running a query for 
each keystroke will be prohibitively expensive.

-- 
Jens B. Jorgensen
jens.jorgensen@tallan.com