Default Subdatasheet Name in new tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bob Darlington
    #1

    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


    Tags: None
    • Tom van Stiphout
      #2
      Re: Default Subdatasheet Name in new tables

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

      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.

        Comment

        • Bob Darlington
          #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.tom774 4@cox.netwrote in message
          news:7dlp64dqm5 79876suokr1r60f calpul08k@4ax.c om...
          On Thu, 3 Jul 2008 18:24:37 +1000, "Bob Darlington"
          <bob@dpcmanAX.c om.auwrote:
          >
          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.

            Comment

            Previous template Next
            Working...