Welcome to WebmasterWorld Guest from 54.167.213.22

Forum Moderators: open

Message Too Old, No Replies

Access: How to automatically fill in the rest of the fields

no strictly web related..

     
10:07 am on Jan 6, 2006 (gmt 0)

10+ Year Member



I have a database, table which lists all the banned users of a network username - firstname - surname - jobdesc, what i want to be able to do is create a form which when i enter the username it automatically fills in the rest of the fields i.e firstname & surname

any suggestions or points of reference, i just need to know what to search for?

Thanks

Dan

2:59 pm on Jan 6, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



There's lot of useful articles in the Microsoft Knowledgebase explaining how to do tasks like this.

Try How to Use a Bound Control to Find a Record [support.microsoft.com]

HTH

11:33 pm on Jan 13, 2006 (gmt 0)

10+ Year Member



In the form header:

Launch the combo box wizard and choose the option "Find a record in my form based on the option I select in the combo box"

In the next step, choose the username field.

You're done.

You don't have to use the combo as a drop-down, you can just type the value in if you want.

4:05 pm on Jan 30, 2006 (gmt 0)

10+ Year Member



Thats great,

for instance i have a table where a number of entries are the same name, Surnames!

i.e

Mohammed Ali x 10.

i need to show a list of all the ali's in my table/database?

search for ALI

Results
Mohammed Ali
etc ALi
Etc Ali

Help!

5:51 am on Feb 1, 2006 (gmt 0)

10+ Year Member



i need to show a list of all the ali's in my table/database?

You could just create a query or if you want a form, create a continuous form and use either the Filter by Form tool or the Filter by Selection tool.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month