Connecting Tech Pros Worldwide Help | Site Map

Default Subdatasheet Name in new tables

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 3rd, 2008, 08:25 AM
Bob Darlington
Guest
 
Posts: n/a
Default Default Subdatasheet Name in new tables

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  
Old July 3rd, 2008, 01:45 PM
Tom van Stiphout
Guest
 
Posts: n/a
Default 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.
  #3  
Old July 4th, 2008, 11:55 PM
Bob Darlington
Guest
 
Posts: n/a
Default 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.

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.