Visual Basic 4 / 5 / 6 Forum

Hi all I developed a database using vb6 code I passed all the data to an excel file through code And I saved and closed the Excel application in the name "D:\Books Database.xls" via vb6 code My code to save and close is *********************************** oXLApp.Visible = True

Hi all I am trying to create a database using vb6 and excel I created few controls on the vb form and coded to get the details from the user I code in the way to pass the data which i got from the user to an excel sheet I named a function in a module as "Appending" and i made it to receive all the data through arguments And almost I coded...

Attached is: - Documents (DOC and PDF) explaining "How to use BREAKPOINT and WATCH". - The VBP used in the document.

Hello experts! I have a form with "Export Project List" button. I have an Excel name Project List with 2 worksheets Sheet 1 and Sheet 2. I need to figure out how write my VBA code that when I click from the "Export Porject List" button, access will import the 2 sheets from Excel to Access table. And since I have to worksheets from my...

Hi I have some problem crystal report by formula field I want to display full record with length as defined in data structure without any trims as field position get violate as there is any change in preceding field for example sub m1 m2 m3 11 g1 a2 a 12 a1** b1 c1 13 a b1 c2 my formula is

I am trying to get the status of a Windows Media Player object without success, so that I can determine when it is done playing the current audio file. The intent would be to poll the status until it is complete, but if someone knows how to have an event procedure activate when it happens,that would be better. System: Windows 7 32 bit, MS...

Hi Guys I have a small issue with page setup, you know that in page setup there is a printer paper, and drawing page, I know how to change the printer paper but I need also to change the drawing page to be same as printer paper size. I have used those codes to do this but still missing the code to make the drawing page to be same as a printer...

Dim obj As PageSet.PrinterControl 'Reference Pageset.dill Set obj = New PrinterControl obj.ChngOrientationLandscape DataReport.Show The above coding work properly in WindowsXP, but in windows7 page setup dose not work , show the massage report wide is larger than paper width. How can I solved the problem.

i have used msflexgrid in vb and i want to merge cells its done, but only with similar text or data, i want to merge with different data PLEASE HELP ME

How do I tell the compiler to use the 32 bit ODBC driver when compiling a VB6 program in a 64 bit machine, W7. When compiling it comes up with several SQL errors but does not offer any other info. When running the program it comes up with a "file not found" error without further info. It appears as though it is using the VB6 - 64 bit sql...

Within a class module I open an ADODB recordset of a single field and then move it to a Variant with rst.GetRows Public CloseArray As Variant Public Sub OpenRecordset() rst.CursorLocation = adUseClient rst.Open "SELECT Field5 FROM " & MarketTableName & " WHERE Field1 BETWEEN " & stringStartDate & " AND " & stringEndDate & " ORDER BY...

i want make a system that would automatically create a table in a database like .. its just like creating an organizational unit which is the table to be created.

Hello everybody. I wrote this code to add the data to Msflexgrid .... But I want to transfer data from Msflexgrid to database ACCESS ??? =================================================== Dim intRow As Integer For intRow = Msf.Rows - 1 To row Step 1

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 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! ^_^

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

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...

The application was written in c++ and vb with message table that can be change to different languages we already translate it to German and other Latin languages now we would like to translate to Chinese is it possible using an ASCII codes

I want to do a project in the base of process scheduling(FCFS,SJF,RR). That i have to design in visual Basic.. and to bring out the process via access as a back end. is that possible to do the project.. please suggest me.. it ll be helpful for me.. please replay

Good Day my fellow programmers! I am thinking if is it possible to manipulate or compare the values that is on DataReport considering that I: Set DataReport1.DataSource = rs I want to know if ("Text1").DataField = "Name" contains a specific value, if yes then the label next to it will have a caption. I want to know if it is possible or...

I am trying to connect to the WMI Service on a remote PC but my script hangs at this line (GetObj("winmgmts:\\" & $strComputer & "\root\cimv2"). The service looks like it's running but I am not able to restart it. Usually a reboot or a repair works fixes the issue. I come across a PC in this state from time to time so I would like to be able...

Hi to you all! Am curently on a project in VB 6.0 where i hav used a datagrid to conect to DB and display records which is PERFECTLY OK! my headache is how to use AUTOFILTER the fields? HELP pliz!

I'm setting up a program that needs to know when calender events have been reached. i.e. "Out to lunch" Staring 12:00 PM, Ending 1:00 PM. I did find some code that referenced the Default folders but each time it did a "Set objExplorer = objFolder.GetExplorer()" a new incidence of Outlook would startup. I do get the info I'm looking for, but...