defy
10-03-2011, 06:28 PM
Dear All,
I'm looking to program some sort of code, VBA, to export data from access 2010 to a word 2010 document which in it self represents a form. Here is the catch.
In access i have a specified name referring to the word document form. For example i have lots of forms A, B, C etc. SO i select form B it ones up form B, i then have to manually fill the form out, however access already contains all the necessary information. I.E System name, Number, Equipment Number etc.
So the question is, is there a way to export all the data from access to the word document pre specified into correct columns and rows in the word document?
I was thinking of using idetifiers such as: if line contains System ID: place space nad insert from System ID.
Could you at least point me in the right direction or provide a solution for me?
I know this is very poorly worded but my knowledge in access is very poor. Any help would be highly appreciated.
I'm looking to program some sort of code, VBA, to export data from access 2010 to a word 2010 document which in it self represents a form. Here is the catch.
In access i have a specified name referring to the word document form. For example i have lots of forms A, B, C etc. SO i select form B it ones up form B, i then have to manually fill the form out, however access already contains all the necessary information. I.E System name, Number, Equipment Number etc.
So the question is, is there a way to export all the data from access to the word document pre specified into correct columns and rows in the word document?
I was thinking of using idetifiers such as: if line contains System ID: place space nad insert from System ID.
Could you at least point me in the right direction or provide a solution for me?
I know this is very poorly worded but my knowledge in access is very poor. Any help would be highly appreciated.