Recent content by GaP42

@sergio vieira Your requirement is that the listbox display of files needs to show just the filename and not the path. You have a field in some table that holds the path to the document, which, because it is the path, incorporates the filename. Presumably you get the path using a filesystem...

You have incorporated the VBA provided by @arnelgp in post #7, #9. Why not look at the returned values from the call to the function in your code before inserting it into the SQL? Set up the variables so you can see them in your VBA before using the SQL and reference them in the constructed SQL...

You are passing the string "date" to the function fnFinancialYearStart which is expecting an actual date.

Correction? to: SELECT A,B,C, IIf(Nz(A, '') = '' AND Nz(B, ''), C, IIf(Nz(A, '') <> '', A, IIF(Nz(B, '') <> '', B, C))) AS ABC FROM YourTable;

Something like: SELECT zzzjunctionTbl.ClassID, zzzjunctionTbl.TeamID, zzzjunctionTbl.EmployeeID, IIf((Nz([ClassID],0))=0 And (Nz([TeamID],0))=0,[EmployeeID], IIf((Nz([ClassID],0))>0,[ClassID], IIf((Nz([TeamID],0)>0),[TeamID],[EmployeeID]))) AS Result FROM zzzjunctionTbl; The function NZ is used...

An interesting article about the design of AI that incorporates the use of "rewards' to the LLM (so that it improves) has a consequence. if the objective is to achieve a reward, and the LLM can get there more efficiently by lying/cheating then it can take that course. If a punishment module is...

In addition, I would also like to suggest improvements to the relationships diagramming tool. It is frustrating that you cannot set up separate subject area diagrams showing just those selected tables and relationships needed to focus on with a particular area of work Multiple annotation blocks...

My question Was in relation to the process of scientific enquiry and the papers/claims made by scientists generally. Reporting results and drawing conclusions in such papers are typically restricted to the hypothesis being tested and, where further, more speculative conclusions are stated, are...

Yes - or it is part of the construction of that customer facing identifier - often with a year/ alpha prefix...

I have a different view on the relationships: as stated by Redstick it is not a genealogy database, however associations between members need to be supported to allow recognition of partnerships - meaning generally teams. Family associations between members (may) also need to be recognised...

Speculating it might be a customer-facing transaction ID and not the PK for the table.

From https://learn.microsoft.com/en-us/office/vba/api/access.application.dmax (Criteria is optional) Place your arguments in the correct sequence Increment the variable after getting the max value

What is the expression you are using? What type of field is RecordNum? Integer? Autonumber?

Now what lies were they? One like: In July 2012, Syrian Foreign Ministry spokesman Jihad Makdissi stated: "No chemical or biological weapons will ever be used... All of these types of weapons are in storage and under security and the direct supervision of the Syrian armed forces and will never...

It was perfectly OK for the Assad regime to use chemical weapons to kill their opposition? Not disturbing?