Dear PWise,
Thank you for your posts, the examples you gave at least got the brain working.
While i don't know enough to write what i wanted in VB, I did a work around using expressions in a subquery.
I know how to write the If statements, just don't know properly where to do it, using...
I would recommend O'Reillys Access Cookbook, it has clear instructions, and great code examples that work, and are easy to implement if you are a novice!
I can't tell you how many of their examples I have implemented.
You can set up your Word Document Report as a template, then link that Template to Access in a variety of ways. You can use mail mege and insert information into the report, or you can use ADO and pull info from the recordset into Word.
check out this site
wwww.helenfeddema.com, code samples...
Well, when using 2000, you have to connect to the db using odbc...then choose the datasource, then click the options button and choose views...say ok...
then that will show you all of your tables and queries in a db or excel spreadsheet,
however, i don't know the diff between, 2000 and 2002 or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.