Passing Parameters To Stored Procedure

G

Guest

I have a BackEnd A2K DB that consists of tables of data, which is accessed by
a DataProcessor A2K DB by linking to the BackEnd tables. The DataProcessor
A2K DB mainly consists of select & action queries. These include input
parameters.

A FrontEnd A2K DB puts a face to the app, with forms & queries with are
linked to the BackEnd tables. To handle any data processing, Event
Procedures are coded in VBA to connect to the DataProcessor DB and drive
these queries programmatically.

But how do I pass the input parameters to the append query programmatically
ie. the form defaults to this month's date, I click the Generate Billing
button, the VBA code fires the appropriate parametised append query, which
needs to be given the date.
 
A

Alex Dybenko

Hi David,
you can use querydef's parameters collection:

set qryd=dbs.querydefs("myquery")
qryd.parameters("myParam")=date()
qryd.execute
 

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

A2k FE connect to A97 BE 1
Too few parameters. Expected 1. 2
Transfer data from one Access DB to another 3
Parameter Query - Passing multiple parameters 2
How do you pass parameters to a stored procedure 2
Help with sending two parameters to Stored Procedure. 4
Running a query on the Back End 9
Passing parameters 4

Top