This code enables and/or disables functions during design andtesting. The code can remain during initial deployment withoutaffecting the end user. Make sure the path string being searchedis part of your
Here you are in VB3, you have loaded the compatibility layer for Jet2.0, and you are using ODBC. In this configuration, the ODBC queries willalways run in asynchronous query execution
Using Visual Basic’s GetSetting function might cause an error, particularly in certain situations when using itunder 16-bit operating systems with INI files. If there’s no specific entry in the INI
You’re probably familiar with the Mid function, which returnsa substring of a specified number of characters from its stringargument. But are you aware that Mid can also be used to
To move a control or form to a new location, you can set the Leftand Top properties to new values: frmCustomer.Left = frmCustomer.Left + 100 frmCustomer.Top = frmCustomer.Top + 50
Use Debug.Print “Entering event …” without breakpointsto trace events if they seem to act funny. Don’t use break points withMsgBoxes–they can alter the event sequence.
Eliminate “leading-zeros” in a text string in this interestingway: instring$ = “00030” ‘ set the string with some leading-zeros’ now to get rid of them….instring$ = CStr(Cint(instring$))’ now instring$ should
Use this as a fast way to paint the background of any form witha really cool “fading” color (lighter at top to darkerat bottom). To specify base color, pass True/False