Search results

@theDBguy Your code has been munged with & for &

See this almost 20 year old post on UA

Please show how you are doing the checks

OK, but if all values in Notes (Match/Spelling/Original) are dependent on other fields in the record then the field is not required. It can be produced 'on the fly'. When/where do you determine 'Match' and 'Original'?

Another thing: are all your Spell* booleans independent? (ie if one of them is true then all others must be false) Or can more than one be true at the same time?

Do you really need to set the value of Notes to 'Spelling' at all? Effectively it's a calculated expression based on any of your boolean fields, so can just be calculated in a query or control source.

WHERE OR is invalid SQL

I'm not sure I ever suggested that you shouldn't use it, George. 🤷‍♂️

This is neither a hack, nor SQL injection Doc! It's just an error in the SQL. Semi-colon is the [traditional] end of statement character - multiple statements are perfectly valid in RDBMS's that allow them. It's not injection. Injection is where you pass a poisoned value to an input in a...

You could just set the ControlSource of txtAge to: =IIf(IsDate([txtBirthDate]), AgeFromDOB([txtBirthDate]), Null) (where AgeFromDOB() is your function that calculates age)

Don't change it now - I always thought the mis-quote was funny (and intentional!) Edit: actually, listening to the song again, both versions are used! 🤪

This will barf if strVar contains a double quote.

Very interesting! Must make your code feel very expensive! :ROFLMAO:

Your initial explanation in Post #1 gives the impression you are very unclear! A few questions: 1. Do you have a server on which you can host a MySQL instance? 2. If so, and you have set up the MySQL server, have you migrated your Access tables to MySQL 3. Do you know about ODBC connections...

Thanks for the clarification. (y) I don't have this version of MSPhotos to test with. What happens if you try a variation of one of Daniel Pineault's suggestions? Function OpenNEF() As Long With CreateObject("WScript.Shell").Exec("ms-photos:FilePath=D:\images\008.jpg") OpenNEF =...

Using Win 10 If you can get that full path then does the following open the file? Const EXE_FILE As String = "C:\Program Files\WindowsApps\Microsoft.Windows.Photos_<version>\Microsoft.Photos.exe" ' Fill in version! Const DQ As String = """" OpenNEF = Shell(EXE_FILE & " " & DQ &...

What might it be if it's not Photos.exe? (ie how do you determine other default programs used?) You can add these functions to a module: Function OpenNEF(PathToNEFfile As String) As Long ' TODO: add error handling Const EXE_FILE As String = "Photos.exe" Const DQ As String = """"...

Sorry for the delay in getting back to you. Yes, Philipp summarises in Post #6 the idea I was proposing. (y) To give a more concrete example please can you post examples of what variables sPath and sViewer (in Post #1) might contain. With that info it is quite likely you can have generic...

Use the PID returned by the Shell() command instead of the exe name. (Replying from my phone - will post an example when I get back to a computer)

stop-vibe-coding-every-damn-time