grocery list in access
I want to make something so I can make a grocery list easy and just print it
off. I am guessing I would have a drop down list, which would be a list of
tables, then select item from the table. For example, first I want milk, so
in the first drop down list i choose dairy, then select milk. Is there a way
to do this and have an add button so it adds it to a list (report)?
Leave a comment...
- 5 Comments
- Is it best to have a list of tables, and then the item?#1; Mon, 31 Dec 2007 00:02:00 GMT
- <pdb.ms-access.questionfor.info.none.com> wrote in message news:EHuzb.213354$Dw6.777468.ms-access.questionfor.info.attbi_s02...
> Is it best to have a list of tables, and then the item?
Just have your mom make the list.#2; Mon, 31 Dec 2007 00:03:00 GMT
- Just be an ass. Why waste your time posting garbage? So I am trying to learn
Access and doing something that may also be used for other things. Whatever,
get a life.#3; Mon, 31 Dec 2007 00:04:00 GMT
- Actually, Paul, you have a good idea, one that I tried to set up
You don't actually need separate tables for each category (e.g. Dairy
items, breakfast cereals, condiments, etc.).
However, good relational DB theory says you should have a table of
categories (with a key, say an alphabetic key), and a table of items
(item name, category key). The item table could also have a key (for
Your form could have the following:
Combo box or list box with the categories. When you select a category,
a second combo box or list box could be filled with the items in that
category. When you select an item and click an OK button, you could
copy the item into a table of items (starts as empty). The contents of
the table could be shown using a third list box, which could be
Requeried after every addition (to keep it up to date).
You may also find it useful to have a mechanism to remove items from
the displayed list (and the underlying table), remembering to again
requery the data source for the list box after deleting.
Perry Zamek#4; Mon, 31 Dec 2007 00:05:00 GMT
- I already have one made up. It has dropdown list of groceries (not by
category), but if you enter something that's not in the list, it asks
if you want to add it to your lookup table. It also has a field for
prices and even the aisle in your supermarket, so if you want to take
the time to enter the aisle numbers for each one, it will sort the
printed list by aisle next time. If you'd like to see it, email me
and I'll send you a copy.
pdb.ms-access.questionfor.info.none.com wrote in message news:<U8xzb.411987$Tr4.1186893.ms-access.questionfor.info.attbi_s03>...
> Just be an ass. Why waste your time posting garbage? So I am trying to learn
> Access and doing something that may also be used for other things. Whatever,
> get a life.#5; Mon, 31 Dec 2007 00:06:00 GMT