Recent content by tangledball

HiTech Coach your a genius, this is exactly what i need. I was getting so confused with all the different variations and logic behind each one. Also big thanks for dumming this down to 2000 as well, i will be implementing this on Access 2003, but I only have 2007 at home and they won't allow us...

Hi Raskew, Thanks for the reply. I have copied and pasted the Public Function into a standard module as instructed, I assume that this function creates the tables for you automatically, however how do i actually call this up? I have tried call through a query, but when i go into the...

Can no-one help me with this... it's starting to drive me insane :mad:

Hi I have found the following Function on one of the samples posted on here, but this runs via a click event. Unfortunately i need to run something like this through a query, but i'm not entirely sure how I call this to show me the results i need. I have 2 tables one AnnualLeave and one...

:eek: What on earth is all that! I have copied the sample code to my module and renamed my tables to fit in with what is asked in the code, but how would I call this through a query? All that code looks very scary

Is there a way for me to omit public holidays using the CalcWorkDays Funtion? I have the following code that works great for removing the weekends from my calculation, but is there a way for me to remove the public holidays from the equation? I am currently using the following code: Function...

Hi RuralGuy, Thanks that's great, sorry it's been hard work. Cheers Mike :)

Hi Sorry, I just threw this sample together to give you an overview of the layout. The actual db does contain IDRecord which is an autonumber, which is also the PK. Each table i have also contains IDRecord with PK assigned. The Start and End Date on the Registration table relate to the...

Hi I have attached a sample of the database, just to show what the layout is like. Hopefully this will give you an idea of what i am trying to do. Thanks

I will try and explain how the database works. There are two Main Forms. Registration and Absence Management Registration contains employment details which also contains Annual Leave Start and End Date. Absence Management contains a number of subforms that relate to different types of...

Hi... Not sure what you mean by is the Registration Form still Open? Registration is the name of one of the Forms, which is where the two dates I will need to use are stored. The Command Button is on the Absence Management Form, which at the moment will open up the report for the current...

Hi thanks for your response. But I am still confused as to where these txt Begin and End go? what is there purpose and where exactly are they supposed to placed. Seems strange to have two txt boxes that don't appear they would ever be populated, which is probably why i am getting confused...

Hi where would i put the txtBeginDate and txtEndDate? I am assuming that I will use my orginal fields on the Registration form which would be Start Date and End Date, which has been referred to as [urtabledatefieldname] it think.. but where do the other two txt boxes go and is there anything i...

I would be gratful if anyone could advise how i can open a report but only show entries between two dates using a command button? I have the following expression which enables me to use a command button to open a report based on the current open record: DoCmd.OpenReport stDocName...