Paramterized appends query

  • Thread starter Thread starter Kirk Cullen
  • Start date Start date
K

Kirk Cullen

How can you run a parameterized appends query from vb
using a form field as the criteria???
 
Kirk,
Is this an .adp/.ade or .mdb/.mde?
If it is a stored procedure in SQL Server,
You can use code like this from a Command Button on a
form:
Example: Your form is named frmEmployees and the criteria
you want is in a text box named txtEmployeeID. The stored
procedure is named "spAppendRecords"

Private Sub CommandButton1_Click()

CurrentProject.CurrentConnection.Execute "EXEC
spAppendRecords '" & me.txtEmployeeID & "'"

Exit Sub

For a Jet query (Access .mdb) you can put the following
as the criteria of the field in question:
Forms!frmEmployee!txtEmployeeID
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Macro Repeat Expression using value of a field in table 0
Append Query Issue 0
Pull a field from a form to be the criteria of an append query 0
query field names changing to expr#: 8
Parameter passing 1
Criteria in append querie 3
Access 2007 - append query only appending 0 rows??? 0
Access Access 2007 - append query only appending 0 rows??? 2

Back
Top