devxlogo

We are an award-winning tech entrepreneurship website where trusted experts can provide value globally.

Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.

devxlogo

Trusted for 26 years

Over 30K Articles

1M+ Readers

Expert-reviewed

10K+ Tech Terms

As seen in:

microsoft logo
business_insider_logo
wired_logo
berkley
arstechnica_logo
hackernoon

The Latest

Benefits of Using Control Arrays

Question: Is there an advantage to using a control array instead of using x number of labels, textboxes, etc ? Answer: There are several advantages to using control arrays. First

Using JOIN Clauses

Question: I’m working with Visual Basic and Access 1.1. Currently my program uses two tables (tblrep and tblsales). The common field being tblrep.id = tblsales.id. The first form of the

Writing Data to Disk

Question: I have written a testing program that writes results to a grid.How do I write the grid to disk so that changes can be addedfrom testing session to testing

Using Multiple Groups of Option Buttons

Question: I need to place multiple option buttons on a form. I alsoneed to be able to have two buttons selected at all times.I can do this with multiple frame

Retrieving Binary Objects

Question: I am using VB together with Access. What I want to do is to include photo into my form. In Access table, I declare thisfield as an OLE field

Searching Numerical Fields

Question: What it’s the correct SQl Statement to search an access database by a numeric field? I keep getting an invalid type error when I try to run the application.

Events Not Processed Correctly in Debug Mode

Question: I am having a problem that I hope has not been answered herebefore. I am experiencing different results when I run a program than I do when I use

Manipulating Strings

Question: I don’t know how to access individual characters in a string.ie. accessing single elements in an array of characters.Each time I try I keep getting Type mismatch. Answer: You

Command Line Switches

Question: I have a formless VB exe program that creates VB modules(.bas) and saves them to disk.Is there a way of having my program start VB passing my module name

Entering Data into Sheridan SSDataGrid

Question: I have a copy of data widgets from sheridan sware and am using the SSDataGrid provided. All i want to do is insert data in the grid at a

White vs. Grey Background in Panel Control

Question: I’m using the 3D Panel in my application. When I setits background coulor to light grey, it looks fine onmy workstation but it’s white in any other workstations.That’s true

Setting Cursor to End

Question: Is there a way to put the cursor at the end of the text in a text box? I use .SetFocus to put the cursor in a multi-line text

Getting Procedure Location Name

Question: Can I get the name of the procedure that an error has occurred in?For example, I would like to send my error to a form that containsthe error number,

Calling Stored Procedures

Question: Can one call a stored procedure or function in oracle 7through odbc from visual basic? This might be a questionfor an oracle user group, so if you know where

Aligning Columns in a List Box

Question: I have a List with names and addresses from a database.I want to have the list as shown below.Mr. Smith Street 10Mr. Andersson Street 25I’ve tried aligning them by

Using Global Variables

Question: I have visual basic 2.0 Hopefully not for long. If I make a button that does a funtion like this. n = n + 1 print nit gives me

Automatically Converting to Uppercase

Question: I’m trying to use the KeyPress event to automatically uppercase what the user types. How do I do it? Answer: Put the following code into the KeyPress event of

Method Comparison

Question: What is the best method to use for updating an Access 2 database from Visual Basic? I am a bit confused aboutthe methods presented such as 1) VB Data

Searching Date Fields

Question: In procedure, I used statement like this:ds.FindFirst “fulldate = ’95-10-31′” ‘ds is DynaSet variablebut always it fails, and ds.NoMatch Value is True(-1).What’s wrong with this? Please help me. Answer:

Changing File Extension

Question: not having programmed in any of the BASIC languages, I am wondering if Visual Basic’s string variable is in anyway similar to what a string variable is in C

Checking for File Extension

Question: What’s wrong with this code :if file1.filename=”*.bmp” then picture1.LoadPicture(file1.filename) Answer: I’m guessing you’re trying to check the selected filename to see if it ends in .BMP, right? The problem

Replacing OpenTable

Question: We have a Large VB application (code wise) and we are movingthe data from MS access to Sybase using the ODBC driver.Now, after we presented the project’s time tale

Opening Access 2.0 DBs

Question: I am trying to connect my MS ACCESS 2.0 Database to the WWW viaa VB-CGI-Script. I figured out, how to transfer data from a HTML-Form to my VB-programm but

Clearing Text Property

Question: Is there any way to clear a combo box without it’s Textproperty being set to null? Answer: As far as I know and have tried, the only way to

ScaleWidth vs Width

Question: I am resizing my widows during runtime. I also want my dialogboxes to resize with the window. My program is doing thiscorrectly. But it is not resizing the command

Ensuring Single Instance

Question: I have a requirement to only allow a copy of an application to be executed once.If someone tries to execute the app a second time, I want to give

Converting to DAO 3.0

Question: I have a Huge front end to an Access database. The front end was created in VB3.0, I recently upgraded to 4.0, it states that the references should work

Finding Variable Values

Question: Data1.Recordset.FindFirst “LastName = ‘Quayle’”Ok that works fine. Why can’t I:Data1.Recordset.FindFirst “LastName = VarLN”where VarLN is a variable which the user has just provided? I get error 3070, “Can’t bind

Clearing the Contents

Question: Is there an easy way to clear a combo box’s contents, other than using the Clear method? Answer: One of my users suggested that if you add a space

Error Handling: The Sooner, The Better

rrors and exceptionsare two similar notions that differ in one crucial aspect: exceptions are a runtime concept, whereas errors are anomalous conditions that can and