Search results for query: *

Hi all, I have a problem with page numbering and printing. Long story short... My Worksheet references others and often a page has no data to print. When this happens I group the rows of the affected page and hide them. I don't delete the rows as I may need it in a subsequent version of the...

I was just browsing "stuff" and foud out that the movie "Three Days of the Condor" is based on the book "Six days of the Condor". It seems that it was too long to make a movie spanning six days of action and suspense. Can you think of any other movies which would benefit from similar...

I have an interesting one for you. I produce a daily report in the form of a pivot table part of which has Conditionally Formatted Colour Scales set across ten columns. The code for the Conditional Formatting is: Range("D9:M" & lngLastRowPivot).Select...

I throw this out to the MAI collective for enlightenment. A spokesperson for the RICS (Royal Institute of Chartered Surveyors) Scotland is quoted on the BBC News Website as saying: Now I was always under the impression that an acre was a measurement of area and cannot, therefore, be squared...

I have a routine running in a macro which uses Autofill to copy a formula from - say - Cell A2 in a sheet to all the cells below it in column A. Yesterday the Autofill worked but all of the values were the same as the value in A2 although the copied formula correctly referred to each row...

Hi. I am running a routine each day which saves a file in a folder with the format : //sharepoint.xxxx.com/sites/Shared%20Documents/Reporting/Transaction%20and%20Utilisation%20Reports/yyyy-mm-dd_Filename.xlsx where the yyyy-mm-dd is today's date. I need to check first that the file does not...

Hi all. I have a macro in Excel 2007 which is referencing a filename in a vlookup. The relevant part of the macro, when I set it up yesterday, was "=VLOOKUP(RC[-1],'2013-02-27_Utilisation.csv'!C15:C16,2,FALSE)" which was fine. Today, of course, it should refer to the same filename with...

Hi all. I have generated a macro which performs a couple of functions in my data and then inserts a Pivot Table into the current worksheet. The data I am using are generated from an external system on a daily basis and the number of records varies. Here is my question - I know there is an...

I don't know why people who should know better keep doing this. In this article: http://www.bbc.co.uk/news/uk-scotland-20176376 the researcher from the Mackintosh School of Architecture (only in Glasgow) says about people drying their laundry in their houses: NO THEY WEREN'T! The fact that this...

How were hailstones measured before the invention of golf balls? It is time for pacifists to stand up and fight for their beliefs.

I was just looking at an article headline in Flipboard and tapped the screen to open the article. Due to a congenitally fat index finger - diets and exercise help not one iota - I accidentally tapped on the Star to the right of the headline. I was presented with a pop-up which said: Is...

I heard the speech made by Dick Van Dyke when he was presenting a lifetime achievement or some similar award to Mary Tyler Moore at the SAG awards a few weeks ago and wondered if it was the best opening line of a speech I had ever heard. He said "Hi. I'm what's left of Dick Van Dyke..." Do...

Hi all. I have just been given a Sharepoint project to manage and develop never having had any experience of or exposure to Sharepoint. I don't know what version it is - or where to find that information. Can you give me any pointers as to where I can get some (free) online tutorials to get...

I wonder how many song titles or lyrics remind people of food. Even if they need to be amended very slightly... I have things in mind like "There's a guy works down the chip shop swears he's Elvis" or "There's a plaice for us" or "Bette Davies Pies" or the more obscure "As time goes by" as...

Hi all. I have a column chart I need to create. The data are: Balloon Total NBV End Date 5,093.63 5,785.33 Apr-2011 5,425.72 6,176.40 Apr-2011 6,183.68 6,985.84 Apr-2011 6,731.25 7,534.22 Apr-2011 12,497.74 14,477.35 Apr-2011 7,658.40 8,498.51 Apr-2011 5,902.31 6,692.60 Apr-2011 7,898.72...

I'm getting awfully frustrated with this and would appreciate any help. I have a table which includes, among other things "CustNextAudDue" which is a date field. I need to query this in various ways: 1. Query on all records where "CustNextAudDue" is next month 2. Query on all records where...

Dear all, I have a database which I want to share on a Citrix Metaframe network. I have set up user level security and then split the database into front- and back-end. the back-end will, of course, be in a shared folder on the server, and I will distribute the front-end to each user to...

Hi guys. I have a silly problem which is baffling me. I have two forms - one single form view, one continuous forms view. The single form has a tab control. I have a hyperlink text box control on the continuous form and an identical one on the tab control of the single form. The hyperlink...

Dear all, I have a requirement for a query to give me a list of audits required "next" month. My query is based on a table which includes, among others, the following fields: CustLastAudit - format is Short Date - Date the customer was last audited. CustAudFreq - format is Long Integer -...

Hi guys. Simple situation, I am sure simple solution too. I have a table with a number of fields in it. One of the fields is "CustLastAudit" and is a date field, another is "CustAudFreq" and is a Long Integer referring to a number of months. A further field, "CustNextAudDueDate" which should...