Search results

While you have begun to identify some of the key tables for the business data you need to store, there are some additional considerations: like - as a department in the hospital do you expect your patient data to be sourced from the patient administration system of the hospital, or will you be...

Duplicate declaration in current scope: Dim userName As String Dim DtTaken As Date Dim SQL as string in: Private Sub CheckWinCondition5() of frmMain Repeat of same issue in frmMainPolish Thanks, appreciate putting it out.

As a novice with Access you will be taking a learning journey that does not need to be confused by learning additional software. I have not used Figma so do not know it. If it is just used to set out a screen flow/GUI design which does not translate into actually building the software is access...

A dummy GUI may help you communicate your needs but what you must ensure is that the underlying data structures - tables and relationships - are constructed with proper regard to the principles of database normalisation. Inspecting the table structures for other order entry systems will give you...

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

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