Recent content by SamLis

Hi, yes of course! I thought, since my criteria is only build from boxes containig data, I don't need a "Between" This covers all : If 2 boxes are filled, is automatically ranges between the 2 values, if only one is filled, the other one is not taking into consideration, I just label one...

Hello, Thanks a lot, now it's working.

Hello, Thanks for the quick response, one more problem, if only one is filled in, it gives me from or to, without the value? Search "1" result 2,3,4 I want result 1,2,3,4

Hello, I have a form with textboxes and comboboxes and a Button, when button is clicked, a new query is made, with criteria based on boxes on form. For example this one : What would be the statement for a range between to comboboxes. BoxID I have 2 comboboxes (cmbBox1 and cmbbox2), show...

Hi, How do I refer to the ctls in subform? instead of me! ctrls? How do I do : Me.ctrls and subform ctrls ? thanks

Private Sub Form_BeforeUpdate(Cancel As Integer) ' This procedure checks to see if the data on the form has ' changed. If the data has changed, the procedure prompts the ' user to continue with the save operation or to cancel it. Then ' the action that triggered the BeforeUpdate event is...

hi, The data was imported from excel, I assume that the empty fields are Null? I found some tips of changing the default value : "" allow zero length but ths not working for me, probably because of the data already in the table? Or is there a way to validate this on form level for new...

Hello, I have 3 tables tbl1 : NameID Name tbl2 : CatID Category tbl3 : ProdID CatID NameID Remarks How can I avoid duplicate records in tbl3? Since remarks can be Null? product is later used in tblInventory... thanks, Sam

Hi, Thanks, I will keep the the volume table, since I can't predict if people will divide to new volumes etc. Then I just need to design a query based on tblBoxcontents? So I can filter/search on : What's the content of box A? Answer : Sample A, 33 cl; Sample A; 1 L, Sample B Where can I...

Hi, 1)SampleVolume are fixed volumes ( like bottles Cola; 33 cl, 1 L, 2 L) that's why I put them in a separate table. one sample can come in different volumes, but different samples can have same volume 2)If I understand your tblBoxContents : One box can have different samples, but does it...

Hello, I want to validate if my structure is correct : I need a database of Samples (liquids) that come in different volumes. They are stored in boxes, however different volumes of the same sample can be in the same box. Also one Sample,in one volume can be spread over more boxes. One box can...

hi, tblName : NameID Name tblSubject : SubjectID Subject tblClasses : SubjectID (label Teacher) NameID (Label Student) Name_1ID What it does, on a certain subject Person A is Teacher, Person B Student, however for another subject B is teacher, etc .... This works fine, but I'm struggling...

Hello, I worked and searched tutorials, this is what I end up with. 2 questions : 1) My SearchForm, I want to filter my records based on comboboxes : like Technique, EpitopeGeneral and Epitope Detail? 2) I changed my multivalued field Species Reactivity to a junction table (recommendation on...

Ok, From the questions you have to ask yourself (from my test data) : Indeed I have values repeated in a column, that's why we split it up in multiple tables with a PK related to tblNanobodies with the FK. Indeed I have items that share the same root ( this is a nice way of putting it)...

ok, thanks. Do you see what I mean with Adress Analogy, why I made this Extra tblNanobodyGeneral I found this solution in a Normalization tutorial, the Adress was an example there, basically they said if non key attributes are dependent on each other, move them to a new table with a PK ...