Search results for query: *

I got sick and tired of looking for this SPUFI error so I did some QW lookups and some experimenting and determined that the 5th felid of the DSNT416I message is the relative offset of the 1st character of the error counting only 72 columns per line in TSO. DSNT408I SQLCODE = -199, ERROR...

A friend got the ISECURITY Virus. DO NOT PAY FOR A FIX. I fixed it with REGEDIT and SEARCH. Go to RUN. Type REGEDIT and press enter go to EDIT/FIND and look for ISECURITY FILESECURITY will show up also in the FIND DELETE all ISECURITY Entries, not FILESECURITY Search C: for ISECURITY You should...

Visual Studio 2003 Hangs Contacting Web Server. This happens to me once in a while and I finally figured out how to fix it without redoing the entire solution. Three different Solutions came up with this problem on the same day. Open the SLN file with Notepad. Remove the offending Project from...

When switching from DB2OLEDB to the MSDB2 managed provider with strongly type datasets, I encountered a "Cannot get value because it is DBNull". The field was defined in the DB2 database as VARCHAR. I included a WHERE field IS NOT NULL in the SQL but the row was still returned, verifying that...

Theoretically it is 32767. Visual Basic Specifications, Limitations, and File Formats Property Applies to Limitation List and ListCount List box and combo box controls Maximum number of items is 32K; the limit on the size of each item is 1K (1024 bytes). www.VBResizer.com Forms/Controls...

Security Alert: "SQL Injection Attack". Never put user input directly into an SQL request. Always use apostrophes around the values you are sending, even those that are supposed to be numeric then double-up any apostrophes in the received data. Dim strWhere Dim strQ strQ =...

Stop command stops execution and should display the code in the editor. I use it because my code is either executed by Open or I've called it from a VB executable...thus no open VB editor in which to set a breakpoint. Once in the debugger, I set all the breakpoints I want. From the Help in the...

I would start with recording a Word macro while I manually used Tools / Track Changes / Compare Documents capability and look at the generated code. www.VBResizer.com Generate Forms/Controls Resizing/Tabbing Class www.VBCompare.com Compare Code (Text) www.VBSortGen.com Generate Sort Class in VB...

Dim dteLastMonth As Date dteLastMonth = FateAdd("m",-1,Now) www.VBCompare.com Compare Code (Text) www.VBSortGen.com Generate Sort in VB or VBScript

I use objects. Dim mobjdocument as object Dim objelements as object Dim objelement as object With mobjWeb Do Set mobjDocument = mobjWeb.Document If Err.Number <> 0 Then Exit Do If mobjDocument Is Nothing Then Exit Do '***** '* META...

www.msdn.microsoft.com / Libraies / MSDN / Visual Studio / Visual Basic / Using VB / Component Tools / Creating Active X / Creating Control WWW.VBCompare.Com

Check out this MSDN link. For all those exporting data to Office, it appears that new versions of Office can break your code if you use early binding. http://msdn.microsoft.com/library/default.asp?URL=/library/techart/VSOfficeDev.htm Click on VB Frequently asked questions...

The ENTER key is a special case. If a command button has property DEFAULT set to TRUE then the following applies: &quot;Only one command button on a form can be the default command button. When Default is set to True for one command button, it's automatically set to False for all other command...

Sub Textbox1_KeyPress (keyascii as integer) If KeyAscii = 8 then exit function ' Backspace If Not(Chr(KeyAscii) Like &quot;[a-zA-Z]&quot;) Then keyascii = 0 End Sub WWW.VBCompare.Com