Recipe database - can I print a grocery list?

[chelly]

Hi there. My husband suggested using Access for my recipe database, and I
have the template for Access 2000 that is posted. It's great! Now I would
like to be able to select a few recipes and create a grocery list using the
ingredients. Is that possible? I don't really know how Access works at all,
as I've never used it before. Can anyone help? Thanks!

 

[Jeanette Cunningham]

Chelly,
Can't find any access databases with a recipe template to be able to help
you. Sorry.

Jeanette Cunningham

 

[John W. Vinson]

Hi there. My husband suggested using Access for my recipe database, and I
have the template for Access 2000 that is posted. It's great! Now I would
like to be able to select a few recipes and create a grocery list using the
ingredients. Is that possible? I don't really know how Access works at all,
as I've never used it before. Can anyone help? Thanks!

The short answer is "yes, probably" - but as Jeannette notes, not everyone has
that particular database installed. It may be simple, and it may require a bit
of work to create a Report based on the ingredients, and it might even require
redesign of the database.

Do you recall, or can you find, where you found the template?

John W. Vinson [MVP]

 

[DeltaTech]

Hi Chelly

To write a database programme to do what you need is quite a task especially
if you are new to database.

The following information is on the internet.
I do not sponser of have any connection with this site
However if you watch the complete demo you will find a section that does
exactly what you are looking for.

www.dvo.com/fulldemo.htm

If you want to continue with your own database I will be happy to assist
you.

Have Fun

DeltaTech

 

[Kasha]

Hi, I'm trying to do the same thing! I found a database template online that
I think will do the trick:
http://office.microsoft.com/en-us/templates/TC010186351033.aspx

 

[Evi]

To the recipe database, add 2 other tables, TblShop and TblGroceryList
Your fields
TblShop (so that if you wish, you can make your list for specific shops.
Make the first entry in this Any
ShopID (Autonumber, Primary Key)
ShopName

TblGroceryList
ListID (Autonumber, Primary Key)
ListDate (if you want to use this field - make the Default Value
Date()
ShopID (Number field, linked to TblShop. Give it the Default Value of 1 so
that it will automatically record 'Any' shop if you don't wish to use this
field)
IngredientID (Number field, linked to the Ingredients table in the db)
Quant (for the quantity you wish to buy)

Base a form on TblGroceryList with combo boxes based on the Ingredients and
the Shop table so that you can enter the ingredients and the shop you plan
to buy them from.

Base a report on this table so that you can print out your grocery list

Help available on doing any of this as requested

Evi