Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Need help on MS Access.


  • Please log in to reply

#1
MaMister

MaMister

    Member

  • Member
  • PipPip
  • 96 posts
I am creating a database using access 2003 for myself.

Everything I key in a new record I have to manually type in the name in the first field, it is time consuming if the name is long.

So I created a drop down list.

I wanted to get the data on my "name" field, so during the list creation I choose the option:
"I want the list box to look up the values in a table or query"

Then I realised that the names that I key in few times all appear in the list box...:
Eg.
Francis. T
Francis. T
Francis. T
Sean. S
Sean. S
Sean. S
Michelle. G
Michelle. G

For Francis. T I had key in 3 records and Sean 3 records and so on.

Is it possible to tap on the exisiting name field values but only display 1 name of its type?
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
MaMister,
There are a number of ways to setup list boxes and combo boxes
It depends how and where you store and recall the data

the following links will provide more detail
http://www.fontstuff...ss/acctut11.htm
http://www.fontstuff...ss/acctut20.htm


HTH

dsm
  • 0

#3
MaMister

MaMister

    Member

  • Topic Starter
  • Member
  • PipPip
  • 96 posts
Thanks.

I found the solution, it is SELECT DISTINCT under query.

Hope this help others too...
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP