D
David Payne via AccessMonster.com
OK. i am new to Access but can do anything i am told. This seems like a
simple request but i cannot figure it out.
i have created a database with 6 columns of data. fields are
1. Employee
2. Room #
3. Phone #
4. Floor
5. DEPT
6. a field for hyperlinks
i am trying to create something where the end user can access an html page
(my data access page) type a users first or last name (last is more
important) into a search box, press enter and it will fill in the rest of
the fields. we have about 600 users and although not many will use this the
ones who do need simplicity.
I have found a script that i used to update user name as it is being typed
in the "combo box" that i was going to use for search, but i cannot figure
out the syntax for "on enter" fill in the rest of this form with the
correct data from the DB. i hope this makes sense. I could very easily be
approaching this the wrong way too, so i am open to any new ideas to make
my life easier. i will be happy to clarify if needed.
Thanks in advance, from what posts i have read you guys are awesome.
Dave
simple request but i cannot figure it out.
i have created a database with 6 columns of data. fields are
1. Employee
2. Room #
3. Phone #
4. Floor
5. DEPT
6. a field for hyperlinks
i am trying to create something where the end user can access an html page
(my data access page) type a users first or last name (last is more
important) into a search box, press enter and it will fill in the rest of
the fields. we have about 600 users and although not many will use this the
ones who do need simplicity.
I have found a script that i used to update user name as it is being typed
in the "combo box" that i was going to use for search, but i cannot figure
out the syntax for "on enter" fill in the rest of this form with the
correct data from the DB. i hope this makes sense. I could very easily be
approaching this the wrong way too, so i am open to any new ideas to make
my life easier. i will be happy to clarify if needed.
Thanks in advance, from what posts i have read you guys are awesome.
Dave