Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 14th, 2005, 12:42 PM
newaccess newaccess is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 9 newaccess User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 21 sec
Reputation Power: 0
List Box??

I am very new to access and have no knowledge about database/programming.
This is my first day working on Access.I am in the process of creating a table.One
datafield which is called "Volunteer interest type" needs a list box from which the user
can select values like "planting trees" or "Giving blood".Is there a way of creating a
Listbox while defining a datafiled in the table.Or is there anyway I can do this?
Any help with this is greatly appreciated.Thankyou.
.

Reply With Quote
  #2  
Old January 14th, 2005, 04:18 PM
lwells lwells is offline
Contributing User
Dev Articles Novice (500 - 999 posts)
 
Join Date: Sep 2004
Posts: 632 lwells User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 21 h 59 m 38 sec
Reputation Power: 5
In a table you won't have the choice of a list box. However you can select the combobox for the items you wish to list using the value type. Then in your form, you can change the combobox to a list box by right clicking on the combobox in design view and select Change To, and then change the combobox to a list box.

lwells

Reply With Quote
  #3  
Old January 14th, 2005, 06:17 PM
newaccess newaccess is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 9 newaccess User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 21 sec
Reputation Power: 0
Thankyouvery much for your reply.This is very advanced for my level of knowledge.
How do I select the combobox?I Have created the table in design view and defined
the datafield as "VolunteerInterestType".Can you take me from here?Thanks again
for your time.

Reply With Quote
  #4  
Old January 15th, 2005, 10:33 AM
lwells lwells is offline
Contributing User
Dev Articles Novice (500 - 999 posts)
 
Join Date: Sep 2004
Posts: 632 lwells User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 21 h 59 m 38 sec
Reputation Power: 5
Actually, I was mistaken, you can make a list box while designing your table. After you create your field and set the datatype to Text while in the table design view, at the bottom you will see a tab folder labeled Look Up. After clicking on that tab, place your curser in the text box and that will open a drop down arrow to choose either a text box or a list box or a combo box. Select list box, then in the area that displays Table/Query (Row Source Type) place your curser in that field to open a drop down box. Then select Value List. In the next text box below that (Row Source) you can type in what you want followed by the ; separator... "Planting Trees"; "Giving Blood" etc.

lwells

Reply With Quote
  #5  
Old January 16th, 2005, 10:41 AM
newaccess newaccess is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 9 newaccess User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 21 sec
Reputation Power: 0
Thanks a lot.It worked

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > List Box??


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway