DeleteObject command

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Steve

    #1

    DeleteObject command

    Hello,

    I was wondering if someone could give me an example of the deleteObject
    command. I would like to delete a temp. table just prior to running a make
    table query.

    I'm also confused as to the proper way to use a update query to update a
    master table. Again, this would be run just prior to the deleteObject
    command.

    /R
    Steve


  • Arno R

    #2
    Re: DeleteObject command

    Steve,
    You seem to have 'lost' the helpfile ... ?
    DoCmd.DeleteObj ect acTable, "TableName"

    --
    Hope this helps
    Arno R








    Comment

    • Steve

      #3
      Re: DeleteObject command

      Thanks for reply. I didn't lose the helpfile, I was just unable to
      understand what I was looking at. Sorry for the stupidity on my part.

      /R
      Steve


      "Arno R" <arracomn_o_s_p _a_m@tiscali.nl > wrote in message
      news:3fba298e$0 $36109$5fc3050@ dreader2.news.t iscali.nl...[color=blue]
      > Steve,
      > You seem to have 'lost' the helpfile ... ?
      > DoCmd.DeleteObj ect acTable, "TableName"
      >
      > --
      > Hope this helps
      > Arno R
      >
      >
      >
      >
      >
      >
      >
      >[/color]


      Comment

      Working...