Default Subdatasheet Name in new tables

#1 July 3rd, 2008, 09:25 AM

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

#2 July 3rd, 2008, 02:45 PM

On Thu, 3 Jul 2008 18:24:37 +1000, "Bob Darlington"
<bob@dpcmanAX.com.auwrote:

I think you have to set it each time. There is no global setting
AFAIK.
-Tom.

Quote:

>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.

#3 July 5th, 2008, 12:55 AM

Thanks Tom.
I guess I was just being hopeful.

--
Bob Darlington
Brisbane
"Tom van Stiphout" <no.spam.tom7744@cox.netwrote in message
news:7dlp64dqm579876suokr1r60fcalpul08k@4ax.com...

Quote:

On Thu, 3 Jul 2008 18:24:37 +1000, "Bob Darlington"
<bob@dpcmanAX.com.auwrote:
>
I think you have to set it each time. There is no global setting
AFAIK.
-Tom.
>
>

Quote:

>>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.

Default Subdatasheet Name in new tables

re: Default Subdatasheet Name in new tables

re: Default Subdatasheet Name in new tables

/bytes/development

/bytes/it

/bytes/about