Results 1 to 5 of 5
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    giving notification to users on the form


    Dear All,
    Kindly um working on timesheet application , Everything is running perfect and smoothly , But um thinking to put an option.
    This option is to pop out a window if the user didn't input his data in one day, So if he put data on tuesday and he forgot to put on Wednesday when he login on Thursday to put his data , There should be a window or message box " Please Note that you didn't insert 'The date' data ".
    Is it applicable ?
    Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,523
    capture the userID when the form opens to enter time
    txtBoxUsr = Environ("Username")

    then pull a query that shows missing dates < today
    show the query in a list box on the screen.
    if lstBox.listcount >0 then msgbox "You are missing entries for these dates"

  3. #3
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    Actually , I gave it a try but unfortunately , the query gives me duplicated records for all the dates which was entered by the users , Also how to control only a specific user with his dates only , not all the dates !

  4. #4
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    what i mean that i have table like this:

    username Date Comments
    Joan 20/3/2016 any comment
    Joan 22/3/2016 any comment
    Ann 21/3/2016 //
    Ann 23/3/2016 //
    Joan 23/3/2016

    so in Joan's records there is 21/3/2016 is missing and in Ann's records there is 22/3/2016 is missing
    how to generate these dates in an query and show each users his missing date ?

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Do you have a specification (some details) for WHAT your application will support?
    How do you deal with Holidays?? Are there codes for WHAT project people are working on?
    What about Leave(Vacation, Sickness......)?

    Date is a reserved word in Access.

    Hope this helps put the issue(s) into context.
    Good luck.

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

Similar Threads

  1. Form with VBA code giving Error
    By tgwacker in forum Access
    Replies: 1
    Last Post: 12-03-2013, 10:14 PM
  2. Replies: 6
    Last Post: 11-14-2013, 07:37 AM
  3. Replies: 11
    Last Post: 09-21-2013, 04:53 AM
  4. Email Notification
    By Ariuser in forum Programming
    Replies: 1
    Last Post: 01-20-2012, 03:44 PM
  5. query notification
    By imintrouble in forum Queries
    Replies: 3
    Last Post: 01-18-2012, 10:00 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
  •  
Other Forums: Microsoft Office Forums