Here are relation between these 3 tables.
I was also thinking about creating tblDefinedCriterias and when user will open some popup frmCriteriaInput and choose from combo International/Manufacturer then controls in the form would filled by values from tblDefinedCriterias using Dlookup function...
In my frmProtocol I have sfrmMeasurements. I was thinking to have also sfrmCriteria so that visual comparison of values would be possible (maybe also conditional formatting).
There would be also similiar presentation in the report.
So far, I have already only table with predefined criteria from standard and from producers. There are not going to be much data here and, as you see below:
For custom values I don't have real data now. My idea was that user can choose predefined criteria or type it by his own.
Dear Folks,
in my DB i have tblProtocols (it stores informations/measurements collected by technicians), for each protocol there should be criteria to check if the measurements are OK or not. There are several types of criterias acc. to which we can evaluate it: 1. International Standards...
OK, all in all I had to confronte my ideas with pragmatism and hints from you. I decided to omit Pole FK Control when duplicating the record (code below). At the same time I made validation in the event BeforeInstert on form level (check if user fill fthe PoleFK field) on on control level (check...
@arnelgp Yes, this is a solution. But I am dissapointed that I need to use somekind for the "trick" for very common functionality. I feel that once again I am going in opposite way than Access seemed to work.
I took you solution as an example and make some changes in code, so that it is better understand by me. I paste it below just for information.
Moreover I check if measurement already exists for specific PoleFK exist in the in the event BeforeUpdate in the form level. For duplicating or for...
Thanks All for ideas, I need to evaluate given propositions.
I have been learning ms Access for 2 years and every time there are some new things to learn. From one hand it is great because it is constant learning, but sometimes i am thinking if it is worth to invest time in it or to switch to...
I am able to duplicate record using below code, but when I display the new record it is already inserted and BeforeUpdate does not work to validate PoleFK Field.
Is I write proviously, my idea is to duplicate record and present it user for further edit.
In this situation my record is not...
@arnelgp
I found some issues with this method.
Seems that it copies data and control names, not field names. Therefore, when controls in continous form and input form have different names, then this method does not work and error appears. Moreover having validation rule for controls also...
Hi Folks,
I have continuous form which shows the result of the measurements made by technician. You can add measuremnt by clicking Add Measurement, then Pop up form appears to input data. I want to add possibility to that user will duplicate selected record and further edit/adjust it in the same...
Thank you for your answer it shed a light. I also dig into the forum and found out that BeforeInsert might be very useful.
My next concern is what if I have subform in which some of the buttons are showing/hiding depends on the specific characteristic of chosen serial number. Normally I have...
At the biginning of the discussion i was thinking that passing PK from listbox and use it as FK is sufficient to create a new record. I was not thinking about validating the rest of the fields. I need to think about it.
Can you please explain way to use Before Insert?
Is it not enought to pass...