Recent content by JesseNorris

Thanks PHV this proves that there is more than one way to fry an egg Regards, Jesse

Its all good guys i think ive worked it out how odse <(DatePart("yyyy",[nameoffield])-7) sound?

Hi all im looking to have a query that will return only the records that are older than 7 years old based on a date_last_closed feild. any ideas will be a grate help Regards, Jesse

thanks ken

hi ken taht works good for working out the amount of time for over time do you have any ideas for the other values? regards, Jesse

thanks ken i will give it a go regards, Jesse

hi all i have made a timesheet for my work place but i have hit a brick wall. we have an 8 hour day but only get paid for 7 the "lunch hour" can be taken any time we like. that was the easy bit. now if we have a lunch brake that is less than 1 hour we can claim toil for the time between when...

thanks tf1 regards, Jesse

hi all dose anyone have an idea on how to update more than on machine at a time maybe from the server or is there an automated way of doing this. any Suggestions would appriciated. Thanks Jesse

thankyou jesse

thanks Omega36 you have been most helpful can you tell me how to put a password on a command button so that at the onclick event they will be prompted for a password. once again thanks for your help so far. Jesse

Hi Omega36, i have tyred it but cant see the changes on the spreedsheet here is the code that i entered Private Sub totincome_AfterUpdate() Dim xl As Excel.Application Set xl = New Excel.Application xl.Application.Workbooks.Open "C:\database\MoneyPlan.xls" xl.Range("b5") = totincome...

Thanks heaps i will give it a try now Cheers Jesse

hi all, i have a text box called totincome which i would like the value of to be exported into my excel file moneyplan.xls to help to automate this spreed sheet. the reason i would like to do this is my client tells me that people in her line of work(financial counselling) never usualy get the...

Thanks ken as i am a relitive new come to database devolpment can you help me out with some code for this methord, it sounds like a much better way to do things. Thanks Regards, Jesse