Search results

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

wmix, How about showing/providing readers with 10-20 notes fields so we can see what you have/are collecting? Better if you provide such data as textfile or database. We're not interested in proprietary information, but want to understand the variety of info in these Notes fields. It may also...

wmix, As for making a more structured PropertyAttributes table based on your Notes field, you might want to show readers a few examples of the Notes field contents. There may be some ways to reduce the variety of terms/meanings/spellings into a more authoritative, consistent set of attributes...

Welcome John!

My laptop (win 11 Office 365) is responding similar to Doc's.

Welcome aboard AWF!

Tony, Is it actually spelled "arguement"?? I would have expected "argument" and that Grok would do some sort of spellcheck.