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

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

Copying a Database

Question: What’s an easy way to make a copy of a currently open database? I’ve got open recordsets all over the place that I don’t want to close. Answer: Simply

Using SelText Property

Question: I can’t figure out how to add (runtime) a string variable into a textfield that already contains text.My thought was: Text1.Text = Text1.Text + “STRING VAR”this will obviously only

Detecting Microsoft Video for Windows

Question: I need to inquire if Video for Windows has been installed beforeattempting to play an AVI file. How can I do this? Answer: All versions of Windows keep track

Hiding Mouse Pointer at Run-time

Question: During run-time, for a particular reason, how do i hide/unhide mouse pointer? Answer: Here’s how to hide the Mousepointer:The Declaration:Declare Function ShowCursor Lib “User” (ByVal bShow As Integer) As

Creating a Generic Handler

Question: I am trying to write a generic error handler and would like some way of determining which proceedure or function the error has occured so that the generic error

Setting System Time

Question: I am trying to sync my system time with the servers time usingwinsock. but I need an API call that allows you to set your system date and time.

Type Mismatch Error

Question: I have an SQL statement in my program that looks like this:data3.recordsource = “SELECT id, date from reservations where (date = ‘” & maskededit1.text & “‘) and (id =

Connecting RESTful Web Services to an ESB

ften considered the backbone of service-oriented architectures (SOAs), the enterprise service bus (ESB) has emerged as a standard for enterprise-wide integration among disparate information systems.