Forum Discussion
Unable to open a Word document maximised
Hi, I have tried several suggestions from the web to open a Word document maximised from my Access application. All are opening the document but not maximising it. My current code is Set myWo...
Storming here is a demo, maybe it will work for you.
open basTest Module in VBA and supply the correct word docx.
when done, press F5 to run the
Thanks, I will try that.
If you don't mind can I ask another question please?
I want to use 2 tables in my letter. The main merge is based on my customer table.
I am trying to list in the letter a table of work items and have tried the following code but it is not working
{DATABASE \d "c:\\Users\\Norman\\Desktop\\Arron.accdb" \s "SELECT [Work job list].Room, [Work job list].Item, [Work job list].Description FROM [Work job list] \h}
Any suggestions please?
If you don't mind can I ask another question please?
I want to use 2 tables in my letter. The main merge is based on my customer table.
I am trying to list in the letter a table of work items and have tried the following code but it is not working
{DATABASE \d "c:\\Users\\Norman\\Desktop\\Arron.accdb" \s "SELECT [Work job list].Room, [Work job list].Item, [Work job list].Description FROM [Work job list] \h}
Any suggestions please?
Storming without seeing your db or your docx, i cannot answer you.
btw i use this as mailmerge. the word docx is in Attachment field in Contracts table.
this is but a demo.
Hi, I have attached a cut down version of the database but the main items are there to create the mailmerge.
The WORK table will only ever have 1 row in it (different customer each time) and the WORK JOB LIST table holds the work to be done.
Thanks again for your help