August 26, 1999

Sharing Files Between VB and VBA

You can easily share files such as standard code, form, and class modules (BAS, FRM, and CLS files, respectively) between VB and VBA by using the appropriate menu commands. Within

Test for NULL Properly in a Recordset

Question: I have a column in SQL Server created like this: “vchrFirstName varchar (50) NULL” However, this code does not produce anything, including any errors, when the record is NULL:

Handling Single Quotes in Values From ASP

Question: How can I prevent sending the contents of a form field containing single quotes to the server? Single quotes should be converted to double quotes in a way that