Recent content by patapotato

I know its not an easy problem to wrap your head around but I can't upload the actual recipes here. I have made another excel file which contains recipes for 4 different products. Depending on the product, the tables that are needed to display are different. Those are just 4 different examples...

Users won't be adding ANY new formulas. All the formulas we have were provided a long time ago. Users only require to change certain coefficients within those formulas from time to time on a run by run basis. I will have to enter all formulas manually myself. The last time a new recipe was added...

Fortunately, the formulas don't need to be changed by a user. And if they did, they would need to be recorded under a new recipe anyway. However, they do change between recipes and chemicals. The formulas themselves, as well as the coefficients they use, are different for every chemical-recipe...

I think I will be needing both a batch report, and a form in this case. But I am only busy on the form atm. Both I am aiming to do in access. There needs to be an interactive form for the operator in which they can both, view all fixed and pertinant information to the recipe they selected for...

Thx for the clarification! There's a lot for me to think about. Fortunately, there are no instances where multiple ingredients are used in one operation in the recipes we have. There are many without any though but that is not really a problem I think. One thing I was wondering in regards to...

Thx for the info! A couple of questions: First, regarding the Weightmaster, I think you mentioned you just use a factor to multiply with to get the right weight for a given batch size. Like 120 (kg?) in the sample. So like 120 *0,4858=24,7 for Item 0211H for example? Obviously there are some...

OK, I made a sample file for those Excel tables. I'd say about 80% of all recipes can be converted to be somewhat in line with this layout. Sometimes there is an additional misc calc table, sometimes what's calculated in there is different and sometimes there are extra or omitted elements in...

Unfortunately, keeping the excel files in any format is not an option. Again, legal reasons. There is no intense time pressure, but as far as management is concerned getting rid of them is the whole reason for wanting to streamline part of the process (if it were not for the option of getting...

Actually, yes that is quite similar to what we have here. In my case the instructions and the weights are divided into two seperate tables (first weights, then instructions below that). About half of the weights are calculated by multiplying with a factor based on the correct ratio for a given...

I might have to give some clarification here. The example of cooking recipes was just an example to illustrate the concept of the database without making it too technical, but I guess that backfired somewhat. The actual use case is chemical production. All units are in kg (batches are a minimum...

Ok, I found the Stock database. I think that is the one you mean? I'll have a look at that one.

Do you know where exactly I should search for that? Or perhaps the title of the post? I'm new here so not sure how exactly this works. I used the search in the top right corner for 'recipe' but didn't find one. Maybe I just missed it.

If I expose all the constants used in the formulas then I imagine I can reduce the amount of queries I need by quite a bit. Yes, most likely about 20-30. The problem is how to store them correctly. Some are already exposed as named fields with some meaning in the excel files. But many are just...

Hi, new member here. I have a bit of a particular task I need to do and would love some input. I've not been using access for very long (3 months) so I am still figuring this out as I go. The actual application is very technical so I am going to simplify it a bit for this context. I am...

Hi there! I'm pretty new to access. I worked exclusively in datascience and research before, now I also have to deal with database design and management on top of that. I've only been using access for 3 months now and had never used VBA before. But I do know python and R pretty well, so it was...