Search results

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

Several errors/issues can be attributed to Lookup fields . Most will advise you to avoid them. See the link below. Lookup wizard/fields

Further to moke's comment, are we to expect all latest changes to the evolving book and the database to be at the links he quoted? I know John said he is pushing stuff to github and is trying to keep the book and database in sync - but that's considerable "syncing". I hope there is an effective...

I don't see a prodOrderTB in that sql. Is there a specific line of code that shows the error, or is there some other SQL being referenced?

Can you post the SQL for the recordset mentioned?

Omar, You may find these older links helpful: fifo inventory Fifo related

Here's the link for codeKabinett Transaction example He (sonic8 /Philipp Stiefel) is using DAO.

No need to apologize. You know your environment much better than any reader. You may have all the subforms etc that you need, and your proposed approach seemed to satisfy immediate needs. But as you are finding, there is an "unending list" of things and each new thing requires modifying the...

That's a good intro, but what exactly is in the Notes fields. You have provided a summary of a situation(s), but what do you record? How would you respond to a specific question about such a meeting in a month from now? What if the question involved several of the Properties? Do you have a list...