adding data to data base

[Kevin]

After the data base has been created, how do you add more
data? This table was created with a drop down menu and I
need to add more items to this table. I have checked in
tables/design view but then I get stuck. I can type the
items that i need but i doesn't save it. I want to
permanently create additonal items but I can't figure it
out. Any suggestions?

 

[Ken Snell]

I assume that you're trying to enter data directly into a table? This is not
a recommended practice...use forms for interfacing with your data.

However, to add data to a table should be relatively easy. When the table is
open in datasheet view, at the bottom left are a series of navigation
buttons. Click the one that has >* symbol on it (one at far right). That
will "move" you to a new record for the table; then type the data directly
into the textboxes.

If the table says it can't save the data that you're entering, then you may
be trying to enter data that doesn't properly provide the primary key, or
duplicates an "Indexed - no duplicates" index in the table, or any of a
number of other reasons. The table's error message should give you some idea
of what the error is.

You are describing dropdown box for your table -- word of advice. Along with
not using a table for data entry, do not use the "Lookup" feature for
tables's fields. What you see in the table when viewing it is NOT what is
actually stored - e.g., you use the Lookup to show a person's name when
you're actually storing an ID number for the person. You won't believe how
many people post in these newsgroups because their queries cannot find
data - when in actuality their queries are looking for the wrong data.

If this doesn't get you to a solution, then post back with more details
about
-- what is the table structure
-- what occurs when you try to enter/save new data
-- what are you doing (exact steps) when you try to enter/save new data

 

[John Vinson]

After the data base has been created, how do you add more
data? This table was created with a drop down menu and I
need to add more items to this table. I have checked in
tables/design view but then I get stuck. I can type the
items that i need but i doesn't save it. I want to
permanently create additonal items but I can't figure it
out. Any suggestions?

It appears that you are yet another victim of Microsoft's misdesigned,
misleading, obnoxious "Lookup Wizard".

Your table DOES NOT CONTAIN A DROPDOWN MENU.

It contains a numeric field, linked to some other table (the "lookup
table"); the actual contents of your table are concealed from your
view by this "combo box".

To add new data to the combo box, you need to add a record to the
lookup table (or, if you chose a "List of Values" combo box, to that
list of values).

This is one of many reasons I and many other developers recommend
against ever using Lookup Fields. Using lookup TABLES - and combo
boxes - is perfectly good technique; but use them on a Form, not in
your table!