Recent content by thedeadzeds

Thanks Annie, not really unfortunately. The current query qry_calender1 worked fine the main issue was a error message every now and again and the fact that the name was not displayed in the rpt_calender1 report. So i bascially want the query to do the following: Display the CalDate and based...

Thanks Colin, I missed your reply so thank you so much for that. You have been a great help with this. I've attached a sample. The query is qry_calender1. You will also notice that when you run the report rpt_calender1 is does not pull through the name. Thanks again

Guys, I have this query which works fine when sometimes but other times i get an error message? Also, when i run it via a report it does not pull through the name but it does on the query. Any ideas? SELECT tblCalDates.CalDate, qry__approved_requests.Name, qry__approved_requests.datDatefrom...

Thank you Colin, I am getting an error message as per below. So sorry i know this is something i'm doing rather than your instructions. Database attached

Colin, is there a way to bring this result into the a form?

Amazing thank you so much

Thanks arnelgp, i'm getting an error message in my form. I've attached the database. Any chance you could have a look? Sorry about this

Thank you both, I should have also said that i want the Dlookup result to show based on the whatever name is selected in the drop down in the form called "Name" Is this possible or do i need to provide more info? Sorry, I'm still relatively new to access

Guys, Is there a way to link results from a query into a form? I have a query named "Remaining" and field within that query named "Days Remaining" which is an expression. I would like to see this in a form is possible? Hope this makes sense?

You you Colin and everyone else who helped with this. Very much appreciated

Thank you Colin, I have followed the above and the query results is throwing out some strange results (I suspect this is something i have done). Example database attached, would you mind having a look? Many thanks

Firstly thank you everyone for helping with this. After doing a bit of testing it seems some dates are being classed as a holiday correctly and some are not. Just to clarify and i'm not sure if this is the issue but datdatefrom is essentially the first day of the annual and datdateto is the...

Thanks jdaw but when i run the query it shows the following error. Is this something i have not done my end? 'Compile error; user defined type not defined

Thanks Ridders, Where did you find the code? Sorrily i cant remember what site it was on i think it was from utteracess Which day do you want your week to start? Weekdays should be Mon to Fri and weekend should be Saturday and Sunday so Monday I guess Are your results one day early or late...

I've tried that but unfortunately no joy but thanks for looking Ridders