Results 1 to 2 of 2

Automatic Task Assignment & Email Alert to Respective User

  1. #1
    Niks2507 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018

    Automatic Task Assignment & Email Alert to Respective User

    Dear Team,

    I'm Very New to Access but trying to develop a Data Entry & Tracking tool to be used in MultiUser Environment.

    Backend will be on Shared Network Drive

    · IDEAof Process Flow - Create ProductID >Automatically Create NPDID > once NPDID is created assign Task of Data entryto each Department Automatic by Email
    · Total10 Department need Data Entry … Assigned Option Group setting on“FrmNPDMainTrial”
    · “FrmNPDMainTrial” is main form for Multi Department Data Entry
    · NeedAssign User Access setting – Has Achieved the requirement by controlling enableproperty of “CmdEditRecord” on each DataEntry Form
    · NeedAudit Trail Report – Achieved this … “Audit Trail Report” currently iscapturing “Network User Name”, however Sign in is through Access Table “Tbuser”data. How can “Network User” can be changed to “Access Table”?
    · FacingProblem in Data Synchronization of 02 Subform of “FrmOSmain” under Option Group “OS” on“FrmNPDMainTrial”. Also need functionality of Insert new ROW for Same“ThirdpartyID” in Subform “ChildTP”, if they have different Client Data &similarly in “ChildAPI”, if have different API Sources. Also how to designREPORT accordingly to Show 1 row only for 01 record of 01 ThirsPartyID but ifNo of Rows increase, Automatically increase ROW nos. in Report.
    · AnyChanges in Data …. Email Alert to all 10 User Department.
    Any Help in Correcting errors & Right Modules suggestion for Professional Performance of Tool is highly appreciable.

    I have also posted same query at UtterAccessforum & link is below

    Thanks & Best Regards
    Attached Files Attached Files

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    Thanks for noting the cross post of the question. That helps a lot.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 04-09-2018, 03:50 PM
  2. Replies: 1
    Last Post: 11-22-2015, 03:36 PM
  3. Email Tracking Task
    By raminrooz in forum Access
    Replies: 1
    Last Post: 04-28-2012, 05:29 AM
  4. Alert user when inventory below minimum
    By Micky in forum Access
    Replies: 5
    Last Post: 04-06-2012, 02:14 PM
  5. Automatic Email
    By Peacekeeper in forum Access
    Replies: 8
    Last Post: 11-03-2011, 09:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums