• WSgsmith

    WSgsmith

    @wsgsmith

    Viewing 15 replies - 16 through 30 (of 339 total)
    Author
    Replies
    • in reply to: Deleting input masks #1232887

      Thank you for your comments.

      My grandson is taking a course in Access, and his locally purchased PC, (Guatemala) shows only about five default masks in table properties. John´s post allowed me to edit his Access to show a more complete list of masks, which lets him follow the exercises in his class.

      I realize that this is not a problem that you are normally acustomed to seeing but, never the less, it is important to my grandson.

      Thank you, John, for your information.

    • in reply to: Deleting input masks #1232821

      In 2003 I followed the following procedure:
      This is for Access 2002 and 2003:
      – Quit Access.
      – Make sure that hidden files and folders are displayed in Windows Explorer.
      – Start Windows Explorer, and navigate to C:Documents and Settings<username>Application DataMicrosoftAccess where <username> is your Windows username.
      – There should be a file named ACWZUSRT.MDT.
      – Make a copy of this file, to act as backup.
      – Double click ACWZUSRT.MDT; it will open in Access.
      – WARNING: don’t mess with the contents except for what is described below.
      – Activate the Tables section of the database window.
      – Open the table named im_TblInputMask.
      – Go to the last record. Custom input masks will be at the end.
      – Delete the record(s) you want to get rid of.
      – Close the table and ACWZUSRT.MDT.

      This came from Hans, if I recall.

    • in reply to: Deleting input masks #1232351

      I want to eliminate input masks that are presented as options in the design view of a table in the input mask wizard.

    • in reply to: Interest Payments (2K3) #1153964

      I am not following you very well. If you change the issuer date, the accured interest will definitely change as
      ACCRINT calculate from the issue date

      In your example, there’s aren’t significant differences, if you change your Issue date, say to March 1, 2000
      you will undertsand why isn’t the function ACCRINT producing the right result.

      HTH

      I agree, but in the example in Help, the change from variation 1 to variation 3 is to change issue date from March 1 to April 5, and add the TRUE expression. That changes the resultant value from $16.67 to $7.22. Changing the TRUE to FALSE, or leaving it blank, has no effect. Why does changing the issue date change the results by such a magnitude? March1 to April 5 doesn’t change the order of issue date, interest date, and settlement date.

    • in reply to: Interest Payments (2K3) #1153941

      In general, yes. Interest is accrued up to settlement date.

      However, in the event when you purchase a bond from the secondary market,
      the function give a flaw result, it actually returns the accrued
      interest not from the previous coupon date,but from the bond’s issue date

      For example, suppose that a $1,000 face value bond has a
      10% coupon with semiannual payments, which means that each payment is worth $50. If
      you purchase the bond halfway through the current coupon period, you owe the previous
      bondholder half the interest payment, or $25.

      To calculate the accrued interest, you divide the number of days since the previous coupon
      payment—the COUPDAYSBS() calculation—by the number of coupon days in the current
      period—the COUPDAYS() calculation—and multiply the result by the coupon payment:
      Payment * COUPDAYSBS() / COUPDAYS()

      HTH

      Maybe we should open a new series with this.
      I am confused with the info available. You mention correctly that the interest calculated should be from the lastest cupon date. When I look at the help file on ACCRINT, they give three variations on the use of the function. As you say, the first variation calculates accumulated interest from the issue date to settlement date; however, the alternative with Calc_Method equal to True calculates accrued interest from first_interest to settlement. Date of settlement must be later than date of first interest.

      When I look at the differences between the first and third variations of the example, the change is to the issue date, and the interest date and settlement dates remain the same, but the results change. In other words, the settlement date is not later than the date of first interest.

      Var Issue date First interest date Settlement date
      1 March 1, 2008 August 31, 2008 May 1, 2008
      2 March 5, 2008 August 31, 2008 May 1, 2008
      3 April 5, 2008 August 31, 2008 May 1, 2008

      If we change the issue date, then the first interest date should change. Are the dates in the parameters ignored? An issue date of April 5, 2008 would give a first interest date of Oct 5, 2008, which is after Settlement date.

      Help!

    • in reply to: Interest Payments (2K3) #1153900

      Sorry, i can’t help with that. I don’t have the slightest idea what these functions do.

      Thanks for the help, anyway. I am digging around in old text books, but not much help. I will try with a banker buddy this weekend. My problems are not with how the functions work, but what results they are producing. What do they do?

    • in reply to: Interest Payments (2K3) #1153897

      From the help file:

      ACCRINT calculates accrued interest for a security that pays periodic interest.
      ACCRINTM calculates accrued interest for a security that pays interest upon maturity.

      See ACCRINT and ACCRINTM

      Does the accrued interest for ACCRINT calculate interest accrued through the settlement date?

    • in reply to: Interest Payments (2K3) #1153882

      Yes?

      Did you want to ask a question?

      Yes. I think I got confused with the new format.
      What is the difference between ACCRINTM and ACCRINT, the financial functions for accrued interest?
      To send this, I click “Upload”, I presume.

    • in reply to: Interest Payments (2K3) #1153876

      How about the ACCRINT() function. It calculates accured interest? (You specifically ask for a function, not a formula)?
      I think it is part of the analysis toolpak…
      =ACCRINT(DATE(2008,1,26),DATE(2008,2,26),DATE(2009,1,26),0.055,1000,1)

      PS: It works out to 55.00, not much of an improvement. Maybe a loaf of bread! grin

    • in reply to: Open db from a form event (Win XP Office 2003) #1148548

      When I ran the code, the only thing that happened was that the original db closed. I re-did it with 2007 and it worked. I went back to 2003, erased everything, and re-did it, and it worked. Who knows? Anyway, it worked, and once again the Woody’s gang has saved a poor programmer. Thank you.

    • in reply to: Open db from a form event (Win XP Office 2003) #1148529

      I am still having troubles. Here is my sample file. Could you please take a look?

    • in reply to: Open db from a form event (Win XP Office 2003) #1148457

      I get an error message “You already have the database open”. I put the line of code in the on-click event of an empty form, just to test it. Any ideas?

    • in reply to: Delete object (Win XP Office 2003) #1145033

      How did you do that so quickly?

      Thank you. That works OK.

    • in reply to: Open with VBA a Password protected db (Win XP Office 2003) #1139329

      Great! We are OK. Thank you.

    • in reply to: Password protection (win XP Of 2003) #1137927

      If they need more, we will go to SQL.

      In the meantime, let me figure out the Environ function that you mention. I was thinking of using a hard coded constant for the cashier ID, but I would like to figure out the Environ, anyway.

    Viewing 15 replies - 16 through 30 (of 339 total)