Visual Basic

If you’re using Visual Basic 4.0 with Microsoft Access you can improve your access speed if you make your code OLE-compliant by using ! instead of (“”FieldName””) when retrieving values out of Microsoft Access recordsets.

If you’re using Visual Basic 4.0 with Microsoft Access you can improve your access speed if you make your code OLE-compliant by using ! instead of (“FieldName”) when retrieving values out of Microsoft Access recordsets.

For example, Value = Dy!FieldName, rather than Value = Dy((“FieldName”).

Incidentally, when you need to pass a variable amount of parameters to a procedure or function, make the last parameters a ParamArray (ie: MyParams As ParamArray). MyParams will now be a variant array. Use the Ubound to see how many elements are contained with the array.

{{Boward Computer Services,Tel: 01825 713488; Fax: 713474.718 on enquiry card}}