Search results

sorry i didnt explain myself very well :) i need the criteria to be the task number if that makes sense? on my form i have a task no, followed by other information including ActualCost, i need the actual cost to come off the query but only tat figure that is for the Task No? do u understand...

insttead of a number of a record on a query? could it be the task number? which isnt the primary field? so each time i run it, it gerts the approrate number for that task number?

help? could someone help me with this? i dont understand how to do this. would it help uploading the database?

so what your saying is the queryh would need to be run before openingg the report? or how would u automate that

Can this be done? i have a form in which i enter new jobs. these job no's have corresponding tasks, and each of these can be ticked completed, invoiced etc. one of the fields though is an actual cost. now for me to get the actual cost i have to run another report i have(Job Actuals) to get the...

thanks very much for that mate. it worked a treat! yea sunny WA is mint at the moment. today may be a bit hot though, 35. thats not to bad though TA

i want to get a thought of the day text box on my switchboard i have put them into a table labelled tblThoughtOfDay now each time i open the switchboard, i want it to randomly select one of the thoughts and display it? how do i do that?! ive tried and tried and cant figure it out ta

sorry sorry mate i am new to this thing i didnt realise it was an unspoken law. sorry again!

query try using a query instead of a table for your report. this should work. and it will allow you to add where conditions etc.

can someone help me with this code? Function DayOfyear(Optional dteDate As Date) As Long If CLng(dteDate) = 0 Then dteDate = Date End If DayOfyear = Abs(DateDiff("d", dteDate, DateSerial(Year(dteDate) - 1, 6, 30))) End Function Sub Test() MsgBox (DayOfyear *...

how do u increment by a timer? this is really got me this one. im stumped :(

thankyou for that but that is very complicated yea? is there any function (simple) that u know of to perform this task?

Can anyone help with this one? I need to accrue Annual leave for full time employees. It would be at the rate of 0.0547945 every day for 365 days to equal the 20 days of annual leave granted. i need something to work out for each day then add that number to a running sum next to each...

Can anyone help with this one? I need to accrue Annual leave for full time employees. It would be at the rate of 0.0547945 every day for 365 days to equal the 20 days of annual leave granted. i need something to work out for each day then add that number to a running sum next to each employee...

code? is there a length of code that can do it though?

If i enter a new customer in to a table, it shows in my combo box at the bottom of my list. how do i get the combo to update and sort it in order? Ta

? thanks for that but im sorry i dont understand to be frank. :) are these properties in the form? or does this require Code Behind Form?

Is there a length of code that can be used to create a button that opens the previous form. I have a hierachy from the switchboard which opens up An AddForm and a EditForm. However in each of these its the same form being opened up but in different modes, acEdit and acView. So i cant just say...

the command chr(13) to bring the control in my case the text box to the next line doesnt work. well it does but only puts in place a square. how do i get the box to the next line after a string of text?

Is there any way to get a table type lines on to a report for example, in the detail section on a report, i have each line repeating. i need each line to be in a row with a line, and each column a column line. It is proving to be very difficult. Could just be me though :) Any help appreciated.