Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 22 votes, 4.91 average. Display Modes
Old 12-03-2013, 10:42 PM   #61
osmosisgg
Newly Registered User
 
Join Date: Dec 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
osmosisgg is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

The change had been made and is still not calculating
I searched all modules and could not find anything else to change.

osmosisgg is offline   Reply With Quote
Old 12-09-2013, 04:23 PM   #62
dyfink
Newly Registered User
 
Join Date: Oct 2013
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
dyfink is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Quote:
Originally Posted by McSwifty View Post
Still here and using this at work on a regular basis. Give it a go and let me know if you have any problems

Dyfink. Missed your post. can't find the files. Must have cleaned it my Google drive and deleted them. I will see if I can find what u did to put the color in the table.
No problem. I figured it out. It was a really good idea. I ended up needing to understand how the code was working anyway because I also made some changes to add Holidays, hire dates and termination dates to the calendar for perspective. (They aren't perfect, yet.) I also added the ability to enter a string of event across a number of day. For example if someone is taking a week vacation you only have to enter "Vacation" and the reason once.

And of course the best part of doing this tracking in Access instead of buying a program or paying for a cloud program is combustibility. I managed to get it to import Employees, Absences, and Vacation or Personal days (based on paychecks).

Again, thanks oxicottin for an awesome database,
dyfink
dyfink is offline   Reply With Quote
Old 12-11-2013, 02:06 PM   #63
BAM7209
Newly Registered User
 
Join Date: Dec 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
BAM7209 is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Quote:
Originally Posted by McSwifty View Post
ok, if you change the attendancecode in tblcalinput you also need to change the color details in module basYearView under loadReportCalendar to match those new codes you have in tblcalInput or the calendar view does not display any color markers for the days in question.

the limitation I have found is having hours for one type of leave and days for the other, it would mean two types of tracking data for each staff member. not a big deal but a little more work. I have found hours works pretty well but as Rach wanted days I changed it all over.

The version below is just the standard download by oxicottin and i added the time tracking to it.

Just be aware of the date issue like I put in post #45 if you have system setting to US date format then you won't have any issues, if you do it will take a little bit of work to sort. mostly for the inputbox that comes up when you click on a date for entering data.

This is a great database. I made changes to the colors in the basYearView module and it the colors show on the report, but the form is not showing the colors. The form itself either shows no color or it shows as black.
Can you help me with that?

BAM7209 is offline   Reply With Quote
Old 12-11-2013, 02:36 PM   #64
McSwifty
Newly Registered User
 
McSwifty's Avatar
 
Join Date: Jan 2010
Location: Chch, NZ
Posts: 67
Thanks: 3
Thanked 9 Times in 9 Posts
McSwifty is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Quote:
Originally Posted by BAM7209 View Post
This is a great database. I made changes to the colors in the basYearView module and it the colors show on the report, but the form is not showing the colors. The form itself either shows no color or it shows as black.
Can you help me with that?
I forgot about the form colors, try the Public sub SetCalendar in the frmCalendar form. It needs the same names and colors as in basYearView.
__________________
Kev

I reccommend the following for help.

Database Solutions & Downloads for Microsoft Access | databasedev.co.uk
Microsoft Access help, tutorials, examples | allenbrowne.com/tips.html

They helped me a lot in the beginning.

All the best with your Project.
McSwifty is offline   Reply With Quote
Old 12-13-2013, 02:01 PM   #65
osmosisgg
Newly Registered User
 
Join Date: Dec 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
osmosisgg is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

McSwifty,

After some sleep, it became clear that as beautiful as the db was designed, I would like to use rptyearview. So, qryYearView works fine as I do get appropriate results.

My issues are now:
1. a prompt for the parameter inputdate comes up and I can't see where it is coming from

2. when I open up the rptYearView, the below in red states VBA compile error, variable is not defined. I am just not sure what/where I have to define it.

Please help - I don't want to sleep on it again and come up with some other braniac idea that I don't need it at all LOL!

Thanks much - osmosisgg
Function getCalendarData() As Boolean
Dim rs As DAO.Recordset
Dim strDate As String
Dim strCode As String
Dim strSQL As String
Dim UserID As String
Dim LeaveDateFrom As String
Dim qdf As DAO.QueryDef 'sunday

Dim i As Integer
Set qdf = CurrentDb.QueryDefs("qryYearView")
qdf("employeehours.employee") = employeehours.employee
qdf("employeehours.year") = employeehours.Year

Set rs = qdf.OpenRecordset()
Set colCalendarDates = New Collection
With rs
If (Not .BOF) Or (Not .EOF) Then
.MoveLast
.MoveFirst
End If

If .RecordCount > 0 Then
For i = 1 To .RecordCount
strDate = .Fields("leavedatefrom")
strCode = .Fields("AttendanceCode")

colCalendarDates.Add strCode, strDate
.MoveNext
Next i
End If
.Close
End With
'// return date collection
Set rs = Nothing
End Function
osmosisgg is offline   Reply With Quote
Old 12-16-2013, 11:45 AM   #66
osmosisgg
Newly Registered User
 
Join Date: Dec 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
osmosisgg is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Ok- I found where the prompt for the parameter inputdate came from - it was was in the group and sort. I removed it.

I am still having issues with define variable.

Any help is greatly appreciated!

osmosisgg
osmosisgg is offline   Reply With Quote
Old 12-16-2013, 11:47 AM   #67
McSwifty
Newly Registered User
 
McSwifty's Avatar
 
Join Date: Jan 2010
Location: Chch, NZ
Posts: 67
Thanks: 3
Thanked 9 Times in 9 Posts
McSwifty is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Sorry everyone. Been flat out with work due to xmas. Will see what I can do to help but not a lot of time. Might have to leave it until the new year.

McSwifty is offline   Reply With Quote
Old 02-21-2014, 02:24 AM   #68
Clott
Newly Registered User
 
Join Date: Jul 2013
Posts: 8
Thanks: 3
Thanked 0 Times in 0 Posts
Clott is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Hi
I am hoping to use the attendance tracker posted by Oxicottin. However, our holiday year runs from September to August. I need to change it so that vacation days left in the year are calculated correctly. Is there an easy way to do this?
Many thanks
Claire
Clott is offline   Reply With Quote
Old 04-04-2014, 11:23 AM   #69
oxicottin
Newbie
 
oxicottin's Avatar
 
Join Date: Jun 2007
Location: West Virginia
Posts: 495
Thanks: 16
Thanked 43 Times in 11 Posts
oxicottin is on a distinguished road
Send a message via AIM to oxicottin
Re: Yearly Attendance Tracker/Calendar

To everyone who used my old attendance DB. I have a new version which is completely different come take a look...

[
Enjoy.....
__________________
If guns cause crimes, spoons make you fat....
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by oxicottin; 09-03-2019 at 10:35 AM.
oxicottin is offline   Reply With Quote
The Following 3 Users Say Thank You to oxicottin For This Useful Post:
Clott (04-07-2014), jguesman (04-29-2014), Rach! (08-12-2014)
Old 04-29-2014, 02:16 PM   #70
jguesman
Newly Registered User
 
Join Date: Apr 2014
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
jguesman is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

I am trying to download this database as it's exactly what I have been looking for. Is there any way that you can email it to me? It's still waiting for approval and I want to get started asap. I have to make a few changes to match my leave codes.
jguesman is offline   Reply With Quote
Old 04-30-2014, 07:29 AM   #71
oxicottin
Newbie
 
oxicottin's Avatar
 
Join Date: Jun 2007
Location: West Virginia
Posts: 495
Thanks: 16
Thanked 43 Times in 11 Posts
oxicottin is on a distinguished road
Send a message via AIM to oxicottin
Re: Yearly Attendance Tracker/Calendar

Quote:
Originally Posted by jguesman View Post
I am trying to download this database as it's exactly what I have been looking for. Is there any way that you can email it to me? It's still waiting for approval and I want to get started asap. I have to make a few changes to match my leave codes.
When you are able to download I just updated the database to 4.2.... today!
__________________
If guns cause crimes, spoons make you fat....
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
oxicottin is offline   Reply With Quote
Old 04-30-2014, 12:27 PM   #72
jguesman
Newly Registered User
 
Join Date: Apr 2014
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
jguesman is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Quote:
Originally Posted by oxicottin View Post
When you are able to download I just updated the database to 4.2.... today!
OK......I just tried again today and it's still pending approval. I think I will just download the older version so that I can get started. If you are able to email me the current version please do so at jguesman14 at gmail.com. Thanks!
jguesman is offline   Reply With Quote
Old 06-04-2014, 02:36 AM   #73
McSwifty
Newly Registered User
 
McSwifty's Avatar
 
Join Date: Jan 2010
Location: Chch, NZ
Posts: 67
Thanks: 3
Thanked 9 Times in 9 Posts
McSwifty is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Thanks oxicottin for the update. I love the option to have up to 5 concurrent attendance notes on the same day - modified in the form subformCalendarInputBox oncurrent() code.
I did have to enable the vertical scrollbar to be able to move down the page, either that or tabbed to the next record each time.

One thing that would be a nice option is to show the last 12 months and not a calendar year. The old version I made it so that the current month is the last on the screen ie. the bottom right.
Once I look through the code I am sure it will come to me.

Thanks again.

FYI - for those without Outlook v15 you may get errors with the code for sending an email and a missing reference in the VBA references. I commented out the code in mod_ShortcutMenuCommands Just comment out Public Function EmailAsPDF() and unticked the reference; at least you can view the database without error then.
McSwifty is offline   Reply With Quote
Old 06-12-2014, 12:44 AM   #74
megatronixs
Newly Registered User
 
Join Date: Aug 2012
Posts: 708
Thanks: 156
Thanked 4 Times in 4 Posts
megatronixs is on a distinguished road
Re: Yearly Attendance Tracker/Calendar

Hi oxicottin,

I found your nice database and like it a lot, the only thing is that I still use access 2003 and would like to be able to make some changes to it. Is there a possibility to get the 2003 version unlocked so I can see how everything works? I want to learn and at the same time create something for my team based on your version.

Any possibility to get the unlocked version would be really great :-)

Thank you and greetings.
megatronixs is offline   Reply With Quote
Old 06-12-2014, 06:51 AM   #75
oxicottin
Newbie
 
oxicottin's Avatar
 
Join Date: Jun 2007
Location: West Virginia
Posts: 495
Thanks: 16
Thanked 43 Times in 11 Posts
oxicottin is on a distinguished road
Send a message via AIM to oxicottin
Re: Yearly Attendance Tracker/Calendar

Quote:
Originally Posted by megatronixs View Post
Hi oxicottin,

I found your nice database and like it a lot, the only thing is that I still use access 2003 and would like to be able to make some changes to it. Is there a possibility to get the 2003 version unlocked so I can see how everything works? I want to learn and at the same time create something for my team based on your version.

Any possibility to get the unlocked version would be really great :-)

Thank you and greetings.
megatronixs, the DB isnt locked you just have to hold the shift key down while opening to open the backend.

Attached is a 2003_v4.2.mdb Enjoy!

__________________
If guns cause crimes, spoons make you fat....
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by oxicottin; 09-03-2019 at 10:35 AM.
oxicottin is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Attendance Register? Wingeronside General 1 01-25-2007 07:24 PM
Two foreign Keys in One table. Kelemit General 21 04-25-2006 09:45 PM
Using a list box in a form to record attendance Bigideaguy Forms 0 04-06-2006 11:08 AM
Attendance Form - Need to auto update names and dates Surfette Forms 2 03-28-2006 02:00 AM




All times are GMT -8. The time now is 09:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World