Default Subdatasheet Name in new tables
in [Help]
|
Prev: Rado Anatom Ladies Watch 15303993175, Best Luxury Watch - www.luxury-gift.org
Next: Tables (Design View) Row Source Type - Value List Row Source - data1;data2;data3 is not updated to the Form view
From: Bob Darlington on 3 Jul 2008 04:24 I have a routine which creates a new table using "SELECT INTO ....." Is there anyway to set the default Subdatasheet name property to 'None' for new tables? Or do I need to run a separate routine to set it each time? I'm using Access 2002, and I do have the code to reset this value if necessary. -- Bob Darlington Brisbane
From: Tom van Stiphout on 3 Jul 2008 09:36 On Thu, 3 Jul 2008 18:24:37 +1000, "Bob Darlington" <bob(a)dpcmanAX.com.au> wrote: I think you have to set it each time. There is no global setting AFAIK. -Tom. >I have a routine which creates a new table using "SELECT INTO ....." >Is there anyway to set the default Subdatasheet name property to 'None' for >new tables? >Or do I need to run a separate routine to set it each time? >I'm using Access 2002, and I do have the code to reset this value if >necessary.
From: Bob Darlington on 4 Jul 2008 19:46
Thanks Tom. I guess I was just being hopeful. -- Bob Darlington Brisbane "Tom van Stiphout" <no.spam.tom7744(a)cox.net> wrote in message news:7dlp64dqm579876suokr1r60fcalpul08k(a)4ax.com... > On Thu, 3 Jul 2008 18:24:37 +1000, "Bob Darlington" > <bob(a)dpcmanAX.com.au> wrote: > > I think you have to set it each time. There is no global setting > AFAIK. > -Tom. > > >>I have a routine which creates a new table using "SELECT INTO ....." >>Is there anyway to set the default Subdatasheet name property to 'None' >>for >>new tables? >>Or do I need to run a separate routine to set it each time? >>I'm using Access 2002, and I do have the code to reset this value if >>necessary. |