Results 1 to 2 of 2
  1. 09-19-2011, 11:34 AM #1
    waqas
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Cool How can i know existing period

    dear all,
    i insert leave as below now if i am inserting sick leave between below period a message should appear you have already annual leave in this period.



    what should i do? which code should i write.
    LeaveStartLeaveEndLeaveTypID09-Sep-1117-Oct-11Annual Leave401748
    Reply With Quote Reply With Quote
  2. 09-19-2011, 11:36 AM #2
    waqas
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117
    sorry,

    09-Sep-11 to 17-Oct-11 Annual Leave 401748
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Getting Tax Period from current date
    By crxftw in forum Forms
    Replies: 3
    Last Post: 07-09-2011, 07:12 AM
  2. Allow a period in a table field name
    By escapades_access in forum Database Design
    Replies: 9
    Last Post: 07-08-2011, 09:21 AM
  3. Copying specific fields from one existing record to another existing record
    By GraemeG in forum Programming
    Replies: 0
    Last Post: 02-25-2011, 09:40 AM
  4. Help in Solving Warranty Period in Access
    By vdanelia in forum Access
    Replies: 4
    Last Post: 01-29-2011, 04:28 PM
  5. Count Items by Time Period
    By pawslover in forum Queries
    Replies: 1
    Last Post: 11-15-2010, 03:57 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums