Recent content by HarryNeil

THANKS TO YOU ALL! All your information and suggestions are applicable and valuable. I need to stop and do some ground-up analysis and redesign. This started as such a simple app that it didn't need design or careful programming, but it grew like topsy, and now it's out of control. I need to...

The_Doc_Man: Thank you for even trying to deal with my jumbled comments. All the information you provided will be useful for me. HOWEVER, comparing this "beta" app with a "production" version that works just fine, the evidence is that I am seeing a seriously contaminated database. For instance...

Thank you both, The_Doc_Man and GP_George! Your comments are VERY illuminating, mostly reminding me that I have no business dealing with ACCESS here in my dotage. (I turn 80 on Thursday.) Yes, I'm using DoCmd.Close, because I haven't found another way to make a form go away when its job is...

I have a couple of forms based on the same item of the same table. When I close these forms I choose acSaveNo, since otherwise there'd be duplicate saves. But there ARE duplicate saves anyway. even producing multiple records. How can I FORCE form closure without saving the data record?

I have a report that summarizes the on-hand quantities of detail records in a group footer. Groups with no details show in the "report view" but not in the "print view," which is according to design. But I want to process with vba those group footers which have no detail records, force in zero...

I'm getting back to Access after some years of doing other stuff, so I'm relearning a lot of things, some of which I never knew. I'm re-amazed at just what Access can do, but also chagrined that it can't seem to do some things I want. So I'll be asking for help on those some things.