Module as Query Criteria..

[News]

Hi to all,

Can anyone help me with the following;

I have a piece of 'code' (module) that converts EAN numbers to an ISBN
number.
I use a barcode scanner that scans the EAN into a table and i like to build
a query
that converts the EAN to ISBN
The code i have works fine on a form but i would like to insert this code
into my
query as an expr build on the EAN number.
How do i 'build' this query and how do i "call" this module into the query.

I hope i made my problem clear enough and hopefully anybody
can help me out with this.

Thanks in advance for the help,

Arthur

 

[Guest]

Take the code from your form module and create a function in a separate
module in the modules tab. Create an update query and call the function in
the 'Update to' row of the EAN or ISBN column.
e.g. Update To =ConvertEan([EAN])
The function is called ConvertEan and you pass the EAN field to the function.
If you wish to retain the original EAN value then create a new column in
your table which is a copy of the EAN column, call it ISBN, and pass this to
your function.

 

[News]

Thnx Dennis i'll try that,

Take the code from your form module and create a function in a separate
module in the modules tab. Create an update query and call the function in
the 'Update to' row of the EAN or ISBN column.
e.g. Update To =ConvertEan([EAN])
The function is called ConvertEan and you pass the EAN field to the
function.
If you wish to retain the original EAN value then create a new column in
your table which is a copy of the EAN column, call it ISBN, and pass this
to
your function.

Hi to all,

Can anyone help me with the following;

I have a piece of 'code' (module) that converts EAN numbers to an ISBN
number.
I use a barcode scanner that scans the EAN into a table and i like to
build
a query
that converts the EAN to ISBN
The code i have works fine on a form but i would like to insert this code
into my
query as an expr build on the EAN number.
How do i 'build' this query and how do i "call" this module into the
query.

I hope i made my problem clear enough and hopefully anybody
can help me out with this.

Thanks in advance for the help,

Arthur