N
NDerakshan
Hi Im new to Infopath Scripting,
Im using your example on Adding records to Access via VBScript on your
Infopath:
http://enterprise-solutions.swits.n...tically-add-db-record-vbscript&c=infopath2003
Using the four fields as shown works fine, however once I add additional
fields from the form to submit to my access database the records get saved to
the database but not in the same order? Only the first four records are in
order? Any reason why this is happening? I tried clearing all variables when
form loads.
Is there a command (similar to SQL insert) to make sure that each field is
saved to the corresponding field in the access database, rather than using an
array
objNewPlayerNode.attributes(1).text = strNewPlayerFirstName
Any help on this would be greatly appreciated!!
Nima Derak
Im using your example on Adding records to Access via VBScript on your
Infopath:
http://enterprise-solutions.swits.n...tically-add-db-record-vbscript&c=infopath2003
Using the four fields as shown works fine, however once I add additional
fields from the form to submit to my access database the records get saved to
the database but not in the same order? Only the first four records are in
order? Any reason why this is happening? I tried clearing all variables when
form loads.
Is there a command (similar to SQL insert) to make sure that each field is
saved to the corresponding field in the access database, rather than using an
array
objNewPlayerNode.attributes(1).text = strNewPlayerFirstName
Any help on this would be greatly appreciated!!
Nima Derak