Tip Bank

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

Question: I have two databases, each on a separate machine in a network. I want to generate a report extracting data from table1 in database1 and table2 in database2. How

Question: I want to add two numeric fields with values like these: Example 1: One field named Amount contains 565.25 and other field named Ticket contains null. select amount +

Question: I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact

Question: I want to convert a signed integer into a 16-bit binary as part of a SELECT statement. For example: select myint, howeveritsdone as Binaryfrom mytablemyint Binary—- —————–137 1111111101110111-100 1111111110011100

Question: How do I force a linefeed character using SQL? I created a report (see below) but when I e-mailed this report from Unix the carriage return was not interpreted

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