Recent content by StephanK

@Mark We do not use a custom checklist for custom equipment. If the item is not on the machine they check N/A. This afternoon I was discussing the database with a colleague. We have several 'versions' of checklists like these: The operator uses a daily checklist. The technician uses an...

Attached is Marks database which I expanded with extra fields in T_MachineInspection and Tc_InspectionChecklist and I linked some extra tables. I also played with queries and reports to see what info I can get with this design. I added data to T_MachineInspection manually, but it's a bit...

Here are the business and database descriptions. It is probably not complete yet, but it describes most of it. Business description Snijder is a company that specializes in hiring out earthmoving equipment and concomitant technical services, operating around the globe. Equipment can be made...

Thanks for your replies. @static: Normalisation with queries is an option, but I think it's better to redesign my database. But your examples will be usefull when I move the data to the new design. @Mark: Your database is a bit complex indeed, but it makes a lot of sense. I will take closer...

Thank you both CJ and Mark for your recommendations and examples. I have changed my database design as you can see in NewRelations.jpg. I added an extra table for item values. For now we have only OK, NOT OK and N/A. We have more paper checklists with other options. Some checks have 4 or 5...

Hi Mark, Thanks for your reply. I redesigned my tables based on your recommendation. Is this what you meant? (see zip file) With 60 checklist items and 45 machines which are daily checked, tblRegistrations will have 2700 records a day. In one month we already have 81.000 records. How will a...

Here's the zip file. :) Edit: zip file contains screenshots of the relationships, output of query and how I would like the output.

Thanks for your reply jdraw. Because I don’t have 10 posts yet I am not able to add screenshots or links yet. But I will try to explain in clear text. First some background information. I have digitalized a paper checklist which our operators have to fill in. This checklist consists of 48...

In Access 2016 I have a table with results from a checklist. With a query I select those records where in one of 48 fields the text “NOT OK” is present. The output of the query is shown in a datasheet. 48 columns means a very wide datasheet, so I want to hide all columns where “NOT OK” is not...

Hi everyone, Scripting and programming has always been my interest. Starting with MSDOS in the 90s, building a website in HTML/CSS (with notepad), creating a stock system in Excel/VBA which started begin 00s and after some upgrades still in production, C# online course in 2011 and now, finally...