Tip Bank

Question: I use SQL 6.5 in an industrial setting. I have an application that writes a new record into the database every time a pallet blocks a photoswitch. After 24

Question: How do I use the Group By statement in SQL Query? Answer: Group By is a way to collapse a result set around a textual value summarizing its contents

Question: How do I customize the mouse’s right-click menu? That is, instead of Cut, Copy, Paste, Select All, Delete in Edit-Masks, etc., I would like to display my custom menu,

Question: I need to have a result from a SELECT query with all the rows containing “word1” in column 1 and all the rows containing “word2” in column 2. If

Question: Could you please explain how to trap the e-mail ID from the In-box, so that I can filter my incoming junk mails? Answer: Filtering junk mail is tricky business

Question: I want to set up a hot backup between two SQL servers on two different NT machines. In other words, if one of these servers goes down I want

Question: Why do Journal entries within a (slightly) customized contacts database in Public folders only appear to the user who logged the Journal entry? All other fields in the contact

The DatePart() function can return the number of days from the beginning of the current year, but there is no VB built-in function that returns the number of days left

You need just one-line function to evaluate the number of days in a month (while taking leap years into account, of course). The trick is to use the DateDiff and