Welcome to WebmasterWorld Guest from 3.214.184.124

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)

Full Member

10+ Year Member

joined:May 13, 2003
posts:313
votes: 0


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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 29, 2002
posts:981
votes: 1


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)

Junior Member

10+ Year Member

joined:July 29, 2003
posts:149
votes: 0


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)

Full Member

10+ Year Member

joined:May 13, 2003
posts:313
votes: 0


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)

Junior Member

10+ Year Member

joined:July 29, 2003
posts:149
votes: 0


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.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members