Thanks Aidan Hughes, for your help. Actually, your answer made me realize that I have structured my table incorrectly, and that, once a basic change is made, your tip will work. See, I had made the several species_grade & volume fields ALL PART OF ONE RECORD.
Example:
Invoice SPG1 VOL1 SPG2...
I use the Access Report template to output contractor pay statements for a job I do in the forest industry. One report template is used to print many statements (naturally). Several lines are made of string fields and double fields as in the following :
Example 1:
Species/Grade Volume...
Thank you, VBSlammer. Your code worked fine. (It turns out that I did not have the DAO 3.6 Library option checked off in Tools/References - that's why my code was not working. Ha!).
Regards, David 693.
PS-unemployed in Smithers, BC.
I feel silly asking this question. However, here goes.
I'm working in MS Access 2000, trying to write a Visual Basic module to open a table, and edit selected fields. VBA is new to me (old dBase & C++ guy!-that's me), and I can't seem to get started. So, what code do I use for the Declaration...
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.