Tip Bank

Question: How do I send data from a form in an ASP page to a database table in SQL Server 7.0? Answer: Obtain the data from the ASP page’s Forms

Question: How do I format my numbers in the format ######, where a number of 123 would display as 000123? Answer: Concatenate a string of zeros to the left of

Ever wanted to delete files from the local machine that your SQL Server database is running? You can do it using the extended stored procedure xp_cmdshell like this: EXEC master..xp_cmdshell

The TreeView control doesn’t expose any property that lets you limit the amount of text users can type when editing a Node’s label. However, you can do the trick with

Sendkeys “{TAB}” can lockup the keyboard in Windows 2000. Here’s how toexecute a tab in the keydown event using the Win32 API to get around thisWindows 2000 bug: Private Sub

Question: Why do I get the error message “Could not create a new session because the file wasn’t found” when I try to start a new emulator session? Answer: Be

Question: Once end users have created contacts, how do they export them to their home computers or laptops? Answer: I assume you’re looking for a simple—if inelegant—way to just “floppy

Question: Can I run a program/process/rule to prune the sent items and/or deleted items folder for users? Answer: You could use either ExMerge or Mailbox Manager to do that. ExMerge

Question: How do I set up offline public folders that are synchronized on a laptop that runs Outlook 98 connecting to Exchange 5.5? Answer: Have the users who want to