Default Subdatasheet Name in new tables

Question posted by: Bob Darlington (Guest) on July 3rd, 2008 08: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

Tom van Stiphout

Guest

n/a Posts

July 3rd, 2008
01:45 PM
#2

Re: Default Subdatasheet Name in new tables

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.

Bob Darlington

Guest

n/a Posts

July 4th, 2008
11:55 PM
#3

Re: Default Subdatasheet Name in new tables

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.

Not the answer you were looking for? Post your question . . .
190,182 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors