homepage Welcome to WebmasterWorld Guest from 54.161.175.231
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Access: How to automatically fill in the rest of the fields
no strictly web related..
humpingdan




msg:1579468
 10:07 am on Jan 6, 2006 (gmt 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

 

mattur




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

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

Lilliabeth




msg:1579470
 11:33 pm on Jan 13, 2006 (gmt 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.

humpingdan




msg:1579471
 4:05 pm on Jan 30, 2006 (gmt 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!

Lilliabeth




msg:1579472
 5:51 am on Feb 1, 2006 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved