StrHold = "" 'Remove this if you want to paste same data into multiple locationsġ) Command buttons to a)Clear txtWorkspace, b) Paste to txtWorkspace, c) Clear strHold which is done by clicking txtWorkspace without selecting anythingĢ) Is the autoClear of strHold desired (Line 4 of GotFocus code, above)ģ) Automate selection of target textboxesģa) Have a list of textboxes to fill from documentģb) On each MouseUp, the next textbox would be filled, without having to click it
#OUTLOOK 2007 AUTOPURGE HOW TO#
I just don't know how to crawl inside Outlook to figure out what it's doing so I can replicate it in Access.Īgain, any help is greatly Private Sub txtTarget_GotFocus() However, as I noted in my previous post, Outlook 2007 has a preview feature for Word 2007 files just like I want for my Access form. I thought someone else might be able to tell me. Unfortunately, I don't know where the equivalent Word component is, or what it's called. Just like there is a "Microsoft Office Spreadsheet 10.0" ActiveX control exposed by Excel to handle spreadsheets, I was looking for something similar for Word. I figured there had to be a component/control exposed by Word 2007 already on my computer that I could put on my Access form that would be able to handle all of the Word table formating. Therefore, a regular textbox wont fit the bill. The information in the table gets smashed together and it's almost impossible to find the information I need. If I try to load this information into a regular textbox, all of the table formating (such as the column alignment and background shading) is lost. The data I want from the Word 2007 files exists in "tables" (i.e. Second, when you say "workspace window", what kind of control do you have in mind? A regular Access textbox or something else? But after reading my own post, maybe this is harder than I realized.įirst, thanks for taking the time to read and respond to my post. At first this seemed like it should be easy to do. But I was hoping to find a more efficient approach since I have so many Word documents to import. Of course I could always open the Word and Access applications side by side on my computer and copy/paste the data that I need. Kind of like the preview feature in Outlook 2007 that displays Word attachments on the email form. I need a visual control I can put on a Access form to allow me to see the document and determine where the information is that I want. Therefore, each document will be unique enough that I can't automate the import process. But this doesn't really help me because the Word documents I will receive are coming from various agencies and individuals who will each, I'm sure, edit the document to their liking.
#OUTLOOK 2007 AUTOPURGE CODE#
I already know how to use code to create a new Word object (which launches an instance of Word) and manipulate the Word document.
I don't see anything suitable in the list of available Active X components. Problem is, I don't know what control to use for my Word "window". This way I can use the Word "window" at the bottom of the form to scroll through the document, find the information I want, and then copy/paste the information into the bound controls at the top of the form. I would then place other "standard" Access controls on the top half of the form that would be bound to my Access table. To facilitate the import process, I was thinking of creating a form in Access that would have a Word control (or "window") at the bottom of the form that allows the me to view/preview the Word document. My office is about to receive 100+/- Word 2007 documents that contain data that needs to be imported into various fields of an Access 2007 table. Does anyone know how to go about adding a control to an Access 2007 form that will allow viewing a Word 2007 document?