Recent content by GustavoGanzo

Hi team, I got another question - naturally. My new mission is a report. Relatively trivial, I thought - but I am struggeling to reproduce the effects I achieved with my frmOverview. The idea is, that each page of the report discplays one substance, with the allocated Hazards, Precautions and...

Thank you June7, this makes sense to me. Appreciate the insight on the table widths, thank you again!

Thank you for explaining this in such detail, I understand what you did here and also your updated diagram. Also appreciate the recommendation on the PK/FK controls, will follow your advice on that!

Thank you for making it easily understandable - I did as you suggested, and it works fine. Logically, it now shows the IDs of the GHS, hazards, PSA etc. and not the text. How would I resolve that in the Overview form? Done, and changed all ID_Chemie to ID_Substance, since it means the same...

Thank you. This allows me to only have one-to-one connections, to my understanding. But one substance can have many hazards, thats why I had the t3 tables in there to allow for substance 1 to have hazard 2,3,4 etc. Or do I misunderstand you?

Thank you The_Doc_Man - lets hope all our projects take the path of your grandkids and make us happy on the long run ;)

I attached an english version and cut down to the crucial tables. @June7 Understood. I tried to use subforms in the f1Overview table, and it presents the data from the subforms in a tabular view, which is fine, but if I try to append to the subforms (f3Substance_GHS for example) it gives back...

Hi team, I am working to create a database of our cleaning chemicals. They are storred in various containers (bottles, buckets, tanks, etc.) and have different safety requirements (gloves, googles, specific tools, etc.). They are also storred in differet locations, e.g. not all soap is in the...

Good evening, I am relatively new to MS Access, and more "at home" with other MS products. But google & youtube have helped! I am here, because of a database that doesnt do what its supposed to do, and a strong believe in collective intelligence. Hope you are having a great day! Gustavo