[AccessD] Auto Lookup

Michael R Mattys michael.mattys at adelphia.net
Tue Nov 25 16:01:57 CST 2003


Mike,

If you're looking for an event proc, try writing code
for the OnChange event by testing the length of the
string that the user has typed in.

Michael R. Mattys
Try MattysMapLib for MapPoint at
www.mattysconsulting.com



----- Original Message -----
From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, November 25, 2003 4:34 PM
Subject: RE: [AccessD] Auto Lookup


> Yeah I understand that is simple stuff, but that is not the part that I
> am having problems with.  I can get the form populated by the user
> selecting from the combo box and pressing either the Enter Key or Tab
> Key.  What they want to be able to do is not have to press the Enter Key
> or Tab key for the information to be populated automatically.  Say that
> they enter 123456 in the combo box manually, how can I get it to
> automatically look up the record without the enter key or tab key being
> pressed.  What they want to be able to do is once the info is shown than
> they want to be able to press the enter key and it will print the
> mailing label (I have that part working just great)as long as they
> select from the pull down list in the combo box.  It's the manual entry
> that causes a problem.  I hope that makes better sense.
> \
> \
> Mike
>
> -----Original Message-----
> From: William Hindman [mailto:wdhindman at bellsouth.net]
> Sent: Tuesday, November 25, 2003 2:24 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Auto Lookup
>
>
> Mike
>
> ...this is pretty standard stuff ...both of these sites have sample code
> and dbs that demonstrate different methods of getting the form populated
> with a record selected from a combo box ...HTH :)
>
> http://www.mvps.org/access/
> http://www.candace-tripp.com/access_downloads.htm
>
> William Hindman
> Government is not reason, government is not persuasion, government is
> force. It is a dangerous servant." G. Washington
>
> ----- Original Message -----
> From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, November 25, 2003 9:50 AM
> Subject: [AccessD] Auto Lookup
>
>
> >
> >
> > Hi All,
> >
> >
> > I am trying to complete a project on a Mail Processing database.  The
> > one part I am stuck on now is some way for the Auto lookup of a record
>
> > everytime a number is put it.
> >
> > I have a form in which it has 5 fields, the first field is the ID of
> > the person receiving the mail, the next four fields depend on this
> > number to be filled in.
> >
> > What I need it to be able to do is as the user puts in a number it
> > will auto check the table for the ID number and fill the fields on the
>
> > form with the underlying info with out the user having to press enter
> > or Tab to have update or search, something like on each Key Down or
> > Key Up. For example say the ID to enter is 123456, when the user
> > enters the 1 it will do a auto check for a ID of 1 and when the user
> > enters 2 it will do a auto check for a ID of 12 and so forth.
> >
> > I hope that makes sense.  Thanks for any info or examples anyone has
> > to accomplish this, if it is at all possible.
> >
> >
> > Thanks,
> >
> > Mike Gowey, MCSA, A+
> > Team Leader - SRCI
> > Information Systems & Services Division
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list