Search results

Aye...I've read it.

Addendum to my previous post with shorter example code: I found that leaving the entire detail background of the form with continuous action to take was causing certain images on the form and the Properties window to flicker intermittently. My work-around for now is wrapping the actions code...

Just wanted to say ByteMyzer's treatment of this subject is great. Others mostly didn't spell it out. Wanted to add this quick note however... I just quickly tried it on my form and it worked first time out...in a shorter form. I laid the primary link image directly over an exact copy created...

Unlike my simpler forms, although the extra code (mentioned last post reply) worked for filters, it didn't work to remove filters. Found a solution however, as a macro using RunCommand as RemoveFilterSort.

Update to my question re subforms and filters: I was able to achieve my goal in some early testing (since the question) by setting the filter and turning it on, for each of all three subforms on each of the 6 filter buttons' subs plus the Show All button sub. Just seems there might likely be a...

Configuration: Main form (no data source), subform on tab control based on table, two subforms on first subform each Child/Master-linked to the primary key of the first subform's table. The intention is for this tab's first subform and its subordinate subforms be "view only" (no adding...

Finally made it back to test the code. It worked great (without any lock/unlock needed). My problem was that I was leaving out ".Form" in my syntax. THANKS!

Thanks for the heads up. Just got back home from an early morning trip. Won't be checking into it until later.

I'll take a closer look and test using that code. In this case, Name and Source Object are the same, which is also the name of the form file itself. I didn't mention earlier, but no Child/Master Links have been setup.

I created a form with a Datasheet as subform, and need to turn Add, Delete, Edit ON/OFF. I've tried various VBA methods, such as setting these 3 properties for the main form True/False via a command button. This sets the main form, but does not prevent anything on the subform. Search yielded one...

Hi All, :) Greetings from new forum member, initials DEC. Some unschooled programming in Access 97-2002. Doug