VBA, move between Access and Word, back to Access, Close word

move between Access and Word, back to Access, Close word

Author	Message
Amy #1 / 4	move between Access and Word, back to Access, Close word I am working in an Access dB that has links (hyperlink) to a word document. The word document has a link back to Access. I have tried recording a macro to close the word document once the user leaves it. Have not been able to do so. Real problem is that the Access minimizes itself when word comes up. If I could find a way to keep Access maximized behind the word document, then my problem would be solved. Thanks, Amy
Sat, 02 Jul 2005 21:48:07 GMT

Cindy Meister -WordMVP #2 / 4	move between Access and Word, back to Access, Close word Hi Amy, It could probably be done, using Application Events, but you'd have to have complete control over the installation. Is this just for yourself, or something you want to share (or distribute)? And what version of Word is this? Quote: > I am working in an Access dB that has links (hyperlink) to > a word document. The word document has a link back to > Access. > I have tried recording a macro to close the word document > once the user leaves it. Have not been able to do so. > Real problem is that the Access minimizes itself when word > comes up. If I could find a way to keep Access maximized > behind the word document, then my problem would be solved. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister http://www.mvps.org/word http://go.compuserve.com/MSOfficeForum This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Sun, 03 Jul 2005 23:20:50 GMT

Amy #3 / 4	move between Access and Word, back to Access, Close word Cindy, Thanks for your assistance. I am working in Microsoft Word 2000. The database will run on a number of different computers. Unfortunately, I will have no control over each computer's software installation. I will reflect the maximize database into the Database Instructions Guide. Amy Quote: >-----Original Message----- >Hi Amy, >It could probably be done, using Application Events, but >you'd have to have complete control over the installation. Is >this just for yourself, or something you want to share (or >distribute)? >And what version of Word is this? >> I am working in an Access dB that has links (hyperlink) to >> a word document. The word document has a link back to >> Access. >> I have tried recording a macro to close the word document >> once the user leaves it. Have not been able to do so. >> Real problem is that the Access minimizes itself when word >> comes up. If I could find a way to keep Access maximized >> behind the word document, then my problem would be solved. >Cindy Meister >INTER-Solutions, Switzerland >http://homepage.swissonline.ch/cindymeister >http://www.mvps.org/word >http://go.compuserve.com/MSOfficeForum >This reply is posted in the Newsgroup; please post any follow >question or reply in the newsgroup and not by e-mail :-) >.
Sat, 09 Jul 2005 22:22:14 GMT

Cindy Meister -WordMVP #4 / 4	move between Access and Word, back to Access, Close word Hi Amy, Quote: > I am working in Microsoft Word > 2000. The database will run on a number of different > computers. Unfortunately, I will have no control over each > computer's software installation. Do you have control over the documents that are hyperlinked? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister http://www.mvps.org/word http://go.compuserve.com/MSOfficeForum This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Mon, 11 Jul 2005 03:35:14 GMT

Page 1 of 1

[ 4 post ]