R
RG
Hi,
We have a system of infopath forms and an access database for employee's to
record timesheets. It's working very well except there is no mechanism to
prevent 2 timesheets being submitted by the same employee for the same week.
I'm not strong on coding so almost all the functionality of the infopath
form is achieved with the standard infopath features.
The timesheet form has a date picker to identify the week for which the
timesheet is being submitted. The date picker is restricted (by a small
piece of code) to select only mondays. My ideal solution would be as
follows;
Employee starts new blank timesheet form.
selects date from date picker
date picker code checks and corrects date to the monday of the selected
week.
date picker code (or infopath mechanism) queries the database to check a
timesheet with the same date/employee does not already exist - ideally this
will be a field 'onchange' type event rather than requiring any button click
by the employee.
Any guidance very much appreciated. Please reply to the newsgroup
cheers,
RG
We have a system of infopath forms and an access database for employee's to
record timesheets. It's working very well except there is no mechanism to
prevent 2 timesheets being submitted by the same employee for the same week.
I'm not strong on coding so almost all the functionality of the infopath
form is achieved with the standard infopath features.
The timesheet form has a date picker to identify the week for which the
timesheet is being submitted. The date picker is restricted (by a small
piece of code) to select only mondays. My ideal solution would be as
follows;
Employee starts new blank timesheet form.
selects date from date picker
date picker code checks and corrects date to the monday of the selected
week.
date picker code (or infopath mechanism) queries the database to check a
timesheet with the same date/employee does not already exist - ideally this
will be a field 'onchange' type event rather than requiring any button click
by the employee.
Any guidance very much appreciated. Please reply to the newsgroup
cheers,
RG