Access 2003, Windows XP SP2
I have an application that generates a word document populated with a
variety of fields from Access tables.
The word document is generated when the user presses a button
(cmdGenerateAgreement) on a form (frmTransaction).
I want the process to work as follows:
1. User presses button
2. Word document is opened and populated
3. Access screen becomes visible with a message box
4. User presses Ok
5. Word screen becomes visible for finalization
My question is how do I achieve steps 3 and 5?
I've tried SetFocus, Access Web's API: Manipulate Window
(fSetAccessWindow), and a lot of browsing in the newsgroups. Nothing
seems to work.
My guess is that this functionality will require a call to the Windows
API. I've read all the relevant sections in my Access books, and
nothing specific to this situation is mentioned.
Can this functionality be accessed using VBA? If so, any help or
direction would be appreciated. If not, can anyone think of a work
around?
Thank you,
Kelii