Visual Basic 4 / 5 / 6 Forum

Got an extensive Access program on my PC with a backend mysqldb with a provider. I know how to get a Pass Through Query running for a simple query but I get stuck with the following SPT query (SQL Pass_through): SELECT Bankbook.Date, Bankbook.SeasonID, Bankbook.Data1, Bankbook.Data2 FROM Bankbook WHERE...

How do i read data from an XML file in VB6.0(Parse it) and display it in a TextField on the VB6.0 form? I would be highly grateful for any help on that.

my question is that i have to change the table name during runtime. depending on the items selected in the dropdownlist. i am using asp.net as front end, c# as code behind language, and sql server 2005 as back end. " i need to change table name in the query in the aspx.cs page" can i???

hello all, i am trying to read smartcard serial number. can you sent me a sample code in vb or java or .... thank u.

I have a problem in saving grayscale picture from picture box i have this code for grayscale Private Sub CMDGRAY_Click() Dim Color As Long Dim NewColor As Long Picture2.Picture = LoadPicture(CommonDialog1.FileName) Picture2.ScaleMode = vbPixels X = Picture2.ScaleWidth Y = Picture2.ScaleHeight

id like to know if its possible. i need to find the location of black and white color in the picturebox. per pixel and store it to array. for example; http://a7.sphotos.ak.fbcdn.net/hphotos-ak-ash3/542389_10150966243980388_1087506066_n.jpg there are color black from x1 to y5. i want to store it to array example; pixel,,,, how can i do it...

Hi, I have an application that runs off a file server and can be accessed over the LAN network by 10+ machines. I want to ensure that only one instance of the application run at any time over the entire network. the "Previnstance" method does not work as it checks only on the local machine and not the network. Also cannot create a check...

i'm having problem in closing my recordset while it is used in many purposes.. if i'd only knew a condition that would help me determine whether a current recordset is open.. it would help me a lot...

Hi all, I am having trouble with DAO (VB6) reading an Access database. I keep getting a "read-only" recordset instead of Updatable one. Set qdfLocal = dbsCurrent.OpenRecordset(myQuery, dbOpenDynaset) the help file suggests that the Jet engine can't create an editable recordset, but I don't know where to look for the error....

hi guys, i'm making a biometric attendance system with a fingerprint scanner..can you pls help me in getting the data from the f.scanner to a database using vb6.. sample codes can help a lot.. model: H3 finger print scanner usb connection thanks! ^_^

How do I write a utility that when installed it would: * Load an incon onto the System Tray durign system start up * When the icon is right-clicked it would display a menu with two options: - Radio ON - Radio OFF But only one option should be available at a time, depending on the state of the Wireless device. If the Wireless radio is already...

Hi all, I am having trouble with VB6 (running in windows7) talking to an Access database, and was hoping someone could help me locate the error. the database contains a "DateIn" field of type "Date" (short Date) I am reading the table into a recordset called "rsDiv" I am trying to read only records for the financial year, between to ...

I have no code and need a starting point for writing it. First, can it be done? Second, I need an example. I have many CDs, both commercial and those converted from cassette and vinyl disks, that I am storing information (not the music) in my Music Library program. Typing in the data is time consuming. The CDs list most of the information on...

I have found that when I connect my VB application to an Access database and perform the query: LIKE ? + % That special LIKE query doesn't work the same way with MySQL or SQL. I've played around in MySQL and found that: LIKE '%' & ? & '%' does just about the same thing, and actually works a little better than the access query above. my...

Private Sub Command1_Click() Dim EndDate, CurDate As Date Dim BusDay, TotBusDays, CalcYear As Integer TotBusDays = 1 CurDate = DTPicker1.Value EndDate = DTPicker2.Value Do Until CurDate = EndDate BusDay = Format(CurDate, "w") Select Case BusDay Case "2" To "6"

I have a very VERY basic knowledge of VB6, I've been using it for years but following tutorials etc. I'm not stupid but far from knowledgeable. Here is (hopefully) all you'll need to know what I need help with. http://i49.tinypic.com/35n6j6f.png

Hello, I'm experiencing the same problem over and over again and my professor is too busy with other students to help me in most of my labs. (I'm not trying to get anyone to do my homework I just need one simple answer.) Anyway, I tried to make a module: Sub compareArea(ByVal rec1Area As Double, ByVal rec2Area As Double) Blah Blah...

Hi, I am using Vb6.0 for development projects here, the Grid control accepting only up to 6 digits only, How can set it up to 7 digits or max . Thanks in Advance, VENUS

Hi Experts, Kindly help.This is my header sHeader = "/cABC MALAYSIA SDN BHD" _ + "/n/cNYNAME" _ + "/n/cNEWYORK , UNITED STATE" _ + "/n/n/c SUMMARY" _ + "/n/n/lLOT ID: " + rc.Lot.Id + "/n"

Hi Iam doing crystal report,i have a problem is there, How to creat textobject in rpt file by dynamically and assign the values, plz tell me

how to use different fonts in listview in vb06

Hello All, Would u plz tel me what is the syntax to clear a dynamic array?? i have tried Erase arrayname but is there any other way to clear the arraylist? thank u very much in advance

hello! i just wanna ask on how to load an html or txt file from a certain monitoring software(specifically commView for WiFi) to VB programming language? TnX a lot:)

I tried the printer.print method but after printing the printer is scrolls the paper as per the paper size like A4 ,legal I needs print the next receipt without scrolls the printer. I wants use the paper not scrolled after printing one receipt and used to print the next receipt from where it stops the printing kindly suggest me a solution

I have vb 6 32-bit running on Vista 64-bit Premium Home. I am writing a Music Library program for my collection of Music CDs. Although I have used InStr in other appications and it worked, it will not in this app. I have a string of Artists in the database. I want select one of the string that is not first and print it to the MSFlexGrid....