Jim Dettman
jimdettman at verizon.net
Mon Feb 2 06:52:34 CST 2015
It should be pointed out that Eat Bloat was developed long before any utilities appeared else where. Someone (Dan?) was going to continue it on, but I don't think he ever really got into it.. Real opportunity missed there. For those that don't know about the saveastext/loadfromtext, they are undocumented commands that dumps a form to a text file and then imports it. Basically an extension of what you can do with VBA code. You get all the form layout and properties. Often this will straighten out corruption in a form, or let you play with the resulting text file enough that you can get the majority of your work back. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris Fields Sent: Sunday, February 01, 2015 11:48 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Odd Shortcut Problem Wow! That is grand. Thanks. TNF Tina Norris Fields tinanfields-at-torchlake-dot-com 231-322-2787 On 1/31/2015 12:21 PM, Rocky Smolin wrote: > Tina: > > It's really simple. Check this: > > http://stackoverflow.com/questions/2088814/export-objects-in-msaccess-applic ation-to-text-objects-and-import-into-a-new-md > > > R > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris > Fields > Sent: Saturday, January 31, 2015 6:48 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Odd Shortcut Problem > > Okay, you guys, tell me about saveastext and loadfromtext commands, and how > they straightened out the shortcut problem on Rocky's form. I never heard > of these, before. Please teach me. :-) TNF > > Tina Norris Fields > tinanfields-at-torchlake-dot-com > 231-322-2787 > > On 1/30/2015 3:21 PM, Rocky Smolin wrote: >> IT WORKED!!! Happy Friday, amigo. >> >> R >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman >> Sent: Wednesday, January 28, 2015 10:14 AM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Odd Shortcut Problem >> >> Rocky, >> >> Decompile only invalidates compiled code...it doesn't do anything to >> fix form corruption. >> >> You might want to use the un-documented saveastext and loadfromtext >> commands to see if that straightens the form out. >> >> You might also be able to modify the file before you load it if >> there any issues there. >> >> Jim. >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky >> Smolin >> Sent: Wednesday, January 28, 2015 12:39 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Odd Shortcut Problem >> >> I just did a decompile - no cigar. Imported all into a new mdb. Same >> problem. :( >> >> R >> >> >> > -- > 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