Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hjgoldstein

    Excel 2007 - Grouped Rows and Hidden Pages. How to exclude from Page Numbering and Printing?

    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...
  2. hjgoldstein

    Half a Movie is better than None

    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...
  3. hjgoldstein

    Conditional Formatting in Excel 2007

    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...
  4. hjgoldstein

    When is a Square not a Square?

    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...
  5. hjgoldstein

    Autofill filled and failed

    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...
  6. hjgoldstein

    Find if a file exists

    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...
  7. hjgoldstein

    Vlookup in Macro with variable date filename

    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...
  8. hjgoldstein

    Dynamic Row Reference in a Macro

    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...
  9. hjgoldstein

    Literally Wrong

    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...
  10. hjgoldstein

    Deeply Philosophical Questions

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

    Is There a Noun That Can't be "Verbed?"

    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...
  12. hjgoldstein

    Unaccustomed as I am...

    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...
  13. hjgoldstein

    Help needed for a Newbie

    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...
  14. hjgoldstein

    Food Songs

    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...
  15. hjgoldstein

    Excel Chart - Supress Zero Values

    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...
  16. hjgoldstein

    DateSerial syntax looking for next month...

    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...
  17. hjgoldstein

    Shared database on Citrix Metaframe

    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...
  18. hjgoldstein

    Hyperlink on forms

    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...
  19. hjgoldstein

    Query returning values only if 1st of month

    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 -...
  20. hjgoldstein

    Error when field is empty

    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...

Part and Inventory Search

Back
Top