Writing Code Again - File That Writes VBA Code

[Praize]

My Job is purely automation at my new company. I have worked as an access programmer for some time now. Since most of my code got lost, (don't ask me how its too depressing:banghead. I'm hoping to rewrite most of my stuff. Currently im looking for a way to Create a format understanding VBA to write code for me and then my next step is to tweak it a little bit and Copy my MS access Database Data into a Word format- as opposed to using MS Access's Reports.

My Code is something like this. It is superposed to understand a Word File [User Data Entry Form] and Create that format so i don't have to Write the Entire code myself when I Try to Send Information for selected Records in MS Access and Populate it into a Word File Manually. but im sure these must be a better way to do this, so here goes.

Currently im running this code in MS Word. File is attached.

When i run some of this created code. It doesnt know how to manage merged Columns. Since im new to programming MS word VBA by sending information from MS Access, hoping you guys could help or suggest a better idea.

I'm the only MIS guy now. Hoping i can make a difference.

 

[isladogs]

Welcome to AWF.
Having spent several hours today rewriting code that I lost after Access crashed, I know how you must feel.

If I understand you correctly you want to import data that will be contained in the various parts of a form layout in Word.

If so, you do that by referencing each part of the form using bookmarks in Word.
If you need to combine data from different bookmarks, just concatenate the strings obtained..

See this recent thread which may help you get started
https://www.access-programmers.co.uk/forums/showthread.php?t=296431

 

[praizes]

Thanks. Will let you know how it goes.