Product Manual

22
Microsoft Access
A simple way to obtain DDE data in Microsoft Access is to create a form. Within the
form create a text display box. In the properties setting for the text box select the
"Control Source." Type the following:
=DDE("WINDDE", "SCALE", "STR")
This will make the weight string appear in the text box when the form is opened. This
method will only obtain the information when the form is opened. The display will not
update automatically. Access provides several commands that can be used for DDE
communications. You may create a button on a form to zero the scale. Create an
event procedure for the button as follows:
Sub Zero_Click ()
On Error Resume Next
Dim chl
chl = DDEInitiate("WINDDE", "SCALE")
DDEExecute chl, "Zero"
DDETerminate chl
End Sub
The Win-DDE Server responds to the "Zero" command by zeroing the indicator if it is in
zero range. The command, "Switch Lb/Kg" may also be sent to the server to switch
between pounds and kilograms.
Win-DDE Weight Indicator
A DDE client program “Win-DDE Weight Indicator” is provided with the “Win-DDE”
server. The program provides simple weight indicator functions on the computer. The
Win-DDE server may be used without running this program.
To start the “Start” button on the task bar. Select “Programs”, “WinDDE”, and click
“WinDDE Client Indicator.”
The weight indicator will appear.