Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Large Access Db

  • Please log in to reply
1 reply to this topic

#1 scubab


  • Members
  • 68 posts
  • Local time:08:01 AM

Posted 11 June 2007 - 09:43 PM

I'm trying to design a very large cook book on my computer. It will consist of recipes that I've personally typed up as well as recipes found online. I want to have the actual recipe saved as a Word document on my computer or a link to a website if I find one online that is interesting. I want to be able to have these fields in Access: Recipe Name, Ingredients (possibly one cell for each ingredient), Total Time (prep and cooking) and a link to the necessary place. I would like to be able to design a query that would allow me to type in my ingredients that I have handy and the query will find only recipes that have those ingredients in them. I'm aware of parameters and such, but I want to be able to type in all my ingredients at once. So, for example, if I had chicken and cheese and guacamole I would want this recipe to show up http://www.online-cookbook.com/goto/cook/rpage/00183D . Would this be achievable? I'm aware that www.kraftfoods.com has something similar but I don't like it. Thanks!

BC AdBot (Login to Remove)


#2 skennedy10


  • Members
  • 1 posts
  • Local time:06:01 AM

Posted 24 June 2007 - 09:24 PM

I think it would be simplest if you had a form with a checkbox for each ingredient. Behind each ingredient would be a number, such as chicken = 1, beef = 2, pork = 3 and also for the other choices, such as tomatoes = 11, okra = 12, rice = 21.

As each ingredient is checked off, that value becomes a filter from your selection of "recipes," which in your case is actually URLs.

It is not obvious from your post as to what your level of using Access or Access VBA might be. Also, I just joined this forum now, so I am unfamiliar with the level or type of answers here. Experts-exchange is my usual haunt, and I usually am asking questions, not answering them!

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users