Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete querydef fields (2002)

    I have a query that I want to reuse, less two fields. How can I remove two fields from the QueryDef? The two lines of code below when executued result in "Method not applicable for this object". What's wrong with my syntax?

    qdfNew.Fields.Delete ("ID")
    qdfNew.Fields.Delete ("ManifestID")

    Any help is appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delete querydef fields (2002)

    You'll have to modify the SQL string of the query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •