?
Solved

OLE or DDE exchange Word 6 to Access 2

Posted on 1997-12-03
1
Medium Priority
?
347 Views
Last Modified: 2008-02-01
I have a Word 6 online form with text fields and dropdown boxes for input, how do I link the text fields to an Access 2 database table or form by OLE or DDE so a button click exchanges the data automatically?

Background:

Computer Telephony Integration using Windows95 TAPI to 'Screen Pop' a Word 6 script for agents to input data into an online form to exchange, create or update an Access 2 backend database.

Thanks in advance
0
Comment
Question by:MattWilliams
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
robandrw earned 200 total points
ID: 1605511
I suppose this is an answer that you expected to get but I risk stating the obvious. One wonders why you are not using an Access form to input the data. Would save many hassles.

Anyway, you can't use OLE as Word can only act as an OLE Server, not a Client. Which means that you have. There are many examples in the MS-Acces 2.0  and MS-Word help files under search topic  DDE. In the MS-Access help file there is a complete section on using MS-Access as a DDE server.

Thje following piece of code (courtesy the MS Access help file) shows a word basic macro that access a MS-Access data base.

Sub MAIN
' Using the System topic, open the NWIND.MDB database.
' The database must be open before you can use other DDE topics.
      Chan1 = DDEInitiate("MSAccess", "System")
      DDEExecute Chan1, "[OpenDatabase C:\ACCESS\SAMPAPPS\NWIND.MDB]"
' Get all the data from the Customer List query.
      Chan2 = DDEInitiate("MSAccess", "NWIND;QUERY Customer List")
      MyData$ = DDERequest$(Chan2, "All")
      DDETerminate Chan2
' Close the database.
      DDEExecute Chan1, "[CloseDatabase]"
      DDETerminate Chan1
' Insert the data into a text file.
      Open "MYDATA.TXT" For Append As #1
      Print #1, MyData$
      Close #1
End Sub


0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question