473,704 Members | 2,357 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Recipe Database

Bob
It's been quite a while since I've built an Access database, but I suppose
it's like riding a bicycle and it will all come back to me. But I'm not
sure Access is the proper tool for what I want to do.

We finally went through many years of cooking magazines and newspapers and
clipped out recipes that we might potentially want to use at some point
(there are a few hundred). Now I want to index them. I don't want to put
the recipes themselves into a database; I will keep them in hardcopy in a
yet to be determined number of folders.
But I want to go to the database and find recipes by type (meatloaf versus
chocolate cake, or maybe barbequed beef ribs versus pork ribs, haven't
decided all the keys yet).

Is this a good use of Access? Or is it overkill? Maybe I could do the same
thing with Excel. Any thoughts or similar experiences?
Nov 13 '05 #1
6 15631
On Wed, 13 Apr 2005 14:55:19 GMT, Bob wrote:
It's been quite a while since I've built an Access database, but I suppose
it's like riding a bicycle and it will all come back to me. But I'm not
sure Access is the proper tool for what I want to do.

We finally went through many years of cooking magazines and newspapers and
clipped out recipes that we might potentially want to use at some point
(there are a few hundred). Now I want to index them. I don't want to put
the recipes themselves into a database; I will keep them in hardcopy in a
yet to be determined number of folders.
But I want to go to the database and find recipes by type (meatloaf versus
chocolate cake, or maybe barbequed beef ribs versus pork ribs, haven't
decided all the keys yet).

Is this a good use of Access? Or is it overkill? Maybe I could do the same
thing with Excel. Any thoughts or similar experiences?


You can download a Recipe database from Microsoft and adapt as much of
it as you want.

http://office.microsoft.com/en-us/te...186351033.aspx
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2
Bob

"fredg" <fg******@examp le.invalid> wrote in message
news:1f******** *************** *****@40tude.ne t...
You can download a Recipe database from Microsoft and adapt as much of
it as you want.

http://office.microsoft.com/en-us/te...186351033.aspx
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Thanks for the suggestion, though this template is for Access 2000 and I
have Office 97 (I said it had been a while). So I guess the template won't
work for me.
Nov 13 '05 #3
Bob,
Give me a couple hours. I am in the middle of something else. I have
Access 97 and 2000 so I can run the conversion for you. It'll be at
http://home.comcast.net/~knogeek/downloads after 5pm or so EDT.
--
Alan Webb
kn*******@SPAMh otmail.com
"It's not IT, it's IS"

"Bob" <bo*****@nospam pacbell.net> wrote in message
news:P6******** ********@newssv r14.news.prodig y.com...

"fredg" <fg******@examp le.invalid> wrote in message
news:1f******** *************** *****@40tude.ne t...
You can download a Recipe database from Microsoft and adapt as much of
it as you want.

http://office.microsoft.com/en-us/te...186351033.aspx
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Thanks for the suggestion, though this template is for Access 2000 and I
have Office 97 (I said it had been a while). So I guess the template
won't work for me.

Nov 13 '05 #4
Tom
What I think you are asking for is a searchable filing system, not so
much a recipe database with ingredients and instructions. Something
more akin to a movie or music collection database. You might look at
one of those for inspiration.

As to Access or Excel - if you want to do complex queries (e.g., give
me all the meatless appetizers of Greek origin), then I think Access is
the tool. Excel will work, but will be messy.

That said, do you have the time and inclination to reaquaint yourself
with Access? If not, then a messy Excel spreadsheet is better than a
superior in concept, but unbuilt, Access database.

Good luck!

Nov 13 '05 #5
Bob,
Ok, I did the conversion to Access 97. The URL is what I said it is in my
other post.

--
Alan Webb
kn*******@SPAMh otmail.com
"It's not IT, it's IS
"Bob" <bo*****@nospam pacbell.net> wrote in message
news:P6******** ********@newssv r14.news.prodig y.com...

"fredg" <fg******@examp le.invalid> wrote in message
news:1f******** *************** *****@40tude.ne t...
You can download a Recipe database from Microsoft and adapt as much of
it as you want.

http://office.microsoft.com/en-us/te...186351033.aspx
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Thanks for the suggestion, though this template is for Access 2000 and I
have Office 97 (I said it had been a while). So I guess the template
won't work for me.

Nov 13 '05 #6
Bob & anyone else.
If you need this database in Access 97 I did the conversion and put it on my
blog. http://home.comcast.net/~knogeek/downloads.htm. No, not advertising,
I don't want money or anything. Just closing the loop on a promised bit of
work.
--
Alan Webb
kn*******@SPAMh otmail.com
"It's not IT, it's IS"

"Bob" <bo*****@nospam pacbell.net> wrote in message
news:rp******** ********@newssv r14.news.prodig y.com...
It's been quite a while since I've built an Access database, but I suppose
it's like riding a bicycle and it will all come back to me. But I'm not
sure Access is the proper tool for what I want to do.

We finally went through many years of cooking magazines and newspapers and
clipped out recipes that we might potentially want to use at some point
(there are a few hundred). Now I want to index them. I don't want to put
the recipes themselves into a database; I will keep them in hardcopy in a
yet to be determined number of folders.
But I want to go to the database and find recipes by type (meatloaf versus
chocolate cake, or maybe barbequed beef ribs versus pork ribs, haven't
decided all the keys yet).

Is this a good use of Access? Or is it overkill? Maybe I could do the
same thing with Excel. Any thoughts or similar experiences?

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
2646
by: Mars | last post by:
I have looked long and hard at Mr. Martelli's Borg recipe: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/66531 It is a very useful substitute for a Singleton, but I can't figure out how it works. _shared_state is never assigned any value, only self.__dict__ is assigend self._shared_sate's value - or rather (self.)_shared_state must be assigned a value at some point, otherwise the code wouldn't work(right ?). I have gone...
2
1327
by: Stephen Boulet | last post by:
I'm having trouble with the "optionparse" recipe in the cookbook: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/278844 This does not give me the results I expected (namely the arguments on the command line for each flag): #!/usr/bin/env python """An example script invoking optionparse, my wrapper around optparse.
8
1771
by: Michele Simionato | last post by:
I was playing with string.Template in Python 2.4 and I came out with the following recipe: import sys from string import Template def merge(*dictionaries): """Merge from right (i.e. the rightmost dictionary has the precedence).""" merg = {} for d in dictionaries:
16
2985
by: dudufigueiredo | last post by:
I have one folder containing mp3 files, the folder is: C:\My Shared Folder\Rubber Soul And the files are: 01 drive my car.mp3 02 norwegian wood.mp3 03 you won't see me.mp3 04 nowhere man.mp3 .. ..
0
1156
by: nuno | last post by:
Hi, I have set up a simple table structure for a recipe database. tables include a Master table, MealType, Meattype, Speed, and Ethnicity. I am going to write the front end of the app in vb.net which will query for criteria based on the meal types, meat types, speed, or ethnicity... For example: Show all recipe's that use beef and are chinese.
8
6644
by: Richard Hollenbeck | last post by:
I have a recipe database that I've been building but I haven't yet put any of the ingredients in because of a little problem of normalization. If I build a table of ingredients, all the recipes will have one or more ingredient(s), but no set number of ingredients, so that doesn't seem possible to normalize it. Any given recipe would use one, some, or all of the ingredients within the ingredients table, so I can't imagine an indefinite...
1
1647
by: Thomas | last post by:
Hi list! I'm struggling with a recipe from the Python Cookbook (2nd ed.) concerning XML-RPC. It's recipe 15.2 "Serving XML-RPC Requests", and since I thought it's a popular book some other folks might have discovered (and probably solved) the same issue. The recipe provides server and client code, and I get an error when trying the following client request:
2
1359
by: sofeng | last post by:
I would like to use the following recipe to transpose a list of lists with different lengths. http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/410687 Here is an example of what I would like to do: Python 2.5.1 (r251:54863, May 18 2007, 16:56:43) on cygwin Type "help", "copyright", "credits" or "license" for more information. , , , ]
0
8767
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9272
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9026
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8977
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6605
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5931
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4701
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2483
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2080
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.