[AccessD] Update or CancelUpdate Without Addnew or Edit

jwcolby jwcolby at colbyconsulting.com
Mon Sep 21 17:26:46 CDT 2009


I will hand you the ugly tab issue.  Not enough to make it worth my time though.  Besides which I 
have used icons in tabs.  Works a treat.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> ..and then you have to jump through loops to see which tab control was
> clicked. And you cannot change its colour, etc.  you are stuck. Use a button
> or a label simulating a tab/button and the world is your oyster (assuming
> you like fish - but then we are back to your other problem LOL).
> 
> 
> Max
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 21 September 2009 23:09
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit
> 
>  > but why make extra work for yourself showing and hiding stuff with
> "buttons" on a single parent 
> form and generally reinventing the wheel?
> 
> Agreed.  That is precisely what the tab control is for.  Write the code and
> place it in a framework 
> library... ;)
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Charlotte Foust wrote:
>> Max, you obviously haven't followed the JIT loading threads we've had
>> over the years.  Tabs don't load anything you have instantiated.  When I
>> built tab forms in Access, they didn't load anything on a page until
>> that page got the focus.  The overhead of loading all tabs is enormous,
>> but why make extra work for yourself showing and hiding stuff with
>> "buttons" on a single parent form and generally reinventing the wheel?  
>>
>> Charlotte Foust
>>
>>  
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
>> Sent: Monday, September 21, 2009 1:03 PM
>> To: 'Access Developers discussion and problem solving'
>> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit
>>
>> Ok, it is for ME.  
>>
>> I will never go back to tabs.
>>
>> Tabs load ALL the data for all the tabs each time you open the form and
>> each time you navigate between records.  ALL of it ALL the time.
>>
>> A button merely replaces the sub form with another sub form.
>> Practically instantaneous and only loads the data in the sub form that
>> you have opened.
>> To the user it looks and feels the same but  FASTER...a lot FASTER.
>>
>> One form I had was practically unworkable and now it flys.
>>
>>
>> Max
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
>> Foust
>> Sent: 21 September 2009 20:57
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit
>>
>>> Best of all, drop the multi-tab subform and replace with buttons.  Must
>> faster and easier to maintain.
>>
>> NOT!
>>
>> Charlotte 
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
>> Sent: Monday, September 21, 2009 12:51 PM
>> To: 'Access Developers discussion and problem solving'
>> Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit
>>
>> If this has just happened on a form which hitherto was working ok, then
>> do a rebuild.  
>> If you have added any code to make changes to the data on the form
>> (either directly or via a Query) then put a me.dirty=false to ensure the
>> change is written away immediately.
>>
>> Best of all, drop the multi-tab subform and replace with buttons.  Must
>> faster and easier to maintain.
>>
>> Max
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
>> Sent: 21 September 2009 20:03
>> To: 'Access Developers discussion and problem solving'
>> Subject: [AccessD] Update or CancelUpdate Without Addnew or Edit
>>
>> Dear List:
>>
>> I have a rather complex form with a multi-page tab.  Some of the tabs
>> have subforms
>>
>> When I open the form and click in an empty space on the subform I get
>> the message "Update or CancelUpdate Without Addnew or Edit".  If I go to
>> any other tab page with a subform and click anywhere on the subform I
>> get the message.  One of the tab pages generates the message without
>> even clicking.
>>
>>
>> I can click on any tab page which does not have a subform with no
>> problem.
>>
>> I get this problem in 2007 but not 2003.  My client has it in 2007 and
>> 2003.
>> But not on all machines. 
>>
>> I'm stumped.  Any ideas welcome.
>>
>>  
>>
>> MTIA
>>
>> Rocky
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> 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