Search results

@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?

willing to try this one? BIVACOR Heart

50,000+ forklifts operate in the US as FCEVs (Hydrogen Fuel Cells - the electricity to run the electric motor is produced by the fuel cell). ' Refueled in minutes and require less maintenance. Various sources for making the Hydrogen. Availability of vehicles, range and refueling stations - ...

You will still need to ensure that the text string you use as a filename from UnitCard only ever contains valid characters for a filename, or substitute characters that can cause problems. Just sayin. Happy that you were able to resolve your core issue.

You can run a routine to cleanse the Unit name of any illegal characters before assigning the file name. Adjust as needed. Public Function fStripIllegal(strCheck As String, Optional strReplaceWith As String = "") As String ' PURPOSE: Strips illegal characters from a string that is to be used...

Hey @Chuckieinoz welcome to the forum! 1. Set Option Explicit after option Compare Database - it will help with your debugging - in every module (can be set as a default). after setting it - try compiling and you will see: 2. You have not Dim'd the variable uFound or aProfile: Dim Ufound As...