Recipe database - can I print a grocery list?

  • Thread starter Thread starter chelly
  • Start date Start date
C

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!
 
Chelly,
Can't find any access databases with a recipe template to be able to help
you. Sorry.

Jeanette Cunningham
 
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!
Click to expand...

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]
 
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
 
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
 
I am working in a MS template "Recipe collection database Template" but I can not get the reports : Recipes Card and SAhoping list. I saw a question by "chelly" back in Jan 5 2008 and an answer from "Evi", but I get stacked in the las part, which is: "Base a form on TblGrocery List 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 thatyou can print out our grocery list"
I could not get the idea. Can anybody guide me to those report.? Thanks a lot
 
Back
Top