Recent content by jdraw

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.