Search results

Welcome aboard AWF! I spent many years in Ottawa.

Jackdaw, Can you tell us in plain English what you are trying to achieve? Perhaps an example of some input and corresponding output/result. What do you mean by k = rdsR! ?

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.

Omar, Have you tried taking one of the items where you see a discrepancy (say Item 3) and worked it (the specific item) through your processFIFO and queries to see if you can find the issue?

Link to John's blog page re PAUG (Pacific Access User Group) videos Links to the 3 youtube videos are under the "MyVideos:"

John, I communicated with you in late 2022 when you were working with version 7...9(when it had ~60 pages). And before your PAUG sessions. I have followed you on AccessD for years. Having been retired for 16+ years I don't have projects and was never a developer as such. I have always been in...