Tags: access, database, drop, grocery, guessing, itoff, microsoft, mysql, oracle, print, sql

grocery list in access

On Database » Microsoft Access

2,734 words with 5 Comments; publish: Mon, 31 Dec 2007 00:01:00 GMT; (25078.13, « »)

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)?

Thanks Paul

All Comments

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

      myself.

      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

      indexing/sorting).

      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.

      HTH

      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