Recent content by RichieP

Right then . . . . I have a spreadsheet with a list of projects (in 'active' and 'on-going'), each project has a main title and many minor titles (sub sections). Each project will have a different number of minor titles. The user can then enter how many days they have worked on each minor part...

The people I'm doing it for want it in word :(

Hello all you good good people! What I need is a macro button actually on the page so the user can click it and it copies and pastes something that's already on the page. See attached example. What I need that button to do is copy the entire table and past it underneath the one that's already...

Cheers guys. Hey Len - West Midlands - I support West Brom! Anyway, thanks.

Hello I'm guessing that this question has been asked alot. How do you get rid of the options at the top of the screen so the user cant change any of the underlying database management design? I've created a blank menu macro with nothing in it and put it in the properties of each form but this...

Hi, Can someone help me please? I need the text in the attachment too scroll across the text box. I've searched the forum's and found some info/code on how to do it but I've not really understood it. Thanks - help is appreciated! Rich

:) Thanks, did the trick.

I've search the forum with no luck. I know you can search for part words by using one of these types of code: Left(stringexpr,n) Right(stringexpr,n) Mid(stringexpr,start,n) How do I do the same with numbers? I want to extract every thing past a decimal point. For example, I have 5.912 in a...

Ok, sorry that was just me being stupid. The estimate is still wrong on some dates tho . . . . For example . . . . . . Put in 06/08/1981 (6th August 1981) in the start date and 06/08/2003 (6th August 2003) in the end date. This gives the correct answer of 22 years and 0 months. However...

Day / month / year Sorry, this was just an example I knocked up really quickly. Look at the attached picture. Start date is 6th August 1981 and the end date is 7th July 2003. That is 21 years and 11 months (I think). Your estimate (bottom in black) makes it 22 years and 11 months.

That is so close! It works apart from the fact that when the months don't = 12 then the year still adds on 1 (e.g. instead of "12 years and 9 months" it shows "13 years and 9 months"). Is there anyway of getting the year to add 1 ONLY if the months = 12? (and obviously if the months = 12 then...

another problem Ha ha new problem! I've changed it slightly. When the estimation of something is a whole year (eg. say 2 years or 3 years) then the estimation comes out as "1 year and 12 months" and "2 years and 12 months" and so on. I need this to change to "02 years and 00 months" and "3...

Cheers, did the trick. Rich

I see what you've done - I tried that - but it doesn't store the value in the table which is what I need. When the control source is changed it stops it being related to the table. :( Can anyone help? Cheers

I've attached an example access 97' database. I need the unbound "Estimate of duration" box on the right to automatically update the "Duration" box on the left. Any ideas cause I'm all out of em. I have a feeling that I don't need an unbound text box at all and I just need a bit of code in...