vba question for access and word automation

Closed - This job posting has been filled and work has been completed.

Job Description

0down votefavorite

I am attempting to transfer data from an access database into a word document. I have performed a similar procedure using excel and I need to code it using access instead of Excel. The excel code (for an analogy is this)

dim myworkbook as excel.workbook set myworkboox = getobject("C:\Users\jn\Desktop\trial.xlsm")

then dim excelstr as string excelstr = myworkbook.application.Range("A1:A100").Find("aword").offset(0,1).value

cant figure out how to do this with access where I pull in data by finding a string within a table and using some sort of offset procedure to find a string next to the string that was found Any help is greatly appreciated thanks j