Comments:
Access is ideal for storing data you have collected from a DDE source and then querying the data. You can put a DDE link into Access but the process is quite complex.
After you have created the text box in an Access form, right click on properties. Click on the Data tab and select Control Source.
Right click on the control source option and select Build.
In the Expression Builder dialog box expand the functions option and then open the built-in functions file.
One of the functions available is DDE/OLE.
One of the choices available for the DDE function is DDE. I suggest you use the DDE function rather than DDEInitiate. It is here that you can enter your application, topic and item. Make sure you enclose them in double quotes.
After you have established the link, you will need to select it and choose OLE/DDE links from the Edit menu. You will then need to select it and click on the Automatic button to specify that the data is refreshed whenever new information become available.
Hope this helps.
|
