C
Casey
Hi,
I've been searching for the holy grail of disconnected data for some 10
years now. Starting with home grown text export import (VB), access
replication(terrible), sql server replication (excellent).
My last effort had com add-ins for word document- a recruiting form-
that had fields and drop downs (filled with data from sql server
database).The document was emailed to the applicant who used Word to
fill in the boxes and returned the doc to the HQ where the data was
uploaded to SQL server. The HQ user could refresh the bound form
reference data from sql server from the com add-in in Word.
Infopath provides a richer interface and many alternatives. Could
someone please give me a signpost as to the best way of accomplishing
the above.
1. Fixed data for combo box controls etc downloaded from SQL
2. Offline user not connected to the server receives form by email
3. The data is then uploaded to SQL server
4. The HQ user can refresh the form fixed data if this changes.
I assume that the form fixed data will be in the form of XML doc, but
how does the user (ocasionally) refresh this data without calling for
help from IT staff?
Thanks,
Casey
I've been searching for the holy grail of disconnected data for some 10
years now. Starting with home grown text export import (VB), access
replication(terrible), sql server replication (excellent).
My last effort had com add-ins for word document- a recruiting form-
that had fields and drop downs (filled with data from sql server
database).The document was emailed to the applicant who used Word to
fill in the boxes and returned the doc to the HQ where the data was
uploaded to SQL server. The HQ user could refresh the bound form
reference data from sql server from the com add-in in Word.
Infopath provides a richer interface and many alternatives. Could
someone please give me a signpost as to the best way of accomplishing
the above.
1. Fixed data for combo box controls etc downloaded from SQL
2. Offline user not connected to the server receives form by email
3. The data is then uploaded to SQL server
4. The HQ user can refresh the form fixed data if this changes.
I assume that the form fixed data will be in the form of XML doc, but
how does the user (ocasionally) refresh this data without calling for
help from IT staff?
Thanks,
Casey