Recipe database - can I print a grocery list?

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!
 
J

Jeanette Cunningham

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

Jeanette Cunningham
 
J

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]
 
D

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
 
E

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
 
Joined
Jun 9, 2020
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top