Recent content by Bachenot

Hi vuy I'm not sure if an example is easily available; usually the user initiates an ActiveX object, such as a DLL, from a Browser, such as Internet Explorer, using an HTML form. There are many ActiveX controls, such as command buttons, input boxes, and file list boxes. Which ActiveX control...

Hi Sumam, Pius and Pavana When I initially saw this, my reaction was much the same as dpaulson's. All the course work and material I have read on the topic of client/server says that you should not put up to 7 million records on a client machine. Not only is it often too much for the...

Hi Mulgruper I've been looking for MCSD training also. My initial impression is that $11K is quite high. Do they offer a money-back guarantee? One place I have been looking at costs $5K. See http://www.developerinstitute.com/. They also work with you to get placed once you take the course...

Hi rvr, This looks like a problem that the Debug tools were created for. A couple of suggestions: run the project in break mode and see where the dll is referenced the first time and where the dll is referenced the second time. Add a watch and put the expression that occurs when the value...

Hi Bo Unfortunately the FlexGrid is not the correct Active X Control to use for this purpose. The FlexGrid control not only does not allow drag and drop but there is no other way for users to enter data in a FlexGrid control. To place data into the cells of a FlexGrid control, it is necessary...

Hi John Bates The WebBrowser control is very useful for this. It is listed in the components as Microsoft Internet Controls. The icon looks like a globe. There is a useful example in http://www.deitel.com Go to Deitel's Visual Basic book and download the examples. Then go to the example in...

The MSDN Library Visual Studio 6.0 provides a useful description and example of the Errors Collection. Note that this assumes that you are using ADO. See below. Any operation involving ADO objects can generate one or more provider errors. As each error occurs, one or more Error objects can be...

Hi ELG One way to have the numbers all the same length in a text file is, as you say, to pad the field with zeros. First, find the length of the highest number; say it has five digits. Make a new field as a text field. Make your new field have a length of 5. Then use the select case approach...

Hi Roby A good place to start is the MSDN Library Visual Studio 6.0. See the section entitled: Using the Internet Transfer Control This gives a description of this control as well as several short examples. Also check out the following article...

Hi ZebWeb The MsbBox function is set up, as any function, to return certain values. It is not set up to change fonts and add pictures. You might consider building an Active X control to do the tasks you want. Aggregate Active X controls, sometimes called subclassed or composite controls, might...

Hi Kori It is not clear what happens. What does the error message say? When you say "opening a VB program from the executable", do you mean: 1)Starting VB 2)Starting a compiled executable that was written in VB. Also, do you have the Active X control named EDT32x30.ocx on your hard...

You might want to check out a fairly new Web site: www.vbdesignteam.com Programmers suggest projects and ask other VB programmers to contribute. It provides experience in developing a project with other VB programmers.

I took a different tack, using the MSDN example, which uses input boxes. I also converted the length of the loan to years, which might be easier for the user than months. Also note that the payment in the Pmt function is negative because it is an accounting debit. I multiplied it by -1 to...

I've had this problem. I found that I had left a comma or a period after the END SUB statement. Try this. Go to the end of the END SUB statement. Push the delete key repeatedly and see if you erase something like a comma or a period.

The fields in your table appear to be the following: regions product1 price1 product2 price2 product3 price3 Let us assume that your table name is Goods. Then you can build SQL in the query window that might look something like this: Select price1 from Goods where price = 25; Is this what you...