invoking append parameter query in VB

DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: invoking append parameter query in VB

  1. #1
    Join Date
    Jan 2010

    invoking append parameter query in VB

    I have a simple append query that I would like to run from VB to avoid the dialog boxes promted when not using VB. I have a table created and run a delete query before the append query. Here is the code I have so far.
    I need assistance with the parameter query part of the code. The query I currently have has the criteria [forms]![Parts]![Part number]

    Any help is greatly appreciated

    Public Function Update()

    Dim dbs As DAO.Database

    Set dbs = CurrentDb

    dbs.Execute ("New_Part_qry")

    End Function

  2. #2
    Join Date
    Jan 2010

    I found my answer

    Thanks......even though I didn't get any replies

  3. #3
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    What was the solution?

    It might help others.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Query works in Access, but not VB .NET
    By corygibbons in forum Database
    Replies: 6
    Last Post: 07-11-2007, 08:30 PM
  2. How to execute a Query from VB code?
    By magic in forum VB Classic
    Replies: 1
    Last Post: 05-09-2002, 06:31 AM
  3. Parameter Query errors
    By Igor in forum VB Classic
    Replies: 2
    Last Post: 03-21-2001, 12:54 PM
  4. Parameter Query
    By Igor in forum VB Classic
    Replies: 1
    Last Post: 03-16-2001, 09:56 PM
  5. Replies: 84
    Last Post: 01-29-2001, 01:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center