Question Complete Access newbie with a question about Access 2007 Contact Database Template

vinnier

New member
Local time
Today, 12:10
Joined
Dec 16, 2009
Messages
5
First of all hello to all of you! :)

I am so sorry to waste your time with something so basic but I have never ever used access in my life. :o
So, using the Access 2007 Contact Database template I want to create a database of contacts, obviously ;)
This template has a Column called 'Category' with a drop-down list to chose from. I want to create another column called let's say 'Category 2' with a similar list.
I have studied and followed the MS video about creating additional columns in this template, but it only says how to create a regular type of a column like 'birthdays', where I can put in text manually but not choose from a drop-down list.
Anyway, I was trying to copy the 'Category' column and renaming it, and yes is does create and I can then later add it using the Layout View, but in the end it does not contain a drop-down list...

I'm sorry I might not have made myself clear somewhere, but that's how new I am to Access. Please to kill me ;) and please help me out here as I've spent the last 3h trying to solve this and can't come up with anything... :confused:

Kindest Regards
 
Go to the design view of the contacts table and click on the category field. Down below you will see the settings for the field. There are two tabs, it should be showing the "General tab." Click on the second tab, "Lookup" and you will see how they set the field to a combo box with the row source of:

"Personal";"Business";"Family"

Just duplicate what you see done there for your new category field.
 
Oh, superb! That's exactly what I needed! Thank you so very much!
 
OK, I must be really really stupid. I did everything you said. Added the new category to my contacts view, and when I click on it I get the down arrow as for a drop down list but no list :/ Despite having every setting exactly the same as the original Category filed.
Also there 'Edit List Items' option after right clicking the field like there should be only 'Equals Blank' and 'Does not Equal Blank'
What's missing? :/
 
Do you have the Row Source Type set as Value List?

Is the Column Widths set to the apporpriate width? 1" should work for most words. Longer words my need a larger setting.

Make sure your list of words are between quotes and seperated by a semicolon.

I built a list in Contacts table with the list: "This";"That";"Other" and it worked fine in the table as a pull down list of values.
 
Everything is as you say. I even tried doing a direct copy (copy/paste instead of manually rewriting) and replacing one of the existing tables and still have the same problem.
 
Are you right clicking the arrow instead of left clicking? right click gives you the option menu with cut, past, equal to and so on, left click should show your value list.
 
Yes, yes everything is right :) but under left click I'm not getting a drop down list and under right click I'm not getting the same options as in the original Category field (no edit list, only equals and so on)
 

Users who are viewing this thread

Back
Top Bottom