Results 1 to 6 of 6
  1. #1
    princess12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    79

    Payroll System

    Hello, hope you all good,




    Well I have started a payroll system which is still in progress. Before i go further, i do not understand why March dates get filtered but not April. could someone please have a look and point me in the right direction. thank you a lot
    Last edited by princess12; 04-02-2015 at 05:28 PM.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    It appears to be working for me. How do you recreate the problem you're having?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    princess12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    79
    really, even the april month is working, i can't see mine april month selection working, that why i thought something is wrong

  4. #4
    princess12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    79
    ok i notice my results get filtered but i cant see it in the listbox showing despite it being there, therefore my listbox shows empty when it not

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    your form won't work if you choose the same date in both fields, and your combo box is restricting your data entry to a list (probably of dates in your table, I didn't look) so if you just type in the month it will populate with the first day of the month (both field's behavior is the same) so my guess is that you're not using different dates in the two fields. If you want results for a single day you'll have to modify your query.

  6. #6
    princess12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    79
    it ok rpeare, i fixed it, thank you, the dates comes from login activities, when they login and out anyways thanks, strangely these days my system is only working when i come on this forum for help, it somehow guides me to the right direction. sorry for the trouble. thanks for your help

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

Similar Threads

  1. Help with payroll form
    By visidro in forum Access
    Replies: 7
    Last Post: 10-22-2014, 04:49 PM
  2. Help with Designing Payroll Database
    By bgwool in forum Access
    Replies: 1
    Last Post: 04-04-2014, 03:53 PM
  3. Adding rolling sums to a payroll db
    By snipe in forum Database Design
    Replies: 2
    Last Post: 12-02-2013, 09:55 AM
  4. Payroll calculations
    By Rogue in forum Programming
    Replies: 5
    Last Post: 07-10-2013, 10:34 PM
  5. Problem with Module for Payroll
    By burrina in forum Modules
    Replies: 5
    Last Post: 10-22-2012, 04:28 PM

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