-
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
-
I found my answer
Thanks......even though I didn't get any replies
-
What was the solution?
It might help others.
Similar Threads
-
By corygibbons in forum Database
Replies: 6
Last Post: 07-11-2007, 08:30 PM
-
By magic in forum VB Classic
Replies: 1
Last Post: 05-09-2002, 06:31 AM
-
By Igor in forum VB Classic
Replies: 2
Last Post: 03-21-2001, 01:54 PM
-
By Igor in forum VB Classic
Replies: 1
Last Post: 03-16-2001, 10:56 PM
-
By Jon Ogden in forum .NET
Replies: 84
Last Post: 01-29-2001, 02: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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|