Creating Dropdown in forms and User ID

[Stizzo]

How do you create dropdown menus in Forms? Also, how do you create user ID's
and passwords to get into Access? thanks

beginner-Stizzo

 

[John W. Vinson]

How do you create dropdown menus in Forms?

What do you want the "dropdown menu" to do? A Combo Box is a dropdown which
allows you to select a value to populate a table field, or search for a record
based on a field; is that what you mean?

Also, how do you create user ID's
and passwords to get into Access? thanks

Depends on the version. A2007 has removed workgroup security, and does not
allow you to create user IDs or passwords. For earlier versions download the
Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it CAREFULLY. Get a good night's sleep. Read it again, even
more carefully! Follow the instructions step by step, checking them off on the
printout. Security is complicated, and easy to do wrong!

 

[Stizzo]

Just the simplest version will do. Customer will click that arrow and get a
list of items to populate that box in forms or tables.

 

[John W. Vinson]

Just the simplest version will do. Customer will click that arrow and get a
list of items to populate that box in forms or tables.

Create a Form based on your table; use the Toolbox and select the Combo Box
wizard. Follow the instructions.

You might want to get a broader acquaintance with Access databases in general:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Crystal's and Allen's tutorials are both worth a look; the other two sites
contain links to many other resources.