I think there are problems in the structure of the tables involved in the orders as, in my opinion, the structure should be:
tblOrders
OrderID
OrderNumber
OrderDate
SupplierID
etc...
tblOrderDetails
OrderDetailID
MaterialID
MaterialQuantity...
In the attachment you will find an example.
However, the first thing to do is learn how to manage the properties of the various fields of the tables and in particular:
Size (if the type is Text, don't always leave 255 set as you almost always won't need all those fonts (this is to avoid...
You say 100m and 300m combination is allowed but the 300m event is not in the event list (100M, 200M, 400M, 800M, 1500M, 3000M, Long Jump, High Jump, Shot Put (5.00Kg) , Thread (1.5Kg), Javelin (700 gms), 4x100M & 4x400M Relays)
After "StrataPlan_T" there is an extra point the correct code is the following
Me.Filter = "[StrataPlan_T].[StrataPlanNr] like '*" & SearchText & "*'"
Me.FilterOn = True
You have to explain step by step in detail how the activity you would like to register in the database takes place.
Also you should say for each column:
- what kind of data it should contain
- if the entry is mandatory
- if the data must be unique
You attach a sample file so we can see what's going on and make it easier for us to help you.
Furthermore, it seems, from what can be seen from the structure of the two tables T_Contract and T_ContractInfo, that there are problems in their structuring.
Surely first of all you have to review the database structure as it is not correct either from the point of view of Field Properties or from that of Normalization.
In the attached file you will find an example of how it could be done.
However, the first thing to do is learn how to manage the properties of the various fields of the tables and in particular:
- Size (if the type is text, don't always leave 255 set as you almost always won't need all those...
The search through Ctrl + F is already provided on HTML pages just press Ctrl and F at the same time which opens, usually in the lower left of the page, a text control that allows you to enter the text to be searched.
Meanwhile in the attached file there is no query or control named txtTotalQuantityinStock, you should say where you entered the IIf (...) control statement they suggested.
Also remember that it is very important to correctly set the various Properties of the fields of the tables such as...
If you do not attach a file with a minimum of data, replacing the sensitive ones, it will be difficult to understand what happens and consequently help you.