Search:

Type: Posts; User: bel_ami_boy; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    12
    Views
    682

    Thank you. ...

    Thank you. http://windowssecrets.com/forums/images/smilies/rolleyes.gif
  2. Replies
    12
    Views
    682

    My colleague has just clarified that some of the...

    My colleague has just clarified that some of the data on the spreadsheet is extracted from his stock system. Crucially the date fields I'm having problems with are actually coming from his system....
  3. Replies
    12
    Views
    682

    Very odd! Is there any way I can extract the date...

    Very odd! Is there any way I can extract the date element out of the formula?
  4. Replies
    12
    Views
    682

    Good question. No I didn't create them. I...

    Good question. No I didn't create them. I received the spreadsheet exactly as you can see it. For the purposes of this forum I've just removed the rest of the columns we have no interest in. It is...
  5. Replies
    12
    Views
    682

    Sorry, you misunderstand. My colleague IS...

    Sorry, you misunderstand. My colleague IS directly typing the date in his end directly as the date.
  6. Replies
    12
    Views
    682

    A colleague of mine in the USA has sent me an...

    A colleague of mine in the USA has sent me an Excel spreadsheet with some dates. He has entered the dates into Excel in the format mm/dd/yyyy. I am based in the UK with my PC regional settings set to...
  7. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Thank you. In addition to the formula Hans provided above that worked off a working day value, I also need a formula (in B17) to work off a calendar day value (B15) as per the attached spreadsheet. ...
  8. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Ok. Understood.
  9. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Hans,

    This works perfectly. Unfortunately I need the Analysis ToolPak running to use the formula =WORKDAY(B3,B4,Z16:Z42)-B3 in cell B5 (Calendar Days Lead Time) on another worksheet. Unless you...
  10. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    No change. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
  11. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Hans, I'm getting '#NAME?' in cell B6.
  12. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    The latest formula you've suggested does do what I expect SOME of the time. Attached is the spreadsheet which will make it easier to explain. The idea is for a user to enter an order date and a...
  13. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Thank you Hans and Steve. I would never have figured that out! I'm still carrying out some testing but first impressions look very promising. I will post back to confirm one way or the other. Thanks...
  14. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Following on from the formula you suggested above, how could this be amended to take into account the following:

    1. If cell B6="Saturday" (as text) and the date in B7 is a Saturday then don't add...
  15. Replies
    22
    Views
    1,145

    Re: Help needed with an IF statement (2002)

    Many thanks. Boy would I struggle without the fantastic support from Woody's Lounge!
  16. Replies
    22
    Views
    1,145

    Help needed with an IF statement (2002)

    Cell B7 is a date. In cell B8 I am trying to write an IF statement that will perform different calculations depending on the day of the week the date in B7 falls on. If the date in B7 is a Saturday,...
  17. Re: Calculating calendar days from working days (Excel 2002)

    Thanks Steve. That works a treat. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
  18. Calculating calendar days from working days (Excel 2002)

    I need a formula that will calculate a calendar day value from a working day value based on a given start date. For example I need to place an order for a part where the supplier has quoted me 4...
  19. Viewing Table names when you hover over Query name (2002)

    Until recently (when the 'Queries' tab is selected), I've been able to hover over a Query name and the associated Table name has displayed. This has now stopped. Do you know how I can turn this...
  20. Replies
    1
    Views
    323

    Field sizes in tables (2002)

    How can I get a table of data (that I have made from a make table query), to have the columns auto fit to the size of the column heading or longest data in that column? Thanks.
  21. Replies
    19
    Views
    1,056

    Re: Adding a date/time stamp to a form (2002)

    It works!! Thank you Hans and Rudi for your patience and support. It is VERY much appreciated. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
  22. Replies
    19
    Views
    1,056

    Re: Adding a date/time stamp to a form (2002)

    I've stripped out almost everything from the database. When you open the Form and press the first button '1. Calculate Price Each' it should update the date/time stamp to the side of it, but it...
  23. Replies
    19
    Views
    1,056

    Re: Adding a date/time stamp to a form (2002)

    I replaced Me with CodeContextObject.Recalc

    When the button is pressed the macro now correctly runs each of my queries but at the end of this I get "Syntax error in update statement".

    Here is...
  24. Replies
    19
    Views
    1,056

    Re: Adding a date/time stamp to a form (2002)

    Now I get "Compile Error Invalid use of Me keyword".
  25. Replies
    19
    Views
    1,056

    Re: Adding a date/time stamp to a form (2002)

    Edited by HansV to replace Word doc with cropped version of the Word document it contained.

    Oops! Ok....I'm a bit further forward now but am getting a compile error in the VB code for the button....
Results 1 to 25 of 37
Page 1 of 2 1 2