Recent content by Rach!

Hello All! This is probably a really silly question but.... I cant seem to get my head around something. If you have a database that contains a table of costs for say materials, which are updated say yearly but you want to keep all records inputed at the previous cost without updating them...

Will give it go! :-)

So how would i link the claim i am creating to look at the 2012 or 2013 product list trying to automate as much as possible? one claim can have several materials to it?

Hello Everyone. Can anyone tell me what to do when it comes to queries. I have a table of products and these products prices can change at anytime. Basically i want the prices to stay the same for claims already raised but anything created after that point is set as the new price. To say it...

Thanks Kev, How do i contact oxicottin?

Hi Kev, Your right feb has come out as January any idea why this is? do i need to change the date format in the code then? Rach Also Have you had to set the vacation up to account for employees who are calculated over a pro rata vacation?

:DKev, Just brilliat! Works an absolute treat! Thank you so much for you help.

Thanks Kev, Will take a look. :-)

Thanks Kev! Really appreciate your help. The code (date format) worked fine before as it was. Must be something to do with adding the time taken, or what ever it was you added in new to the calendar i suppose. Rach

Another question Kev, Hidden is a text box showing VacDays with control source =[cboUser].[Column](1) this brings up the employee vacation days (on the calendar). I can see that if i make this [cboUser].[Column](2) it brings up the persons name. Where abouts is this looking so that i can...

Kev, That was going to be my next question about the hours, im having a go at trying to change it. But if you could help that would be great. The error happens when ive clicked the Employee dropdown. It comes up with Run-time error '13' Type mismatch. Then it highlights the code i put...

Hi Kev, it errors at see red. Public Sub SetCalendar() Dim rst As Recordset, StrgSQL As String Dim OnDay As Integer, CurDay As Integer, Bclr As Long, Fclr As Long Dim iRed As Integer, iGreen As Integer, iBlue As Integer Dim i As Integer, AbsentReason As String Dim YelYear As Integer...

Can anyone help?

Hi I've had a look and i get the following problem when selecting a date box Set rst = CurrentDb.OpenRecordset(StrgSQL, dbOpenDynaset) Says Type Mismatch? --------------------------- Also How do i get the Vacation Days Left & Vacation Days Taken to state hours taken and not the...

Thanks McSwifty, Will take a look and get back to you :D Rach