How to call a query in Access that contains a custom variable?

[zecche]

Hi. I have a table and an update query in MS Access that updates to the table when it is beinb run. The result of the update query comes from a function that I have added as a module to the MS Access db. For intance,

Update Tbl SET field.Tbl = FunctionXYZ(aug1, aug2, aug3)

I can run this query with no problem in Access, but I can't seem to run it if I were to call it as stored procedure with the following line:

intResult = objcommand.ExecuteNonQuery()

Basically, VB.NET can't recognised FunctionXZY and therefore returns an error.

Is there another way to go around it if VB.NET indeed cannot call such a type of update query? Thank you very much.

Zecche

[nebulom]

You'll get a better answer on VB.NET Section. This section is basically use as Bank for useful codes.