Steve Conklin
developer at ultradnt.com
Tue Nov 28 22:49:41 CST 2006
Kath - I still can't understand why the form can't find the function, but the vba behind the form can ... Next time this hits, I'll try turning off 'invalid control properties'. Thanks, Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti Sent: Tuesday, November 28, 2006 9:19 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Upgrading from Access 2000 to 2003 Steve - if you are calling a function which it can't locate then I'd say that would be why you're getting the error messages. The setting under tools, options, error checking looks like it would allow you to turn it all off or select individually, in your case you could turn off 'invalid control properties'. I'm still deciding because I'm new to 2003 how much to turn off but some of them seem ridiculous, eg. 'unassociated labels'. Kath ----- Original Message ----- From: Steve Conklin To: 'Access Developers discussion and problem solving' Sent: Wednesday, November 29, 2006 1:10 PM Subject: Re: [AccessD] Upgrading from Access 2000 to 2003 Kath: >>>>>>>There is a new level of error checking in 2003. Any controls that do not have tne control source in a form's source will create new error messages (shouldn't have any of those but it found a couple!) . Error checking levels can be adjusted thru the menu. (tools, options, error checking). >>>>>>> Is this why I get, in A2k2-3, random #error in text boxes that have "=GetDefault()" or some such function call as their source? I have been just moving these function calls to the code in form.current, and that has worked around it. Lowering, or turning off one these options in Error Checking will prevent this? Thanks, Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti Sent: Monday, November 27, 2006 8:36 PM To: Access D Normal List Subject: [AccessD] Upgrading from Access 2000 to 2003 I've been keeping track of issues I have faced when I had to upgrade a client's system from Access 2000 to 2003 this month. I thought it might be worthwhile posting my brief list in case anyone else needs to do the same - and maybe those of you who have worked in 2003 more than I have can add to it..... - Start with new 2003 database, and change default file format to 2002-2003 before importing all objects, file import specs, relationships. - Recreate Startup options and update all references - Check all report settings for reports which do not use the default printer. (I found that those that use a specific printer, eg. pdf995 had reverted to default printer on import). - Check that toolbars are displayed. Even though they are imported, I found that I had to turn then on manually (change properties to allow them to be turned on / turn them on / change properties back again) - All references to the commondialog control need to be re-written (browse / save dialogues) - Change the [Tools] [Macro] [Security] level to Low to prevent users getting the msg "Do you want to block unsafe expressions?" - There is a new level of error checking in 2003. Any controls that do not have tne control source in a form's source will create new error messages (shouldn't have any of those but it found a couple!) . Error checking levels can be adjusted thru the menu. (tools, options, error checking). ______________________________________ Kath Pelletti -- 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