[AccessD] Update or CancelUpdate Without Addnew or Edit

Max Wanadoo max.wanadoo at gmail.com
Mon Sep 21 17:27:34 CDT 2009


And how exactly do you manipulate the background colour, font ,foreground
colour, etc of a tab control?

Guess what you can do with a button or even better a label simulating a
button or even better a graphic simulating a button?

Forget tabs.  Trust me!

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 21 September 2009 23:24
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit

 >Voila! Max wins again!

Well, not exactly.  Do the exact same thing only have your subforms reside
on the pages of a tab. 
Now as the tab click event fires, load the subform for the correct page,
just as you do for your 
buttons.  the difference is that my code is clean, handling one control (the
tab control).  Yours 
has to be customized to the number of buttons you have on your form.

Add a subform, add a button, add a button event handler.

In my case, add a subform, just add a tab.  No code change at all.  In fact
this is the one lonely 
place where I use the tag property... of the subform control to store the
subform to load in that 
subform control.  In the subform control I simply remove the name of the
form to load and in the 
OnClick of the tab control I yank the name from the subform control tag and
place it back in the 
source property to cause the subform to load.

Works a treat.  Add a tab, drag a subform onto the tab.  Cut the subform
name out of the source 
property and place it in the tag.  Instant JIT subform.  Not a single button
handler in sight.

Voila... John wins again.  ;)

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
>> Max, you aren't listening.  
> 
> True.
> 
> I wasn't talking about loading subforms as part of the tabs, but in having
> controls on the tabs screen space.  IOW, one form, no subforms. Main form
> has dozens of tabs each displaying different information from the mainform
> source.
> 
> Break all that out into subforms which load JIT based on buttons. Voila!
Max
> wins again!
> 
> Max

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list