Tip Bank

Question: I read an article about how to search a database upon the criteria provided by users. In the example, you showed how to use a drop down menu (combo

Question: Given that NTCR is only good in a network environment, how can I redirect a user back to a login page (or trap something) if I pass their username

Question: Which is better to use for inserting or updating a record: Recordset object or Command object? Answer: When using an Action Query (a query that performs an action and

The following code (based on the UTL_SMTP package supplied in Oracle8i V8.1.6, release 2) enables you to receive e-mails from the database, reporting a correct ending backup, a corrupted backup,

Question: If I have the number of a given week of a year, how can I get the date of the first day of that week? For example, I want

Private Declare Function InternetGetCookie Lib “wininet.dll” Alias _ “InternetGetCookieA” (ByVal lpszUrlName As String, _ ByVal lpszCookieName As String, ByVal lpszCookieData As String, _ lpdwSize As Long) As Boolean’ Get locally-stored

Question: How do I define an external table (that is not in my current database) in Informix and access the data in it? Answer: If you’re connecting to an external

This is a simple string manipulation functionality that is often required.It converts the input string into a proper string (eg., “how are you doing?” will return “How Are You Doing?”).

You can use to activate Intellisense to prompt you forvariables/methods/properties/events at any point in a code window. For example:If you have a variable named myvariable, typing myv and then doing