Search results for query: *

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

Hi all can you guide me in the right direction, i would like to put password on my command buttons can someone offer me some guidence. p.s i would to have 4 seperate passwords but they all need to open the same buttons. i have a table called userinfo where the user names are stored also a user...

Hi Guys another way to achive the same out come is with a RunApp Macro. in the command line just type the name and path of the .exe you wish to use then a space then the name and path of your file. e.g. excel.exe c:\database\MoneyPlan.xls this dose the same as the oweb suggestion but much...

Hi all Im just saving the spreadsheet by going to file - save and this is saving the changes to the folder that i have the database in. hope this helps. regards, Jesse

Thanks every one.

Hi Guys Ok i have taken an intrest in this idea, where do i insert the activeX in to? I have the excel file in the same folder as the database this is folder is called database it is on my c:\ the file is caled MoneyPlan.xls would this be correct? oWeb.Navigate "c:\database\MoneyPlan.xls"...