Search results

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

Hi Guys, is the below possible? If datDatefrom or datDateto in frmexample contains any of the dates in tblHoliday, then show a message box saying "you have selected a bank holiday" else do nothing

Hi Guys, So i have found a working sample but the calculation between the dates in qryExample seems to be one day out. Not sure if its to do with the below code. Database attached. Could someone help? Thanks

Guys, Does anyone have a sample 2016 database with a working days function in it? I have found the below link but i can't download as i have 2016 I need to be able to subtract dates from dates but exclude public holidays. I have found several examples online but can't quite figure it out. If i...

Guys, is there a way to do the following on the attached form? If "type" is equal to kickback, show closed, else show active

Hi Guys, Is there a way of auto populating a date based on another date whilst excluding weekends and bank holidays? So with regards to the attached database, can date due in frm_1 show 1 WORKING day ahead of the date input (eg date input is 14/10/15 so date due should show 15/10/15). This...