Email Notification

[David]

Hi,

I currently have an access database from which data is inputted using
InfoPath forms, the database is then accessed by an administration team to
view the data that has been sumitted.

They currently have to refresh the list view form to see any new records
which does not take much time but can be overlooked meaning that work is
slowed down if the administration agent forgets to refresh frequently.

Is there any way of the administration team being emailed when a new record
has been submitted to the database, if this is not possible is there any
other way of being notified of new records?

I look forward to receiving any help.

Thanks

 

[Arvin Meyer [MVP]]

Hi,

I currently have an access database from which data is inputted using
InfoPath forms, the database is then accessed by an administration team to
view the data that has been sumitted.

They currently have to refresh the list view form to see any new records
which does not take much time but can be overlooked meaning that work is
slowed down if the administration agent forgets to refresh frequently.

Is there any way of the administration team being emailed when a new
record has been submitted to the database, if this is not possible is
there any other way of being notified of new records?

You would have to do the data entry in an Access form, not InfoPath.
Access/Jet tables (or any other native file-server tables) do not have
Triggers to be able to process events.

You could, if the administration team is using an Access form, tell the form
to refresh or requery using a Timer event with a reasonable TimerInterval.

 

[David]

Hi,

OK I understand, wish I could do the entry with an access form but the
people entering data cannot be given access to the data once it has been
inputted to secure the data they have entered and comply with the Data
Protection Act in the UK.

How would I refresh or requery at timed intervals, this is something I have
never done before.

Thanks

 

[Arvin Meyer [MVP]]

Hi,

OK I understand, wish I could do the entry with an access form but the
people entering data cannot be given access to the data once it has been
inputted to secure the data they have entered and comply with the Data
Protection Act in the UK.

Using queries bound to read-only forms, you can limit what users can see and
edit

How would I refresh or requery at timed intervals, this is something I
have never done before.

It can only be done from an Access form.