[AccessD] Access 2010 Switch from Form View to Datasheet View crashes.

[David Emerson]

Thanks Jim,

I'll do some further testing later today.

Regards

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman
Sent: Monday, 1 May 2017 1:54 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2010 Switch from Form View to Datasheet View
crashes.

David,  

Not sure if it'll make a difference or not, but as a general rule song with
any programming language you want to be as explicit as possible. So I would
try adding Me. To that reference and see if it makes a difference.   If that
Doesn't do it I would try doing a save as text and load from text to see if
the form is corrupted.   If that doesn't fix it can you do up a simple
database that shows the crash? I'll try it in a later Version and if I still
get the crash I'll submit it to The Access guys.

Jim

Sent from my iPhone

> On Apr 30, 2017, at 12:00 AM, David Emerson <newsgrps at dalyn.co.nz> wrote:
> 
> Hi Team,
> 
> 
> 
> I have found the problem (but not a solution).
> 
> 
> 
> It relates to a text box I have in the Form Header.  I have a combobox 
> in the form header and the text box has the following control source:
> 
> 
> 
> =Nz([cboPendingOrders].[column](3),"")
> 
> 
> 
> If I remove the control source then the form doesn't crash.
> 
> 
> 
> In Form View the data from column 3 shows correctly.
> 
> 
> 
> I solved it by removing the textbox and showing the data in the 
> Combobox concatenated with the original data from the combobox.
> 
> 
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
> 
> 
> 
> 
> 
> --
> 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