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
    Posts
    2

    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
    Posts
    2

    I found my answer

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

  3. #3
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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