Search results

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.

Interesting. I have a new ceiling fan with such a light. Here's a link re replacement light.

Matt, I think we need more info about your environment and your proposed project/database. Here is an older draft picture that may be relevant to your requirement. Assembly is a junction table. FinalProduct would equate to your model, if I understand your post. MajP's example allows for many...

Paul, Can you provide the link to the YT you used successfully? Older Lenovo, no TPM in my case.

Is it duplicate characters within a word, or is it misspelling that is your ultimate goal?