Passing Parameters To Stored Procedure

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi David,
you can use querydef's parameters collection:

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