Recent content by Watergirl

Solved: Shortcut now works I opened my machine using the old hard drive, copied the original shortcut (Access/DB secured front end/workgroup) and pasted the shortcut on the Server. I closed the machine, opened with the new hard drive, went to the Server and copied the shortcut (the copy I'd...

No, I did not do anything else but change the names. I thought the 'Subform1' portion of your 2. was telling me how to link them/direct the main form to the subform. When I created the subform, I 'dragged it' on to the main form, and assumed that the link between them was created that way...

We're not that sophisticated - we manufacture wastewater treatment chemical compounds and each batch simply needs to come within a certain pH range. Batch testing is done when a batch is made, whether a tanker or a 55 gallon drum. If necessary, minor adjustments (adding a little acid or...

Using the percentage of the total weight is a great idea - thank you. I will correct the FK name as well, good point. I think I will remove the product sequence from the recipe table altogether and put those details in the finished product details table. (It is how a 'real' recipe would...

Not only a good article, but another excellent resource I was not aware of - thanks! Pam

My excuse: Sorry Mr. Larson - I should have deleted that from the subform before zipping the file - as I stated, I had tried many different ways (queries, combo boxes, list boxes etc.) that didn't work. From this database I began making a copy and using the copy to keep trying so as not to...

I have attached the database and would be overwhelmingly grateful for any help! I have the cost field in the ingredients table only because it changes every single time we buy more of any given raw material, which is at least once a month - and exactly why I've been asked to write this database...

Thank you for the fast response, RuralGuy. The ingredient table is joined to the recipe table through the recipe ingredients table. I'm sorry - I don't understand: why write a query when the 'answers' I need are already in two fields on the record of the ingredient table? The query I do have...

Whether I try a combo box or a list box, I seem to be unable to point to the item I want from my table and automatically include a second field from the same item's record. I am trying to add multiple ingredients to my recipe, and grab not only the ingredient, but also it's price. (I will then...

Thanks for the instructions, and the encouragement. Guess I'll keep chasing those bunnies . . .

I so appreciate your input, Craig. I would love to simplify the structure I have now, and to combine the tables. Your explanation makes a lot of sense. Thank you for taking the time to explain things so well, and to give me an idea db as well. I will spend as much time as I can today...

The foreign key field would be placed in the Recipe Ingredients (for my details) table and the duplicate information columns deleted?

The table 'Recipe Ingredients' is populated when I fill in the 'Recipes' form for each recipe. I'm pulling info from different tables but storing by each product, thinking I could retrieve it that way in reports, etc. Removing the space between the words is definitely one of the things I will...

I have been working on this database for several months now - in between all of the other jobs I am responsible for - using what I've learned from this forum, from the 'Access 2002 Bible', and lots of hit-and-miss, restarts and frustration. I may have OVER normalized . . . I'm running into...

Thank you, Doc Man! It wasn't my question, but the information you gave was so well presented that I, too, made a hard copy so I can go back and digest it slowly. Thank you so much for taking the time to explain things - patiently and thoroughly.