C
Corta
I am in the process of extending my Access 2007 knowledge and
hopefully VBA skills. I am reviewing samples, reading many of the
posts on this group, etc. In the long run I need to learn VBA inside
and out based on my professional goals so I am trying balance between
learning the basics of the language and working through examples. So
I have two questions.
1.) What is the best online reference for the VBA language for Access
2007?
2.) In my test database a have several tables and made a query
selecting the information I want based on my criteria for a special
report that I developed. The query and subsequent report all work as
designed. I want to stretch my skills by using the SQL select code
generated by the query by way of attaching it to a command button on a
form. Functionally I understand that I need to select the data via
the SQL statement and I need to call the report I created for the
query when I select the command button. I just need help getting
pointed in the right direction with the VBA code.
Thank you for your time and assistance.
Corta
hopefully VBA skills. I am reviewing samples, reading many of the
posts on this group, etc. In the long run I need to learn VBA inside
and out based on my professional goals so I am trying balance between
learning the basics of the language and working through examples. So
I have two questions.
1.) What is the best online reference for the VBA language for Access
2007?
2.) In my test database a have several tables and made a query
selecting the information I want based on my criteria for a special
report that I developed. The query and subsequent report all work as
designed. I want to stretch my skills by using the SQL select code
generated by the query by way of attaching it to a command button on a
form. Functionally I understand that I need to select the data via
the SQL statement and I need to call the report I created for the
query when I select the command button. I just need help getting
pointed in the right direction with the VBA code.
Thank you for your time and assistance.
Corta