submit

[fb@rc]

I am looking for information on how to do a submit to a database for a
disconnected user. My users are often remote and fill-in forms disconnected
from the database. I want to have them submit the form to their local drive
when the finish it. Then when they reconnect I want to download everything to
the database without user intervention. Any suggestions?

 

[S.Y.M. Wong-A-Ton]

You need to look into building in a detection mechanism for the "online
status" of a form (see
http://office.microsoft.com/en-us/assistance/HA011227901033.aspx). Put this
mechanism in the OnLoad event handler of the form, and if a connection is
available whenever the user opens the form, run the code to update the
database.