Search results

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...

Some questions/ advice: 1. Do not use your Customer Code as the PK ID for the customer. I assume this is a user/customer-facing code they might recognise., use in communications - invoices etc 2. Do you expect any cases where a customer may change or be both a retail and a wholesale customer? 3...

In the absence of any further information / analysis concerning the attributes associated with the types - yes. A consideration that might influence the decision is how simple it may be to add another type of account. Perhaps with a single accounts table and types, and appropriate attributes in...

The development of a conceptual / logical model is a step along the path to the physical model. ER / EER models are used to represent these models. The representation of entities involving the ISA construct (is a type of - super/sub entities) is valid at the conceptual / logical stage. They are...

Yes - Excel automatically imports a csv, where you specify the delimiter, to a table (with colouration and header filters) To remove the "table" designation - highlight the table and right-click --- the menu shows "table" option - try "Convert to Range" option. Is that what you wnat?