Tip Bank

Question: Does XML work with VBA (Visual Basic for Applications)? I’m looking for a quick and easy way to store variable information that will be static once it has been

Question: How do I truncate the last five characters in a field? (The string length varies from row to row.) Answer: Try something along these lines: select left(myfield, datalength(myfield)-5)

Question: How can I create a crosstab in SQL Server 7.0? I’m used to Microsoft Access, where I can use columnheading and rowheading. Does this work in SQL? Answer: This

Question: Can I take a string that is held in a table and use it as part of a SELECT statement? I need to do this because I have a

Question: How do I extract dates from SQL where the date type is a datetimestamp? I have the following SQL statement: select * from Patient where PatientDOB = “03/01/58” It

Question: I have two tables and both tables have a one-to-many relationship. I want to add a new single record in the first “transheader” table (key is autonumber) and get

Question: How can I modify and update XML docs that are stored in the cache using a DCOM model (client side)? Answer: Given that caching is an IIS (Internet Information

Question: I have created a database of journal articles and want to offer users the ability to search the Author field for the surnames of authors. Most of the articles

Question: Can the latest version of ADO (ActiveX Data Objects) read and write an XML file as a recordset? Answer: Ah, let me qualify that: ADO 2.1 can currently produce