Steps for setting up the WinWedge:

1. Select "DDE Server" from the "Mode" menu in the Wedge. When the dialog box appears asking for a DDE Command Destination Application, enter: "MSACCESS" as the Application Name and the name of your open database (without the MDB Extension) as the DDE topic.

2. Select "Input Record Structure" in the "Define" menu and define the structure of the input data to WinWedge. When you get to the final Window entitled "Input Record Definition Editor", enter the string: [GrabData] as the Field Postamble DDE Command after the last data field that you have defined. This is a DDE command that will be sent to MSACCESS after each data record is received by the Wedge.

3. Set up the rest of the Wedge as needed for your serial device and then activate it.

Steps for setting up MS ACCESS:

MSAccess does not have a "GrabData" DDE command so the first step is to create one. When you define a macro in an Access database, the name of the macro automatically becomes a valid MSAccess DDE command for as long as the database is open.

1. Create a new macro that performs the "RunCode" Action. For the function name that is required by the RunCode action, enter the name "GetWedgeData()". Save the macro with the macro name "GrabData" and finally, create a new module with a function named "GetWedgeData()" and enter the following commands in the body of the function:

Function GetWedgeData ()

The example above sets up the Wedge to issue a DDE command consisting of the name of an Access macro (directly to the Access database that contains the macro) after each data record is received from your serial device. The macro calls an Access VBA function that performs a DDERequest back to the Wedge and returns the contents of FIELD(1) to a variable named "MyData". It then updates Form1 with the data.

Launching And Terminating WinWedge From Access
Collecting Data Directly into a Table in an Access Database
Transmitting Variables Out The Serial Port From Access