Private Declare Function GetKeyState Lib “user32” (ByVal nVirtKey As Long) As _ Long’ Get the current state of the CapsLock keyFunction GetCapsLockKey() As Boolean GetCapsLockKey = GetKeyState(vbKeyCapital)End Function Related Posts

We almost always need to develop forms in which the contents to the control have to be selected whenever the user tabs to a textbox or a combobox. For this

Microsoft Visual SourceSafe (VSS) doesn’t store its data in a format you readily can use, and MSwouldn’t put the “Analyze and Fix” option on your menu if it wasn’t needed.To

SQL Sever 7.0 allows developers to execute commands against OLE DB data sources on different servers. In order to execute commands on remote servers, the SQL Server instance where the

There is an undocumented stored procedure that you can use to run a single command on all tables in a database. It is very useful when doing routine jobs on

In a previous tip, I showed how to swap two variables without using a temporary variable. There’s another version of this solution that applies to integral values only. Here it

C and C++ differ in their handling of enum types. While C allows you to assign a plain int to an enum variable, C++ doesn’t. Therefore, a C compiler will

The standard stream object cerr and its matching wide-character version, wcerr, are unbuffered. This means that they are automatically flushed after each operation; they do not buffer data. This feature

The Standard Library provides the pow() functions (declared in ) which takes two arguments of type double, x and y: double powl(double x, double y);pow() returns the value calculated of

Internationalized software must enable easy porting to other locales. A locale defines language and specific cultural conventions. The process of adjusting internationalized software to a particular locale is called localization

Question: Winsock with VB works fine if I specify a port (e.g., 1001). However when I set the Winsock’s port (local and remote) properties to 0 so that they would

Question: When accessing dbaccess through a script (in UNIX), what is the importance of the hyphen after the database name? For example: dbaccess mystores-

Question: I am getting an error (“Could not do a physical-order read to fetch next row” #244) while executing a job that runs a set of SQL statements every 30

Question: I cannot get 6 of 60 units to log in to an Informix application server. The units are all identical and they can ping the server. I get the

Question: Can I enable an Outlook profile to access two .PAB’s (the same way it can access two PST’s)? Answer: No, I’m afraid not. However, you could import one of

Question: How do I use a SQL select statement to combine two tables that are identical in structure but contain different data? Answer: The union statement allows you to combine

Question: My Informix usually server starts fine, but when I try to add a database chunk with the onspaces command I get an error (“shared memory not initialized”). Any ideas?

Question: My Informix 7.30 dies occasionally and returns the following message: 16:01:06 Checkpoint Completed: duration was 0 seconds.16:06:06 Checkpoint Completed: duration was 0 seconds.16:11:06 Checkpoint Completed: duration was 0 seconds.16:16:06

Question: How do I know if I am already in a transaction when I call a procedure from another one? Answer: I’m not aware of an easy way to do

Question: Should I make a call to GetObjectContext() in every function in my DLL? Obviously, you are going to do that in your “main” methods, but does calling GetObjectContext() in

Question: When should you use reference to pointers like those found in function arguments (class_name * & )? Answer: When you want the callee to change the pointer itself, not

When you need to compare two User Defined Type (UDT) variables to check whether they are equal, the only approach that you can follow in plain VB is to compare

Question: Since template code is generated at compile time, it implies that there should be a separate set of code for each template objects created. Does that mean templates increase

Question: Where can I find a list of reserved words in C++? Answer: Most C++ books include a list of reserved keywords. Here’s the list: asm do if return typedefauto

Question: With XSL, can I change the value of global parameters inside the templates named temp? Answer: No. Parameters and variables in XSLT, once defined, essentially are fixed for a

Question: What does the ‘* 1’ mean in this constant declaration? Public Const gcsDelimiter As String * 1 = “|” Answer: The * in your example defines the size of