-
WSgsmith
AskWoody LoungerThank 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.
-
WSgsmith
AskWoody LoungerIn 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.
-
WSgsmith
AskWoody LoungerI want to eliminate input masks that are presented as options in the design view of a table in the input mask wizard.
-
WSgsmith
AskWoody LoungerI am not following you very well. If you change the issuer date, the accured interest will definitely change as
ACCRINT calculate from the issue dateIn 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.
-
WSgsmith
AskWoody LoungerIn 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 dateFor 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, 2008If 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!
-
WSgsmith
AskWoody LoungerSorry, 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?
-
WSgsmith
AskWoody LoungerFrom 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.Does the accrued interest for ACCRINT calculate interest accrued through the settlement date?
-
WSgsmith
AskWoody LoungerYes?
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. -
WSgsmith
AskWoody LoungerHow 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!
-
WSgsmith
AskWoody LoungerWhen 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.
-
WSgsmith
AskWoody LoungerI am still having troubles. Here is my sample file. Could you please take a look?
-
WSgsmith
AskWoody LoungerI 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?
-
WSgsmith
AskWoody LoungerHow did you do that so quickly?
Thank you. That works OK.
-
WSgsmith
AskWoody LoungerDecember 26, 2008 at 1:19 am in reply to: Open with VBA a Password protected db (Win XP Office 2003) #1139329Great! We are OK. Thank you.
-
WSgsmith
AskWoody LoungerIf 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.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
No HP software folders
by
fpefpe
1 hour, 16 minutes ago -
Which antivirus apps and VPNs are the most secure in 2025?
by
B. Livingston
1 hour, 37 minutes ago -
Stay connected anywhere
by
Peter Deegan
1 hour, 30 minutes ago -
Copilot, under the table
by
Will Fastie
3 hours, 15 minutes ago -
The Windows experience
by
Will Fastie
7 hours, 45 minutes ago -
A tale of two operating systems
by
Susan Bradley
55 minutes ago -
Microsoft : Resolving Blue Screen errors in Windows
by
Alex5723
13 hours, 4 minutes ago -
Where’s the cache today?
by
Up2you2
1 day, 4 hours ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
21 hours, 10 minutes ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
1 hour, 36 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
1 day, 5 hours ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
1 day, 21 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
1 day, 21 hours ago -
regarding april update and may update
by
heybengbeng
1 day, 23 hours ago -
MS Passkey
by
pmruzicka
1 day, 1 hour ago -
Can’t make Opera my default browser
by
bmeacham
2 days, 6 hours ago -
*Some settings are managed by your organization
by
rlowe44
1 day, 17 hours ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
2 days, 5 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
3 days, 1 hour ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
3 days, 10 hours ago -
AI slop
by
Susan Bradley
1 day, 4 hours ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
3 days, 11 hours ago -
Two blank icons
by
CR2
19 hours, 59 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
21 hours, 57 minutes ago -
End of 10
by
Alex5723
3 days, 23 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
2 days, 21 hours ago -
test post
by
gtd12345
4 days, 5 hours ago -
Privacy and the Real ID
by
Susan Bradley
3 days, 19 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
1 day, 21 hours ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
4 days, 9 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.