Recent content by jdraw

Mike, I don't think 'IS' is proper syntax. Just found a sample: w3schools SELECT * FROM Customers WHERE Country IN ('Germany', 'France', 'UK');

Here is a quick review of your IsTransferValid function (via Chatgpt) Issue / OddityComment DocNumber parameter is never usedIf the caller supplies it, you might have planned extra validation that hasn’t been coded yet. Third check in the range logic seems counter‑intuitiveSQL ...

"you can see record with docnumber 347 subnumber 3 says that between docnumber 348 and 349 there is next record 347 with subnumer 4 and that record exist"?? How would a reader know what subnumber 3 means? As DHookom said 'No one here can read your mind.' I suggest you leads us through a...

So, why is the thread marked SOLVED? The solution may help someone else. I tried a few things. Major assumption--your field [transfers] can only have 1 space char between numbers eg. 34_567/45/2029 45_5687_42/3045. There can be 2, 3, or 4 number sequences in Transfer Test data...

I like the parable George. We've all been there. The other "beautiful tree" scenario is "I've got so much time and effort into this that I can't possibly stop and correct the design flaw"!

I agree with the others---what are you talking about exactly? Give us a few examples so we understand the issue. Between in Access includes the end points.

moin555, You have been given advice based on a variety of experiences. I have a lot of older references in my signature that I consider "good sources of info", but each respondent has his/her own favourites. Steve Bishop, Allen Browne, Crystal Long(strive4peace), Daniel Pineault(devHut), Colin...

There is an example and discussion Split in a query here.

murray83, Crystal Long (strive4peace) provided a free routine to write the ascii values represented by characters in a string. If you use it to "display" the characters in your raw data, you can likely determine "strange characters causing your concern". Let us know the result.

FWIW, I had an issue that was resolved in this thread by MarkK. Don't know the applicability to this thread, but thought I'd add the link---it may just help someone.

This works for me Sub CheckOfficeBitness() Dim bitness As String #If Win64 Then bitness = "64-bit Office" #Else bitness = "32-bit Office" #End If MsgBox "This is " & bitness, vbInformation End Sub

Welcome aboard AWF!

Hi Ricardo! Welcome to AWF!

Agree with Doc, and in the hands of more "individual mal-intent" why not insert some "binary code" to not only act as a work-around, but also hide some scam/harmful logic.

Omar, Chris (CJ_London) is an accountant and will have experience and focused knowledge. Here is another link that may offer some insight. Good luck with your project. Let us know your solution once resolved.