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!

  • Congratulations wOOdy-Soft 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: *

  • Users: Fae
  • Content: Threads
  • Order by date
  1. Fae

    Excel Loan Amortization Schedule

    The Excel Loan Amortization Schedule REQUIRES that LOAN PERIOD IN YEARS, need to be whole numbers. How do i get around that if i do not want a whole number, instead i need 3½ years. Miracles we do immediately ... imposibilities take a little longer.
  2. Fae

    Excel Negative Number Format

    I would like to know if there is anyway that you can set the default settings for Excel (or in the Control Panel, Regional and Language Options) to display negative numbers for all new worksheets as (999,999,999.00) Miracles we do immediately ... imposibilities take a little longer.
  3. Fae

    Access Report

    Hi there, I am trying the following This is in an Access Report In the [Supp Results] field, i am trying to get the [supp result] only if the [Result] is Less than the [Pass Requirement]. how do i do it Miracles we do immediately ... imposibilities take a little longer.
  4. Fae

    Column / Row indicators

    My client has a problem in Microsoft Excel 2000 She says that where the column inidcators are A, B, C, D it is now 1, 2, 3, 4 etc. and the Row indicators are showing A, B, C, D instead of 1, 2, 3, 4 etc. How can we change this back ? Thanks Miracles we do immediately ... imposibilities...
  5. Fae

    ACCESS CHARTS - SR-1 v/s SP-3

    When Creating chart in ACCESS 2000 with SP-3 there is a stuff up with the chart design. You have to do it to understand what it does - it is either over- or undersized for the area - and you cannot resize it, and believe me, I have tried everything to get it right. Designing a chart with...
  6. Fae

    String value contains quote

    In Access 2000 using VBA I have a string value e.g. 500mg Litchi "A" duplex box (string value uses double quotes) or or 500mg Litchi 'A' duplex box (string value uses single quote) How do I insert that record (which can be either the one or the other - indicated above) into a...
  7. Fae

    Mark code as comment

    Hi there I would like to mark Selected code as comment. Forgot how to do it. Can you help Thanks Miracles we do immediately ... imposibilities take a little longer.
  8. Fae

    MS Outlook Tasks

    My client has a problem with Outlook 2000 (version) Tasks : They add to the Master Category list and then two weeks or so down the line - the categories dissappear from the list. Is this a bug - do they have to load a service pack ? This is how they do it - and according to me, it is...
  9. Fae

    Using ROUND and SUM in FUNCTION

    I have the following scenario 7776.72 * 14.5 I need to round the 7776.72 to 1 decimal eg. 7776.7 i need to use that answer to * it with 14.5 which must then give me an answer to 1 decimal point. Increasing and decreasing decimal points does not work as you know - as it still uses both decimals...
  10. Fae

    Calculation in Access Subform using form field and subform field

    I need the answer in a field in the subform on the Form : frmLastReport is a field : Text8 on the Subform : frmLastReportSubform is a field : Text15 i need to calculate : text8 x text15 i have tried different ways of writing it, to no avail =[Forms]![frmLastReport]![Text8]*[me]![Text15]...
  11. Fae

    Calculation in Access Subform using form field and subform field

    I need the answer in a field in the subform on the Form : frmLastReport is a field : Text8 on the Subform : frmLastReportSubform is a field : Text15 i need to calculate : text8 x text15 i have tried different ways of writing it, to no avail =[Forms]![frmLastReport]![Text8]*[me]![Text15]...
  12. Fae

    MS Excel insert current time incl. seconds on click

    Scenario - Swimming team times I need to be able to either click on an Excel cell and it must insert the current time (including seconds - as the seconds are what really count here)(maybe vb for excel) and then it must jump down to the next cell. So, either by clicking the cell or one just to...

Part and Inventory Search

Back
Top