Search results

  1. P

    Creating a cheese production record from scratch

    Hello all. @JMongi , you're absolutely right. So many tutorials out there show pretty much the same regularly used examples, it's hard to transfer all that knowledge to specific industry-related situations. In my case, I think I would be a much better learner and would adapt that knowledge...
  2. P

    Creating a cheese production record from scratch

    Wow, thank you all for your help. If anyone is over in Ireland for a visit, please do call in Macroom, County Cork and I'll give you a VIP tour of our cheeseplant! Mike60smart, you've given me alot to think about and work on! Plog I'm starting to get it now, i was trying too hard to tweak...
  3. P

    Creating a cheese production record from scratch

    Hey plog, I'm still struggling, first tried to focus on the weights table, then the vats table you suggested, but got overwhelmed so I thought i'd start with this very basic tip you gave me. I feel like an idiot for still not fully understanding it (see attached database that i've tried to...
  4. P

    Creating a cheese production record from scratch

    Yes definitely! The formula and formula steps are what we call here SoP's (standard operating procedures), well compared to Clairol we are tiny (only talking about 6 full-time employees!) I think what doesn't help is that I've been thinking in an "excel/spss" manner, partly because I have a...
  5. P

    Creating a cheese production record from scratch

    Pat, thank you for your valuable feedback. I did as you suggested and also having in mind what plog is recommending, i'm starting to have a better picture of what I'm doing (see attached screenshot of my spreadsheet items, any comments welcome). So i clearly see that I have some "checks" and...
  6. P

    Creating a cheese production record from scratch

    I'm so grateful! Will work on it for a few days and get back to you. Even though i was close to finishing with this record, I prefer to do things right, I know I was late to seek for help. Thank you
  7. P

    Creating a cheese production record from scratch

    You are all so kind, I feel stupid for not asking questions before attempting all that, I've been focusing on learning VBA and skipped the most important part, which is to get the tables right to begin with. Trying to reorganise everything now... I want to focus on two particular issues, which...
  8. P

    Creating a cheese production record from scratch

    Thank you so much, really appreciate the time you devoted for this response, I will study and then come back for more questions!
  9. P

    Creating a cheese production record from scratch

    That's my main issue I'm afraid, I haven't created any relationships regarding that table. Showing you two screenshots of the table, in capture2 you can see exactly my problematic... Attaching you the database if it's any help too, the said table is: tbl_mozz_production_record and it is...
  10. P

    Creating a cheese production record from scratch

    Hello Minty, thank you so much for the prompt response, it's my fault I didn't clarify, the attachment in OP is of the actual sheet of paper we use currently.
  11. P

    Creating a cheese production record from scratch

    Hello forum, new user here. I'm a cheesemaker and having some (very) basic knowledge of programming, I offered to create database for different paperwork that we keep on a daily basis in the cheeseplant. The main goal is for the cheesemaker of the day to input all specific data using a form...
Top Bottom