Tip Bank

DevX - Software Development Resource

Linking Forms

Question: How do I use a CommandButton to link Forms? Answer: The Show method of a form can be used to show a second form from within another.

DevX - Software Development Resource

Conditional Compiling and Project References

Question: I am trying to support an application that needs to support DAO 3.51 and 3.6.How do I insert a project reference like this as a conditional compiler option? Answer:

DevX - Software Development Resource

Convert Informix File to Text File

Question: How do I convert Informix data under Unix to a text file? Answer: You can do this by using a SQL UNLOAD command: UNLOAD to textfilename.unl SELECT * from

DevX - Software Development Resource

Group by Score with IIF()

Question: What can I use in SQL that does the same thing that IIF(test,TruePart,FalsePart) does in Access? Answer: You can achieve the same result using the aggregate function COUNT and

DevX - Software Development Resource

Informix to SQL 7

Question: How do I convert Informix Database to SQL Server 7, or even to Access? Answer: First, you need to create the identical database in SQL7 or Access (same field

DevX - Software Development Resource

Include Files in VB 6.0

Question: Is it possible in VB 6.0 to include pieces of code through an include- or importstatement like the C #include-preprocessor command or the Cobol copy-statement? Answer: You can add