DECLARE Long DEVICETODESKTOP IN adofiltr.dll ; String desktoplocn, String tablelist, ; Long sync, Long overwrite, String devicelocn DBintRetVal = DEVICETODESKTOP(txtDesktopDB.Text, "", 0, 1, txtPPCDB.Text) If intRetVal <> 0 ...BTW, you can use < pre > and < /pre > tags (w/o spaces) to preserve code formatting.
>Declare Function DEVICETODESKTOP Lib "adofiltr.dll" _ >(ByVal desktoplocn As String, _ >ByVal tablelist As String, _ >ByVal sync As Boolean, _ >ByVal overwrite As Integer, _ >ByVal devicelocn As String) As Long > >Dim intRetVal as integer >'upload from the local DB to the desktop >DBintRetVal = DEVICETODESKTOP(txtDesktopDB.Text, _ >"", False, True, txtPPCDB.Text) >If intRetVal <> 0 _ > Then msgbox "An error occurred transferring the data" _ >Else _ > msgbox "Upload Successful"_ >End If >Exit Sub