Search results

On your form (2frmRecipe) instead of putting the ingredient info in the detail section as individual controls, you need to make a subform and put the ingredient controls there.

For 'Reorder' would we want that to be a static value for each ingredient or calculate on the fly based on a global percentage? Like a global reorder threshold? Pros: A single setting for the user Cons: Some ingredients might not apply in that way. Can you think of any that might not work?

Great Start! Time to raise the bar. New Features: Users and Groups (Limit certain recipes to certain groups or users.) (Great for children or guests) Ingredient UPC/EAN Codes (The ability to assign more than one UPC/EAN code to the same general product and vis-versa) (A 5lb bag of white flour...

In order to streamline the process. I think we would need a precompiled table of incredients and their UPC codes. Or perhaps find a way to automatically retreive the information over the web. Does anyone know a website with a database of UPC codes? ** Nevermind, I found one. upcdatabase.com I...

I suppose it would be best to weigh it in, weigh it out. Maybe as part of the product, a precise scale could be included as an option. Then the database could see a difference in weight even if you only use 1/4tsp of something. Then the only time the conversion tables would be necessary is when...

Could this be accurately calculated simply by weighing the product before returning it to the cupboard? or would we need another table for calculating unit conversions? I.e. If you had 100 lbs of flour, lbs being the UOM, but you used 1c. Would you want to store the difference in weight in the...

Unfortunately, it's already been done. See webtender.com

I've given that a lot of thought also, but I have concluded that it may be near impossible; Probably not for the reasons you're thinking of though. I figure that a mojority of searches are carried out using terms and phrases that the user has chosen based on what they think they need. Another...

I like how David Eager laid it out:

lol. funny that you ask; I'm asking because I've thought about it, but I have no idea what I would do. I'd like to take a fairly simple idea and expand it to handle something unheard of, in a way that would benefit every citizen of the world.

Whatever you think. If you had all the time and money in the world, what would you do with a DBMS of your choice.

That's one aspect of Access that I really enjoy; You can do anything with Access/VBA and a couple tricks up your sleeve (with enough time and money, almost anything is possible). The only thing that sets Access apart from other solutions is scale. This works to our advantage as programmers...

Let's do it! ... Although, there are likely to be many versions of this already in existence in the form of commercial inventory management in grocery stores and/or restaurants, probably pre-populated with hundreds of thousands of upc codes and other skus. What specific features need to be...

If you wanted a database to do any one thing (regardless of price, resources and time) what would you want? ...and yes, I AM fishing for ideas here. All ideas welcome, including ridiculous ones. (As long as they relate to the topic of this thread) :) Thanks,

I was thinking about DB ideas, not DBMS ideas... but I did say rediculousness was okay, and that is a good idea nontheless

As long as I get a cut! :p

If you wanted a database to do any one thing (regardless of price, resources and time) what would you want? ...and yes, I AM fishing for ideas here. All ideas welcome, including ridiculous ones. :) Thanks,

Just happened to browse through this thread and... 1) Replying to an older thread to tell everyone the overall outcome of the thread is something I really apreciate too. 2) This thread IS very rich in information and has given me some insight that I've never considered. I've been developing...

I've had the same problem too. It only happened on certain datasheets though, which leads me to believe DCrake is on to something. I also noticed that if while scrolling, I shake my mouse side-to-side it makes the page scroll smoothly... weird. I haven't found any solutions either, but I'll...

If I use Trim(Nz([Service State],"")) as the Update To value in an update query then: If the value of [Service State] = "Ca " then it will return "Ca" or if the value of [Service State] is null then it will return a zls.. right? Am I correct to assume this?