Search results

I don't think the fact that the form you want to open has subforms is a problem. The way you open it is more likely a problem. Where did you place the button to open the second form? If it is on the first mainform, your code won't work. On the subform there can be multiple CustomerIDs so...

I do not understand how to use cascading combo boxes when only one field is involved.

The first 5 positions do not represent anything. Examples: ProcuctCode BE_0010027/1 BE_0010027/100 BE_0010032 BE_0010034/1 BE_00100424/1 BE_00100424/100 BE_00100444 BE_00100644/1 BE_00100644/100 BE_00100644/50 BE_00100644/500 BE_00100654/1 BE_00100664/1...

I have a large table (200,000+ records) of products. I can therefore not use a combo box to select a product. I have created an extra form where the user can select the first 5 positions of the product code via a combo box. Then the user selects a product whose product code starts with the...

It depends on whether a contact can respond to a communication more than once. I can imagine that a contact will respond to your response again. Then the model with three tables falls short.

Crossposted here https://www.helpmij.nl/forum/showthread.php/965826-Theoretische-vraag#post6338680

Use the after update event on Stop_Current: me.Fair_Value = me.Stop_Current

CJ_London's solution will work in an update query. If there are numbers that do not start with 0, add a condition to query. Like: WHERE Left(Telnr) = "0"

Running totals are easy to use in reports and froms. Make a form or report with the union query.

Welkom Geert.

I think the principle remains the same. Instead of a first combo box, you use a text field. If a value is entered there, you adjust the rowsource of the combobox based on that value. As mentioned, it is difficult to offer help without more information. An example database would also help.

Double crossposted https://www.accessforums.net/showthread.php?t=86715 and https://www.helpmij.nl/forum/showthread.php/965717-VBA-kopieer-gegevens-van-de-ene-database-naar-de-andere

What expression are you using? You have got several suggestions.

IIF is your best friend SELECT Chemical, IIf(IsNull([MeltingPoint]),"N/A",[MeltingPoint]) AS MeltingPointShow FROM tblChemical ORDER BY IIf(IsNull([MeltingPoint]),999999,[MeltingPoint]);

What do you want to accomplish with this? You are entering data into your table, so what do you want with that field?

FYI crossposted here https://www.accessforums.net/showthread.php?t=86667

Does your table Samples_List contains all possible intervals? And are the intervals you are missing not related to any SampleTestedFor record? In that case use LEFT JOIN instead of INNER JOIN.

I did not fix anything. I just set enforce referential integrity for every relation to yes. Read carefully.

I think some of your relations are wrong. You also need to enable the relation property "enforce referential integrity". That will keep your data clean. It also makes clear which table is on the "1 side" of a 1 to many relation and which on the "many side". I did this for all (but 1) relations...

Why are the fields short text in the table? I think that might be the problem.