Recent content by GPGeorge

Perhaps it's a long shot, but maybe Desktop Power Automate could be useful in repeatedly performing the required steps. I am aware that at least some part of the process is selecting/entering an account code, so that would complicate it...

Mine for total calories lasted less than a day,,,,

I know we're all working from home these days, but in an office environment where many people are working, the sound of tooltips going off around you as your coworkers use this Access database application might not be the most popular feature.

Like you say, it depends on the specific circumstances. Inventorying lawn-mowers in a garden shop is quite different from counting cans of corn in a warehouse.

I like that strategy, too. It also avoids the hazard of relying on the StockTaker to hand count items (accurately) and type the number in (accurately) for each product.

During the development of the Northwest Developer template, we looked at Stocktake activities. In a video I did for YouTube, I talked about the two different approaches to recording stocktake, particularly when you have a barcode scanner. In summary, I came to the conclusion that the most...

True. I was too parochial in my statement. My excuse is that I almost never use Excel or Word these days.:rolleyes:

Nope. You are smart enough to ask for advice. That makes you far, far from the dumbest person....

"New" Outlook does not support COM, i.e. the inter-application automation framework needed to automate it from other Office applications. Hence, the warning that you can't automate Outlook, using VBA, from Access. It is written, I understand to use JavaScript instead. Microsoft has not yet...

That's one of the features in Access that leads newcomers down the primrose path to the swamp. It's called Subdata Sheets and it's a bad idea. Right now, in early development, it seems really sweet. It's not. What you are doing is embedding tables inside other tables inside of other tables...

If you mean that you intend to show how you implemented the Allen Browne method, that would be helpful. Thank you.

You've made this process several times more complicated than it needs to be. Please take a break from what you are doing here. STUDY the methods others have suggested to you. Learn how the Allen Browne method is designed and learn how we implemented it in Northwind Developer. Much simpler to...

That's the way Allen Browne's method works and the way it was implemented in Northwind Developer.

The Stock Take process and inventory management in Northwind Developer Edition is based largely on Allen Browne's method. You can download and install it and use it to learn more about that method in context. NOTE: the template for NW Dev was broken the last time I downloaded and installed...

I note that you are no longer being blocked from replying to this thread. Perhaps it's no more complicated than the old "Turn it off. Turn it back on." method. When you left the site and came back, the appropriate settings were updated.