Search results

No 8 yes - exercise, and it should be tough going! If exercise is combined with some weights it can really make a big difference. Exercise should also be varied. If you continuously do the same thing, like running, then your body gets used to it and you can end up putting on weight again.

A 'Closed' sign on a pub door window, facing inwards, in Wales. Some older Welsh people were getting very confused when they were on their way out, some even went to find other exits! It was one of those really funny moments, but I resisted the urge to say it opens at 11pm.

I believe you need to use MAX and LOOKUP. If for example you had the date in column A, and the cost in column B (assuming row 1 contains titles and you have a maximum of 100 rows), then give this a try: =LOOKUP(MAX(A2:A100),A2:B100)

You need to create a query that displayes feesdue and feesoutstanding in the first and second column. In the field part of the third column, type in: Total:[fessdue]+[feesoutstanding]

If you just want a list to appear as A1, A2, A3 etc regardless of what you select in sheet 1, can you use a pivot table? This would give you a list and can be set to filter on the cells you select. Just a sidenote, but it sounds like your checkboxes might also be a bit painful, as you have to...

From what you describe, I believe it would be easier to use the other type of checkbox from the "Forms" toolbar. This would eliminate the need for code - you could use a simple formula instead: The "Forms" checkbox links to a cell, lets say it links to cell H7. When you check the checkbox...

What sort of checkbox is it? Is it one created from the Forms toolbar, that is linked to a cell? OR is it from the Control toolbar that drives code?

Phew!!....I'd recommend people open that image from home!! :eek:

Yes, because you need to subtract the total string length from the position where you find 'culprits:'. Here is some code I put together that you can use as a starting point: I shortened your text string in this example because it wouldn't fit in this window properly. Sub Macro1() Dim text...

Look up InStr and Right. There are lots of examples on Google of doing this if you search 'VBA string manipulation'.

I'm sure the answer is no. But a workaround that might work is to insert a formula into a new column in Worksheet1 as follows: =COUNTIF(A1,Vendor!A:A) This assumes John Doe is entered in A1 in worksheet1, and is matching it aganist any John Doe's that might exist on a separate worksheet...

Thanks Bob for all your past support, both direct and indirect. Good luck for the future.

How about using a pivot table? You could create a pivot table, and insert your column B header as the column field and the totals as the data item. This will give you the totals for both Y and N. ------------------------------------------------------------ Otherwise, if could paste this...

The company is closed because it is too cold, so I doubt that the company would expect you to take your kids to school too. So yes, take a paid day off if you're entitled to it.

My company has been very flexible, we have the option of either taking holiday, working from home (if possible), or making the hours up later. I think that if an organisation decides to close, then employees should rightly get the day off for free (as it's out of the employees control). But...

When Insults Had Class! There was a time when words were used beautifully. These glorious insults are from an era when cleverness with words was still valued, before a great portion of the English language was boiled down to four-letter words! The exchange between Churchill and Lady Astor...

I hope the event is as spectacular and breathtaking as the film 2012, might get some good photo opportunities!

Also, just to note, the solution I explained is also mentioned here: http://www.access-programmers.co.uk/learning2/TipsQueries.htm There are many useful tips you might want to have a look at.

Open your query in design view, select the 'running sum' column, then go to View, Properties, then for Format select 'Fixed', and for Decimal Places select 1. Hope that works for you.

Ahh!!.....a subform is a control!! I just tried the following code: Me![secondform].Requery and bingo! Thank you both for your help.