Access button to open word document

Access button to open word document. docx". Visible = True. Alternatively, you can choose OneDrive (previously known as SkyDrive) to open files stored on your OneDrive. If Dir (LWordDoc) = "" Then. doc" so that the directory and file name, including May 23, 2011 · AN. By checking this box, you’re allowing Word to open documents in the ‘Draft’ view by default. Aug 21, 2022 · Click the File menu. Kallal (Access MVP) Edmonton, Alberta Canada Set wDoc = wApp. Or, if Word is already open, select File > New > Blank document. It's useful if you're processing Word documents in a way that does not require user interaction (switching format, encoding, etc). Tip: Use the Search box on the Home, or Open, tabs to search for the file Apr 18, 2023 · Opening and closing a Word document from Access VBA. " in teh wizard that opens. Dictation, voice commands, and transcription. Select Computer, then click Browse. May 1, 2020 · Follow these steps to perform a full repair of your Office installation . FormFields ("txtLastName"). The path is shown below: Insert → Illustrations → Shapes. " Else. Choose Programs > Programs and Features. Click either view the Word file or edit it in Docs. Start by clicking the Save icon. Open the New page to create a new blank file, or browse for a template. You can also select one of the locations your accounts let you get to, sign in if necessary, and then open the file you want. The selected document will appear. Select the “Go…” button to finish. For more information, see Features available by Office application and project type. Dec 24, 2018 · Click the File menu. Click the Recover Unsaved Documents option. Click File > Download As then click on It's a quick and easy way to get your thoughts out, create drafts or outlines, and capture notes. . Alternatively, go to File > Save As to make a copy of the file. Aug 18, 2015 · Set appword = GetObject (, "Word. Jan 20, 2020 · I have Word and Excel 2019 on two PCs. Note: If you're using Windows 7, just click Start > Control Panel then you can skip to step 3, below. Visible = True Aug 28, 2020 · If you already have an audio file that you want to transcribe, you can upload it to Word. Please click Accept as solution if my post helped you solve your issue. This VBA procedure will open a Word Document from another MS Office program (ex. You can also change the file name and output directory path if you so choose. Jan 29, 2024 · Step 6: Change the default view. A quick way to access the “Open” backstage screen is to press “Ctrl + O”. Repair Word. 'Open Word. Access your documents from a computer, tablet, or phone via OneDrive. Application") If you want to just put additional information into a Word document, you could add an attachment field to your table and then attach a Word document to each record. Visible = True Data = "C Jan 5, 2023 · Here are six steps you can follow to open a Word document in Excel using a file converter: 1. Ctrl + Shift + Click app button Jan 11, 2024 · Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Word. Open a Word document. Select the Manage Document button. If you're working offline, your revisions will be saved the next time you connect online. Enter a password in the “Password” edit box and click “OK”. Construct your letter using "Insert Merge Field" drop down to select fileds from your table. Mar 26, 2016 · The shortcut key to access the Open screen is Ctrl+O. Choose a save option. The file might be locked because: The file is shared and another user is currently editing it. On the Info page, click "Manage Document" and then, from the drop-down menu, choose "Recover Unsaved Documents. Mar 16, 2023 · Step 1: Open the Word document you want to unlock and then click on the "Office" button. With the table open click on "Word Merge" in the "External Data" tab. You can open a document also by locating its icon in a folder window, which happens in Windows, not in Word. Press Ctrl+G to open the Immediate window at the bottom right. docx" strSQL = "SELECT * FROM![frmNavigationForm]![frmKYCGenerator] WHERE [RS ID]=" & [Forms]![frmNavigationForm]![Text78] Dim oApp As New Word. Step 4: In the 'Object' dialog box, select 'Create from File' and then click 'Browse' to locate the Word document Word for the web and Word desktop app for offline use. Select the ‘ Recover Unsaved Documents ’ option. At the left, next to "Destination," select Save as PDF. Copy/paste the following line into the Immediate window and press Enter at the end of the line: Dialogs (wdDialogToolsOptions). Sign in to Microsoft 365, and open Word. Alternatively, double-click the file’s icon in the “Open” dialog In the left margin next to your text, select the Copilot icon. For Word 2010 and Newer. Step 2: Click on the 'Insert' tab in the Excel ribbon. appword. 2. The Word interface. Select the template and then select the pin icon that appears next to the name May 16, 2024 · Here are the steps to change Word file permissions for Windows and Mac users. Dim wrdApp As Word. dot", ReadOnly:=True. Select OK > OK. com May 13, 2019 · I'm using Access 2013 and created a help button on a form that I would like to open up a Word doc with instructions. The file has been marked as Final and can no longer be updated. Select Options to open Outlook Options. doc" Set docWord = objWord. From here, you'll be able to create a new document, choose a template, and access your recently edited documents. Up to 6 TB cloud storage, 1 TB (1000 GB) per person. com. Typically, you will be able to open the file as read-only, but you won’t be able to edit it. Thanks Yes, we can help. At the top, click File Print . Jun 22, 2020 · As a quick workaround, try this: In any Word document, press Alt+F11 to open the macro editor. Dim filepath as String. Dec 9, 2021 · With your computer's internal microphone, or with a USB microphone in hand, you can dictate your document in Word on both Windows and Mac. Sep 28, 2015 · @DanielBonetti Yes, that makes sense. LastName. I recommend using a rectangle to symbolize a button, but you can choose the shape that you desire. Shift + Click app button: Open another instance of an app from the Taskbar. Open Control Panel - Programs and Features. Locate and select your document, then click Open. Step 4: Browse and Select the File: Click "Browse" and select the Word document you want to unlock. Path & "\empMemo. To Ralph Wilson cc. Then select the COM Add-ins option from the Manage drop-down menu. Select Word documents for recovery. Oct 21, 2021 · Sub Test() 'Add a command button to a new document Dim doc As Word. Then, go to the following location: Your Drive:\Users\Your Name\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup. This process may take a few moments, depending on the size of the document. From the Start Screen, locate and select Blank document to access the Word interface. Set doc = appword. office. Select the three dots next to Microsoft 365 and then choose Modify to see your repair options. Ctrl+Alt+F2: displays the Open dialog box. Opening the application only starts the process, but not the interface. Subject [access-l] Viewing a Word Document in Access with one click of a command button. Adding a shape for a button can be done through the insert tab. Begin the recovery process by clicking the Recover button one last time. Replied on May 23, 2011. Rename a document. If you have a tick present in front of every user, it means that access is not granted to all the groups. Text = "Add Some Text" Generally it’s best practice to open to a variable, giving you the ability to easily reference the document at any point. Set objWord = CreateObject("Word. 1) contains the document, double-click the document to open it in Word. docx), use. Set appword = New Word. The Backstage view displays several of your most recently accessed files. Hide. Aug 17, 2015 · Open the document to which you want to add an open password and click the “File” tab. In the "Home" tab, click the arrow next to "Dictate" and then select "Transcribe" from the menu that appears. Mar 23, 2022 · To access a document but leave its final paragraph mark behind, follow these steps: On the File menu, select New and then select Blank Document. On the Info tab, select Protect Document, point to Restrict Permission by People, and then select Restricted Access. Fine tune the table by entering details into the Copilot compose box about what to adjust in the table Jun 19, 2015 · Click the “Open Other Documents” link at the bottom of the “Recent” list. Open the file. You might have to hit "New" or "Open" to make the "Info" button clickable. The mobile version of Word lets you view (but not edit) Word documents. Click the Manage Document option. You can also use the keyboard Save command to launch the Save As window if you’re saving a new document for the first time. Select the Word document you want to recover, then select Open. 'automate word application. Is there a way to 'popup' it above my Access form? Nov 3, 2022 · Use Control + s or ⌘ Command + s to quickly save. You can select Regenerate to receive a new table or Discard to remove the generated table. Or, go to File > Save . The Open dialog box appears. Or, open Google Drive and browse through the folder the file is located in. Jul 24, 2023 · If not, please follow the below steps: Quit the Word app> Open the Finder> Click on the Command + Shift + G> Enter ~/Library/Containers> Scroll and move the Microsoft Word folder to the Desktop location> Restart your Mac> Open the Word and check the outcome. May 21, 2018 · LibreOffice is a full desktop app suite that aims to be a free, open source replacement for Microsoft Office. On PC-B I do not get a new window but a list of files and date modified. Select "Create a new document and then link the data to it. Review the available templates: You’ll notice several templates of interest at the top of the screen: Blank document – A blank Word document with the standard formatting. If Microsoft Word won’t open, try deactivating all add-ins. Open an existing file. I have this code to access a Word document and list all the Document Variables in a text-file: Private Sub Command0_Click() Dim DocN As String. Here are some other ways you can view Word documents on a Windows PC: Download Word Mobile from the Store on Windows 10. Then, instead of opening the report in Access, it can be outputted to RTF which will open it in Word. Path & "\Prospect Profiles\Account Profile Form. If the file you are seeking isn't on the Recent files list, select the Open button on the left navigation pane. Caption = "Click Here" 'Add a procedure for the click event of the inlineshape '**Note: The click event resides Click the Start button. Set wrdApp = CreateObject("Word. Number <> 0 Then. Open excel document in java. Alternatively, you can choose OneDrive to open files stored on your OneDrive. If you do this, be sure to remember that an Access database has a file size limit of 2GBs and when you attach documents to a file, the file can begin to grow rapidly. Click on Info. Select the file that you want to open and insert, and then select Insert. Click Proofing from the left pane and look for the Autocorrect options section, then click the Autocorrect options button. Jan 4, 2023 · Open Disk Drill. filepath = CurrentProject. docx""" It opens that document. Tip: Pin templates you like, so you always see them when you start Word. dot" so its saved as a word file type. Switch to the Smart Lookup tab, and place a checkmark next to the Use Microsoft Copilot to help May 31, 2012 · I will try also to open the Word Template as a new document from either a Windows application or another Access Database and then open Main database after all code in the Word document is finished running. It's not quite as full-featured as Word itself, but it's easily out-features any of the online solutions we've talked about. Click "Info" in the File menu. Select Blank document. Track and review changes. While in the insert tab, you click If the Documents list (or Files list in Windows 8. Exit the Registry Editor and start Word. Document. Search through the list of documents to see whether the deleted Word document is still there. Range(0, 0). In the ‘Web Options’ window, go to the ‘General’ tab and check the box next to ‘Allow opening a document in Draft view’. ”. Tip: To download a large Google Docs file as a . Click the Search for lost data button next to your storage device. These keyboard shortcuts instantly save recent changes. – Feb 7, 2024 · Step 3: Open with Google Docs. Double-click the icon to open the document. 'open word document. 1. Add Set shp = doc. N. AddOLEControl(ClassType:="Forms. Once in the permissions tab, click on the “Allow” button present on Full Control. In the File menu, use the following shortcuts: Open the Home page to access your recent, pinned, or shared files, create a new blank file or use a template, and search for a file, all on one page. Is there any way to to put a Word document in Access and let the end-user view it with the click of a command button. Below is a working code snippet that opens a Microsoft Word document, and goes to a specific index from the Table of Contents. Or, if Word is already open, select File > New. Premium templates, fonts, icons, and stickers with thousands of options to choose from. Go to File. If you've opened it recently, it might appear on the screen already. DOCUMENTS. In the Customize the Ribbon column on the right, select the custom group. arachchige\Desktop\Koshala. Open the document to be reviewed. pdf file on Chrome: On your computer, open a Google Doc. Select This PC, then click Browse. Open FileName:="C:\File Location\General Letter. Show. Alternatively, drag the file directly into the Google Docs window. Dim LWordDoc As String. Read Track changes to learn more. Share your documents and collaborate with others. Click on the “Edit” button to change the permissions. Add text, images, art, and videos. 'Path to the word document. Open Word. Select the Save option from to drop-down menu to save your file. To add a new location, click Add a Place. Type and choose "Control Panel". Alt + F8: Reveals typed password in Sign-in screen. Select Rename. Click on ‘File,’ then ‘Open,’ and navigate to the document you located in Step 1. You can use Call Shell "" to open up a file, you just have to work out the correct command line argument. com/downloads/ms-access-vs-ms-word/Open MS word file from MS Access using VBANext: fill in word with data fr Navigate to Backstage view, then click Open. Open the File menu. Document Dim shp As Word. If double-clicking doesn’t work, open Microsoft Word, click on ‘File,’ then ‘Open,’ and navigate to your document. When you open Word for the first time, the Start Screen will appear. Step 3: Select Upload: Choose the "Upload" option. Dec 31, 2023 · Part 1: Creating a Basic Document. Jun 13, 2019 · To open a Word document that you want to edit, click the file with the blue 'W' next to the filename from your Google Docs homepage. And it's a capable app. Mar 28, 2024 · You should see an icon for the file and the file’s name appear in the files and folders in the “Open” dialog box. Alt+F. Head to the Home tab and click "Dictate. Start speaking to see text appear on the screen. Your Word options will now open. Right-click on the document and select the Properties option from the menu. Alt+Shift+F2: saves the document. If you store the Word document in a SharePoint Library and then link the Library as a Data Source to your app, then you can Launch the 'Link to item' property of the Library File record. After completing these steps, the Answer: From your Access database, you can open any Word document that you wish. InlineShapes. Click the Open button. At the top, click 'Change'. In the left navigation bar, select Customize Ribbon. There is slightly more work involved in this. reg", and then save the file to the desktop. doc". Dim filepath As String. Double-click a template to open it. This file is residing somewhere in the filesystem, like in a user's documents directory. OpenRecordset("qryEmpFullName") ' open the memo document ' assume memo document in same folder as database fname = CurrentProject. To access recently opened documents, right-click the Word icon on the Nov 29, 2013 · Download sample file at: http://www. MyTextBoxWithPathToFile . Application") wrdApp. Attach files Jan 23, 2024 · Step 3: Use the ‘Open’ feature within Microsoft Word. Open "C:\test. Step 3: Select 'Object' from the 'Text' group in the 'Insert' tab. With Word you can: Create a document from scratch or from a template. Option 2: Start Word by using the /a switch Navigate to Backstage view, then click Open. See full list on support. The Open dialog box appears, showing you a list of unsaved Word documents that you can recover. ITtoolbox. Report abuse. Under Additional permissions for users, select the This document expires on check Press. Open(fname) objWord. This will attempt to fix the problem without you having to fully reinstall the app. This is something I Oct 16, 2019 · The quickest way is to click the Save button on the top of Microsoft Word. Feb 20, 2012 · Finally, if you want the userform to close when the button is clicked, the last command in the Click procedure should be Me. docx", AddToRecentFiles:=False. Dim oApp As Object. This is a useful alternative method to open a document if the first step doesn’t work due to file association issues or other technical problems. And when you go to save the file, just save it with the ". The "Transcribe" pane will open in the right-hand side of the window. MsgBox "Document not found. com in Chrome > Sign in with your work account > OneDrive > Shared > Shared with me, all the files shared with you by others are listed there, you could find the file and open it online. " When the microphone icon appears, you can drag to move it anywhere you like. Double-click the Recycle Bin on the Desktop. Jun 28, 2018 · You could try to open the file from your OneDrive online: Open Http://portal. Name the file "Wddata. If the search results don't contain the file, Check the recycle bin. Nov 12, 2020 · In the Word document you have open, select the menu item File and then click on Options. The Open dialog box will appear. Tip: If you want to bypass File > Open and always use the Open dialog box, do this: Select File Dec 11, 2023 · Click on the ‘Manage document’ Button. Choose Recover Unsaved Documents from the drop-down list. doc" from Access. When you run the macro in Word and save the document, you’ll see the results of the macro when you reopen your doc in Word for the web. Open a new or existing document and go to Home > Dictate while signed into Microsoft 365 on a mic-enabled device. Inserting a shape to serve as a button can be easy. On a Windows PC, use Control + s. Windows: Go to the location of the Word document. I prefer PDF myself but you can do both or Jul 25, 2016 · Private Sub Command203_Click() Dim mDoc As String Dim strSQL As String mDoc = "C:\~~~\800052 ENG w Macro titus. Open Filename:="C:\Documents\SomeWordTemplate. Research a topic and find credible sources. Jul 12, 2022 · To share a document so you can collaborate on it with others: first open it, then click the Share button in the upper-right part of the screen. Click Review and then on the Track Changes button, select Track Changes. Press the Windows key, type word, and click Open. Click the buttons in the interactive below to learn more Dec 13, 2020 · Go to the File tab and select Manage Document . Select File > Save as > Rename. It's available for Windows, Mac, and Linux operating systems. You can change the word document that will open by changing this line of code objWord. So the above code should pretty much open any document on your computer as if you actually browse to the particular document in question and double clicked on it. Jan 11, 2011 · If your going to open the same word doc everytime you press the button you could try. InlineShape Set doc = Documents. Application") objWord. Next, select the Office product you want to repair and then choose Change. Object. Use the arrow keys to place the cursor where you want to copy the text or graphic, and then press Enter to copy, or press Esc to cancel. iaccessworld. Open the Microsoft Word application: Double-click the Microsoft Word icon to open it. Also, an Open command button appears on the Quick Access toolbar. The “Encrypt Document” dialog box displays. On the Insert tab, select Object in the Text group, and then select Text from File. When you finish with the document, you can download your document back into DOCX, or PDF, ODT, TXT, HTML, or EPUB format. On PC-A, when I click File > Open > Folders and select a folder, I get a new window with Quick Access, This PC, etc on the left and the files in the folder on the right with details (name, date modified, type, size). To rename your document, you have two options: Select the file name at the top and type in what you want. Windows 10: Open Settings and select Apps & Features. LWordDoc = "c:\Doc1. Note: To create a custom group of commands, refer to Customize the ribbon in Office. Even though it’s called ‘Web Options’, this setting also affects other views. If Word starts and works correctly, you have resolved the problem (a damaged Word Options registry key). What is the correct syntax for this procedure? This thread Use the arrow keys to place the cursor where you want to copy the text or graphic, and then press Enter to copy, or press Esc to cancel. The report can be filtered based on the ClientID when the user clicks a button from the form with a simple macro or vba code. Opening a file. Dec 5, 2023 · Step 2: Access Upload Option: Click on the Folder icon to access the Upload option. FollowHyplerlink me. End If. 'Create an instance of MS Word. The following VBA code would open a document called "Doc1. Path = "C:\Users\koshala. Apr 8, 2024 · Use a tool within Word to fix it. At the top, click File Download. The gist of the code is. The file will download onto your computer. Feb 5, 2023 · Allowing you to interact with the document via the variable oDoc. Dim wrdDoc As Word. Select the unsaved document to recover. 07-06-2023 03:25 AM. Step 3: Choose "Password to Open" and then enter the password to unlock the document. Application Dim oMainDoc As Word. Private Sub CommandButton1_Click () Documents. Jun 7, 2007 · “Special_Egg via access-l” 06/07/2007 08:34 AM Please respond to access-l@Groups. Jul 7, 2022 · Right-click on the word document and select Properties. Message 7 of 7. How can I implement something like this in Java? Step 1: Add the Button to Excel. Click once to open it, or right-click and choose Open in new tab . Here's the code I tried: Private Sub cmdHelp_Click() Dim wrdApp As Word. In the Quick Access Toolbar drop-down, select More Commands. In it, type wordpad or write in the Open field and press Enter or OK. Windows 11: Open Settings and go to Apps > Installed apps. The following one line of code behind a button will open up that document: Application. This opens a new window called “Create new task. Content. You can also access When you’re working on a document with other people or editing a document yourself, turn on Track Changes to see every change. Choose a file type. Apr 22, 2024 · Step 3: Open the Document. An instance of the Office app is running in the background with the file already opened. 1") shp. Then follow the instructions for the desktop version of Word. filePath is a filepath, and strTopic is a value that links to the Table of Contents in the Word document. 0. If you have Word, first click Open in Word to open your document in Word. May 9, 2024 · Using the Word settings. Wait for the Dictate button to turn on and start listening. doc" file extension instead of ". Click Microsoft Office in the list of installed applications. With the left mouse button click on the Add-ins tab. Advanced spelling and grammar, in-app learning tips, use in 20+ languages, and more. Application. Right-click on the Word document in Google Drive, hover over “Open with,” and select “Google Docs. Result = Me. Double-click Computer to get to local files, including removable flash drives. Hi, Can anyone help me write a code on the Button to Open a MS Word File. In the Permissions dialog box, select the Restrict permission to this document check box, and then select More Options. So, if you want to open an existing document (*. To open a document. Application") If Err. After completing these steps, your old Word document Step 1: Open Excel and create a new or open an existing workbook where you want to import the Word document. This can be done using the code below: Sub main() Dim objWord As Object. Click Options, and then click File > Export. At last, if you create a new Word document in the OneDrive, do you still have the same 7. " Note also that you have an option for deleting all unsaved documents should you want to do that. From the menu, select Visualize as a table to have Copilot turn the text into a table. If you haven’t yet saved your file in OneDrive Feb 23, 2019 · I found on this forum the solution to open a Word document from Access: (Opening Word Document using VBA in Access 2013). OLEFormat. This will display file locations where you may find the file. This is a small but cool macro; you can attach it to a button or checkbox and then, whenever a user clicks the button or checkbox, have a specified Microsoft word document open. Open Word Document From Excel. upon clicking this button a pfd document or even a word document - which has been created by them by the merging of the fields of PowerPoint and word - will be presented/available for download or even downloads straight away to the user that has created this file. microsoft. Jun 6, 2022 · Using Access 365 VBA to open a Word Doc I need to open a Word document using VBA form a button on a form. Documents. H. Private Sub Command1_Click() Dim LWordDoc As String. : oDoc. On the File tab, select New. Choose the Quick Repair option and then choose Repair. Jul 6, 2023 · Go to Solution. Feb 19, 2021 · Launch Task Manager (Ctrl + Shift + Esc) and, in the File, click or tap “Run new task” in Windows 10 or “New Task (Run…)” in Windows 7. Click the icon to begin dictating, click again to stop or pause. Sep 28, 2022 · There are two ways to go about this depending on how you want to locate it: Open your Google Docs account and search or scroll through until you find the document. Ctrl+F2: displays the print preview area on the Print tab in the Backstage view. CommandButton. Select an icon. Opening a locally saved document. Save the recovered document right away. Albert D. I have a button in my Java application that, when clicked, should cause Word to open a particular file. First, open Microsoft Word and click the "Open" tab to choose the document you'd like to convert to an Excel spreadsheet. This will eliminate the problem of code running in the database I will need to open. Google Docs will create a copy of the Word document and convert it into a Google Docs format. Jul 30, 2021 · At the end of the screen a pdf button is seen. Drop your Shortcut into the Startup folder. On the Properties window, open the Security tab and click the Advanced button. Jun 7, 2015 · If you are opening a word document from another application, you would need to automate a word application first. This file can be found under the following path: "c:\Doc1. NOTE: If you already have a new or existing document open and want to open another document as read-only, click the “File” tab and then click “Open” on the backstage screen. Click Edit > Delete, then click Yes. Select Blank document Mar 27, 2013 · I have a subroutine in MS Access that opens a specific word doc file. Excel): In Word for the web, you have to step through such tasks manually. Mar 29, 2012 · Creating a button in Access to to open a word document. Windows Mac. On the “Info” backstage screen, click the “Protect Document” button and select “Encrypt with Password” from the drop-down menu. Me. To open a file in the selected folder, click the file’s icon and then click the “Open” button in the lower-right corner of the “Open” dialog box. Dec 4, 2023 · Open context menu for the active window. Word marks all additions, deletions, moves, and formatting changes. On the resulting dialog, click 'Repair' - choose the Online Repair, it is a comprehensive fix. If you’re using a Mac, hit ⌘ Command + s. Jun 17, 2016 · First, create a shortcut of the Document and place it on (say, Desktop). If you want to open the Word UI you need to specify it. However, when you cold boot your computer, your Desktop will first show up and then a few seconds Select File > Open, and select the document you want. Feb 4, 2014 · The easiest method would be to make a report with the information you need. Call the Open method of the Documents collection and supply a path to the document. In the pop-up window, you will see a list of your unsaved documents. Find the document you located earlier and click ‘Open’ to bring it up in Word. When you click ‘Open,’ you’ll be given the option to browse your computer’s files. The second you launch Disk Drill, you notice that it certainly doesn’t look like your average data recovery tool. Or You can dim and create a word application and then open a file. Open (Path, , True) With doc. DocN = "Demo use of variables. F3. MS Access Form button that allows user to browse/choose file, then imports file to a table. Jun 19, 2020 · Microsoft once offered a free "Word Viewer" application that would let you view Word documents, but discontinued it back in November 2017. When teh doc opens in Word go to the "mailings" tab. Step 2: Click "Save As", and then tick "Tool Button > General Options". button click: Shell "winword ""c:\\Handout. At the top, click Save. Apr 29, 2009 · OpenWord ' use function to open Word 'Open recordset based on employee name query Set dbs = CurrentDb() Set rstEmployees = dbs. Document Dim sData As String oApp. Here's how to save a Microsoft Word file. lb rh nq hy pc ym st ry ip sw