Search results

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.

I totally agree with Galaxiom. You will first need to get your database design in order. The second table should only contain the key from the first table and no other fields from that table. Working with compound fields is also not a good idea if the underlying data is already elsewhere. You...

Use the DSum function. YourVar = DSum("InitExposure_Gross", "YourTable")

First make sure the recordset contains unique persons only.