DD's Employee Example


Employee Example Gallery


Downloads

Employee Example V5

Employee Example V4

Employee Example V3


DD's Stats

Members
Total Members: 114
Latest: kokowawa0100@yahoo.com
New This Month: 8
New This Week: 0
New Today: 0
Stats
Total Posts: 727
Total Topics: 351
Most Online Today: 1
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 0
Total: 0

Recommended Posts

DD Approved Members group Added by DD Admin
05-06-2020, 12:48:35


Posting Additions or alterations rules by DD Admin
27-02-2020, 10:33:01


A Trip Down Memory Lane by DD Admin
24-08-2019, 14:17:16


Todays Birthdays

DD's Top Posters

DD Admin
Posts: 754
borobutch
Posts: 51
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: Employee System Example V4 Errors And Corrections  (Read 408 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 754
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 15
Re: Employee System Example V4 Errors And Corrections
« on: September 07, 2019, 10:36:55 am »
I was going though my project management system updating the holiday planner to current version when I noticed the holiday report was showing all entries for all years as my project management system goes back a lot of years it was a lot.

so I made the following change to the query: qryHolidayListReport

I added a new field with the expression: HYear: Year([StartDate]) you can call it what you like

And A Criteria: Year([Forms]![frmHolidays]![txtDate])

For those new to access what this does is limits the output of the report to the current year being viewed on the holiday planner, I didn't think it needed a date range popup.

P.S. I used the start date only as I was only interested in holidays starting in a given year.

hope you find this of use mick
« Last Edit: November 17, 2019, 10:59:26 pm by Michael »

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
484 Views
Last post February 22, 2019, 07:29:00 pm
by DD Admin
10 Replies
202 Views
Last post September 01, 2019, 11:14:46 pm
by DD Admin
0 Replies
22 Views
Last post October 14, 2019, 09:47:50 am
by DD Admin
2 Replies
33 Views
Last post April 08, 2020, 07:58:55 pm
by DD Admin
6 Replies
17 Views
Last post August 05, 2020, 09:56:59 pm
by borobutch

DD's Downloads


Development Schedule

DD's Freeware

Chart Tracker Elite 32Bit

Chart Tracker Elite 64Bit

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

Project Manager (accde)


Developer Tools

Project Manager (accdb)

Style Manager

Code Library


Open Code Templates

Master Template

Task Management

Charitable Contributions

Bug Tracker Template

Time And Billing Template

Real Estate Template

Household Inventory V1


Open Code Examples

DD's Northwind V1

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples

Member Examples


Recent Topics

DJ 2020 Project Status by DD Admin
September 22, 2020, 10:45:01 pm

UK Singles/Albums Charts 11 Sep 2020 to 17 Sep 2020 Analysis by borobutch
September 22, 2020, 12:58:29 pm

UK Singles/Albums Charts 04 Sep 2020 to 10 Sep 2020 Analysis by borobutch
September 20, 2020, 07:17:30 pm

New Badge Added by DD Admin
September 19, 2020, 04:02:54 pm

Please welcome kokowawa0100@yahoo.com to DD by DD Admin
September 19, 2020, 03:03:34 am

Please welcome lookforsmt to DD by DD Admin
September 18, 2020, 08:14:13 am

Please welcome dennisbowman to DD by DD Admin
September 15, 2020, 02:34:01 am

Database Dreams is not affiliated with Microsoft