Create Query

[JME]

hi all

i am really new to access but now i got assignment from
school to develop a program using access.

well what im stuck at the moment is to make make a button
working such that it can create a query from a table using
many criteria.

so let say for example i have a table "Transaction". And
it has few fields
(ID,date,productname,SalePrice,Cost,Customer,etc). now let
say i want to create a button to display that table but
with some filters and criteria from its fields. i can do
it using macro but now i want to try it using module. can
some one explain to me steps for it?

another thing i'd like to getting clear is what's the
difference between MODULE and CLASS MODULE

regards,
john

 

[Marshall Barton]

i am really new to access but now i got assignment from
school to develop a program using access.

well what im stuck at the moment is to make make a button
working such that it can create a query from a table using
many criteria.

so let say for example i have a table "Transaction". And
it has few fields
(ID,date,productname,SalePrice,Cost,Customer,etc). now let
say i want to create a button to display that table but
with some filters and criteria from its fields. i can do
it using macro but now i want to try it using module. can
some one explain to me steps for it?

another thing i'd like to getting clear is what's the
difference between MODULE and CLASS MODULE

Have you tried using the Convert Macros to Visual Basic item
on the Tools - Macros menu? Once you see your logic crusely
translated to VBA, you should be able to clean it up and see
if you might be able to improve on it.

There are two kinds of modules Standard and Class. Standard
modules are containers for the usual Function and Sub
procedures. A class module is used primarily to hold the
code behind forms and reports, including any event
procedures. You can create your own class module if you
want to create a custom class with a custom set of
properties and methods (very powerful, but an advanced
subject).

 

[Guest]

Thanks...didn't know there's the way to do it

I'll try to figure out my self first and i'll post again
ifi have further uestions