Search results

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

Hi McSwifty! That would be fantastic! Been struggling for a while, at least I've tried to have a go I suppose. Really Appreciate it!:D Rach

Hi Everyone, I have been reading through your posts and I dont suppose anyone knows how to convert the Employee Vacation tracker to be able to insert hours? into a date rather than it count as 1 day? Really struggling to find a way to do it!! Anyone have a database which is simular (shift...

Hi, I've managed to get the report to show the two results from the form, which is just brilliant exactly what i needed. I have put the code in that requests to show only the record selected from Main and From Compare but i can seem to get the Compare to stop showing all records the code...

Right, Got the first search to work brilliantly, but bit at a loss how I can get the second (Comparison) one working on the same report as they run from the same tables? (but different queries) do you think i should have set it up differently from the queries? I've attached an updated...

Brilliant!! Thanks I've got one of the query searches working on the report...fingers crossed for the second!!