Search results

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...

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.

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.

I think its due tot eh change from txtV to txtLA - txtV was used to calculate the hours taken the name of the field after hours taken is currently txtV - change to txtLA and change the hours left field to =([txtTotalVacDays])-([txtLA])

This is how I solved it. http://i.imgur.com/LIII0iD.png - has all the relevant details in the table and the way I did the query to get it to work in conjunction with the onclick and ongotfocus - both of which i have linked to requery the combo box control. it may not be the most efficient way...

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...

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.

Hi Janeyg, I recommend using a 'flag' like a checkbox field in your user table and making sure that is changed to TRUE when the user logs in successfully, on the concurrent attempt you need to check for this being false else fail the login attempt with a message stating the user is already...

Try to pm. I think my response advice was aimed at a message I had in my email but not showing in here. The date fix is Eau but after a long weekend and a few days missed at work I didn't get a chance to look. Will try to do that today.

Hopefully oxicottin can help with that. It would take a bit of a rewrite to make that work I think Edit: is anyone else having email notifications that someone has posted and then found there is no new post in the topic? I got this from Don33ald - I am starting with 12 calendar controls on...

pro rata? Do you mean leave taken before the next roll over of a year allocation? I did not account for that. The balance will go negative. The date issue is due to access wanting to use US date format of mm/ dd/yyyy UK is dd/mm/yyyy so you need to reformat the date input to the pop up date...

glad I could help. Just realised you are in the UK, no issues with the date selection when clicking on a day in the calendar? I used to get issues with Feb as the 1st Feb would come out at 2nd Jan. 2 Feb = 2 feb 3 feb = 2 Mar 4 feb = 2 Apr etc. Hope you got this sorted.

I think this sorts the issues - I hope. I have Vacation as hours - I have also added the hours into the reports and underlying queries. See attached file. I have added a line of code to debug the issue you were having with StrgSQL. If it errors out again with the mismatch error please post...

@ poppa smurf - this code it Oxicottin's the only thing I changed was having hours on the calender instead of days. I just forgot to adjust the vacation to match. I have had no problems, but you are right with the date formatting. I have to change all dates to US as I use UK formatting and it...

I honestly have no idea why it's failing. Never had an issue with that part of the code. I don't have access at home any more so will have to wait until I can check when back at work about 14 hours. Also was looking into the vacation time as I realized I hadn't changed to hours before...

is this error in the example I have given or somewhere else?

please post the StrgSQL line. how is it made up, it should be either a query name or SQL there must be something wrong with it.

I would think this means you have compact on close turned on so its doing this on each close. The reason for the message stating it needs to close might be on the total size of the db - which you haven't specified. I know they have limits which is a good reason to split front end/back end so...

Hi BigMac, I recall these topics (only due to me posting in them) My Example Another topic I am not sure if they answer your query, but if not let me know and I will explain the concept I used. i am sure it came from one of the example databases on these very forums anyway.

Hi Rach, Sorry for any delays, I found I have embedded my calendar so far into other parts of my database I have to start from scratch with the example posted above. (I tried but it would have taken days) Links removed - old data I have NOT updated the reports, but they all need the query...