Recent content by nwest

Thanks for the comments - I've tried the form route with no luck, this is the video that I tried to follow but it got a bit too complicated for me. I've not explored the recommendation that @Edgar_ has made, I will explore that. If it is not too much to ask, if someone can help with an example...

Hello, I need some help with this seemingly simple DB. I'd like to use this as a very basic log for customers and activities. I will import customers from another table, so it will be filled with relevant data (address, acount manager etc.). It will be also possible to amend everything via the...

@MajP Thank you very much for taking the time to explain this step by step with examples - this is hugely helpful. Certainly helped me a lot to understand the logic. Thanks! @arnelgp This is brilliant, thanks for the excellent example. Far more functional then I could ever design!

Thanks for your valuable feedback! DB is a different animal as you say, I'm just trying to find my way around it. Not to easiest, but good to know / learn.. Many thanks!

OK - I'm not disagreeing that the recommended route is the best practice. But it's too complex for me. And I think you are right, normally I'm an Excel user - and Access is a bit new to me. But here is the situation - stock will be checked manually every week, and adjusted. So I don't need...

Yes - unfortunately I have not received the help I needed from there. @Ranman256's comment already gave me some direction, so I can start playing with the queries. I'm not sure if I can get it right yet, but that's a start! Thanks

Hello, I've designed a very simple stock table - it has name of chemicals and quantity (in kg - lets say I have 100kg of all). What I would like to do is design a simple form to deduct chemicals depending on chemical mix (recipe). I know I need to create a new table for the recipes. For...