Use InfoPath to Write to an Access DB or Excel and Generate a New Number per Record/ Row
I want to use an InfoPath form to write to one of multiple tables in access, or worksheets in Excel (I don't care which)
One sticking point is, I want the Infopath form to have something like a "Submit" button that writes to the Access or Excel files and creates a new record/ row with a unique number for each.
Of course we want significance in that number.... YY-XXXX, where YY is the two digit year the infomation was submitted, and 0001 would be the first submission. We would want XXXX to start over at 0001 the next year.
One sticking point is, I want the Infopath form to have something like a "Submit" button that writes to the Access or Excel files and creates a new record/ row with a unique number for each.
Of course we want significance in that number.... YY-XXXX, where YY is the two digit year the infomation was submitted, and 0001 would be the first submission. We would want XXXX to start over at 0001 the next year.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. Sorry for long delay.
ASKER