Search results

The record source for the contact dropdown must include the customerID (?). The CustomerID is used to filter the record source. To do this ensure that in the query supporting the record source that the CustomerID criteria is set to something like Forms!frmCustomer!cboCustomer

On the subject of going Paleo? (my interpretation) - an amusing sidetrack to show the talents (or lack of) of some people I have an association with in Fathomverse (citizen science project).

Aaaegh! - the second part was meant to be directed to the OP.

Apologies CJ - @LarryE was who I should have referred to :oops::oops: You should at least start with a query to return these records - guessing but something like: (use is null / is not null in criteria as needed) That is then used as the basis for a totals query: Repeat the above for...

What query have you attempted using the data? Have you used the Query Design feature? The application of the criteria in Query Design would suggest 4 separate queries and corresponding reports based upon those queries. The database as supplied shows no relationship defined between the tables -...

A couple of things: 1. txtCurrentDate - is the name of the control which is the date the last audit was completed? It would be a simple matter using the OnCurrent event of the form to perform a datediff calculation to determine the days elapsed between the txtCurrentDate and Date(): or more...

Labelling requirements for processed foods are very involved. Don't know about "E" numbers. In Australia and N there is this enforceable standard: Food Labelling Standards: FSANZ Explicitly indicates ingredients are listed by weight (including added water), and any known allergen is listed...

"Sugars" come in various forms - Fructose is one (a naturally occurring sugar in fruit, honey), Glucose, Galactose, Maltose, Sucrose (commonly table sugar) are others (eg Ribose). The issue is excessive addition of sugars to the diet, the high calorific value of sugars and how easily it is...

There are many ways in which the sort order on a form can be changed using different types of controls - eg a toggle, or by clicking on the heading of a column in a continuous form - to some extent it is about user preference. However using a combo box as you have proposed you need to use the...

Fascinating to see how AI can be applied in the highly professional/expert medical field and how readily embraced it is - driven by cost (patient/ service costs) and time (service/expert availability). Full autonomy may be a while off - da Vinci is generally used in the theatre from a console...

Some of you here have developed a fondness for Chat GPT and its capabilities, others have decried the failings providing sensible output and lack of originality. You might like to consider the capabilities shown by machine learning in conjunction with Chat GPT is this article out of John...

You might appreciate this : Monaco SQL Editor

You said Did you do this as a conditional format rule? If so why can you not remove the rule? If it is not a conditional format rule how did you set it? Are the other separate conditions on some columns set in the same manner?

next step: See above re Pat's suggestion re nulls and ZLS, / and post #6

You can use the "point and click" conditional formating:

Enabled in my access and displays the SQL: Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20100) 64-bit what is your version?

Suspect the "grey" space between controls is adding to the space seen in print preview - compress the text box controls so no vertical spaces between them and check print preview again.

As someone who is familiar with the taxonomy of living things (but defer to your expertise, especially wrt herbaria and the specific data requirements) and with db design I do have concerns with the apparent flat file db structure (50 field items listed and 6 records) you have provided. I do not...

The text box Stat should not be bound. Set its value using the expression builder ("expired" or "not expired") using an IIF statement that depends on the value of DCOUNT. Lookup the DCOUNT function and its parameters applying the appropriate criteria for selecting the records of interest, the...

Why not do a DCOUNT on the set of records that your subform is showing to test if the subform records have any status value <> "Expired". If a count > 0 is returned then the STAT in the Sheet1 form stays as is, else change it to display "Expired" on the Sheeet1 form (not stored in the underlying...