Preventing BackSpace key in a TextBox from moving a cursor to the previous control
Deleting characters in a TextBox with Backspace key doesn't stop when cursor reaches the beginning position but unexpectedly moves cursor to the previous control. It could cause unintended deletion of the data there.
Check if table is part of DBC
It is easy to find out if a table belongs to the open Database Container (DBC) using INDBC() function. Sometimes it's necessary to check it w/o referring to DBC itself.
VFP Team releases third hotfix for VFP 9.0 SP2
A hotfix for a bug in VFP 9.0 SP2 FIX: The group header of a data grouping is not printed at the top of a page as expected after you install Visual FoxPro 9.0 Service Pack 2 has been released.
Birthday Query in VFP
It's a common request to get a list of people whose birthday (or an anniversary date) falls into specified date range w/o regard to the year.
Birthday Query in MS SQL Server
It's a common request to get a list of people whose birthday (or an anniversary date) falls in the specified date range w/o regard to the year.
End-user account info from Active Directory for Windows network login
Relevant links:
- NameTranslate FAQ
- IADsUser Interface is designed to represent and manage an end-user account on a network
- IADsLargeInteger Interface is used to manipulate 64-bit integers of the LargeInteger type
Ordinal Numbers
Ordinal numbers refer to a position in a series and usually are presented as a number and one of the suffixes -th, -st, -nd and -rd.
Document Properties in Microsoft Office Word and Excel
Document properties, both built-in and custom, are a Microsoft Office-wide feature. The Word 2003 and Microsoft Office Excel expose document properties and provide the same way to work with them. These properties provide a powerful way to add and track specific information for a document.
Who has files open on the network
The WhoHasFileOpen
utility displays the list of users who have specific file(s) open on network. Works on Windows NT Platform (Windows NT 4.0, Windows 2000, etc). This code detects only the files opened using a net shared path. It does not return the files opened by a user on the local computer using a local path.