When sub-query is used in the FROM clause, it can be viewed as selecting data from a virtual table because the result set of the sub-query is temporarily stored in memory and then used by the outer query as a table.The query below is the inner query we just saw which shows a list of distinct values in the Reports To column.Fixes an issue in which the MMC stops responding on a Windows Server 2008-based or Windows Server 2008 R2-based computer.Additionally, you receive a "0x0000009F" Stop error if you shut down or restart the computer.However, Access kept giving me the syntax error message shown below.
The solution to this problem is to write a sub-query in the FROM clause to retrieve all the qualified distinct records, then in the outer query in the SELECT statement, do a count for the number of records returned by the sub-query.
Fixes an issue in which AD DS database size increases significantly after you enable the Credential Roaming feature in a domain.
Additionally, you may experience issues such as LDAP query delays and replication delays.
You can read the full text of past Basically Visual columns. Here I present solutions to a few problems that I have encountered in my programming. Customizing the Web Browser control Avoid using the Internet Transfer control Validating web links Sending email from a Visual Basic program Clear all Text Boxes on a form Create blinking text on a form Display 3-D text on a form Change Text Box margins Aligning controls at a specific position Don't forget the Tag property Sizing a Form's interior Getting colors from a Picture Box control Auto Redraw and the Paint event Capturing screens from a Visual Basic program Filtering Text Box input Getting and using screen information Clipping the mouse cursor Move the mouse cursor in code Drawing "rubber-band" boxes Undo for Text Box controls Disable a form's Close button Modify the System menu Accept only uppercase letters in a Text Box Keeping a form on top Using custom mouse cursors Ensuring that all forms unload Remembering a form's size and position Support formatted text with the Rich Text Box control Toggling a form's title bar at run-time Understanding the Combo Box control Get to know the Sys Info control Changing Combo Box height Implement auto-find in a List Box Selecting all text when a Text Box gets the focus Save time with control arrays Adding controls to a form at runtime Scrolling controls on a form Understanding the Key Preview property Create a pane splitter Changing text alignment for Forms and Picture Boxes Create an "auto-OK" dialog box Create a "Sticky" Button Creating Graphical Command Buttons Implementing mouse-over effects Using the Picture Clip control Implement a Mouse Exit event Fire a Command Button repeatedly Create a temporary file name Verify that a path is writable Determining the type of a drive Using INI files for program settings Deleting files to the recycle bin Dragging files to your Visual Basic program Display file properties Display a select folder dialog Reverse character order in a string Parsing strings Is that on a weekend?
These were originally published in Visual Developer magazine. Perhaps you will find something that is useful to you. Encoding and decoding passwords Implementing a stack Counting strings Converting numbers between decimal and binary Use the Data Report Designer Making the most of UDTs Comparing dates in Visual Basic Using the Collection object Normalize spaces in a string Send raw data to the printer port Creating synthetic keystrokes Detecting the state of the "lock" keys Using the standard input/output streams in Visual Basic Playing WAV files Playing the Windows system sounds Keeping an application log file Detecting a sound card Reduce the size of Visual Basic distribution files Easy creation of database connection strings Do you Do Events?