10,991 Topics

Member Avatar for
Member Avatar for exzibit23

how can i connect SQL(local server) to VB6?? Please give me the STEP BY STEP PROCEDURE.. i dont really have idea on how to connect SQl to Vb6

Member Avatar for vb5prgrmr
0
71
Member Avatar for avisek_cts

Private Sub Command1_Click() Dim PDDoc As Object Dim AVDoc As Object Dim AcroExchApp As Object Dim PDSaveFull As Object AcroExchApp.GetActiveDoc Set AcroExchApp = CreateObject("AcroExch.App") AcroExchApp.GetActiveDoc AVDoc.GetPDDoc PDDoc.Save Set PDDoc = AVDoc.GetPDDoc If PDDoc.Save(PDSaveFull, "c:\test.pdf") = False Then MsgBox "Unable to save image" Else: MsgBox "The file is saved" End If …

Member Avatar for vb5prgrmr
0
144
Member Avatar for oscarresonable

Hi guyZz... I'm a beginner in programming world..,! Can you help me guyZz of restoring data of mysql using vb6 codes..... Any reply and some source is really appreciated.... Thanks in advance..... Oscar Resonable

Member Avatar for vb5prgrmr
0
118
Member Avatar for alski

Hi people. I have a time and attendance module in VB6 which saves transactions (ADO) in MS-SQL if there is a LAN connection, and save it locally (MS Access) when offline. The trigger is when someone logged in. This is what I did: [Code] Set cn = New ADODB.Connection cn.Open …

Member Avatar for alski
0
100
Member Avatar for firoz.raj

simple want when user click on close form button.all the form should close except Mdi form.but MDI Form also get close.Kindly let me know. any help would be Highly appreciated.here is the code what i have written. [code=vb] Private Sub FrmClose_Click() Dim frm As Form For Each frm In Forms …

Member Avatar for firoz.raj
0
84
Member Avatar for abu taher

at 1st: class name entry in a text box (by add new button). access file is store it. then in a another form (when a student admitt) enter all data of this student (in few text box) without class name. when I want to entry the class name then I …

Member Avatar for abu taher
0
151
Member Avatar for singoi

Hi friends, i got a frame with Listview which shows all the records from access table with duplicate BANF nrs.like u see in first pic BANF nrs 1 and 2 BANF Nr 1 BANF Nr 2 ID NAME ID NAME 1 MARKUS 1 INGO 2 SHEELA 2 WEBER 3 ROHIT …

0
53
Member Avatar for wap73

recently i m working on a business software in vb6 and ms access. How can i get registration no for this. It can be generated only through machine id (HDD no) 10 digit in alpha numaric and numaric combination and key no. (any no in any combination). There also a …

Member Avatar for vb5prgrmr
0
74
Member Avatar for wien

I have an access database that I wish to password protect, If i am only using access that is simple. I have a program in VB6 that reads and writes to this database I need a little help in setting up the Access data object in VB6 any ideas.

Member Avatar for vb5prgrmr
0
44
Member Avatar for Tham0

Hai, I have an excel where i stored my data.asssume it has multiple rows and 5 columns.Now in my form i have 4 Combo box. when user select first combo box (which refers to first column in excel sheet) ,it will filter data's in the second column (uses user input …

Member Avatar for Tham0
0
86
Member Avatar for Ptero

I have an ASP.NET application that generates Excel files that should be downloaded by user. These files contain some VBA code that is added with oWB.VBProject.VBComponents.Item(i).CodeModule.AddFromString(s). The "Trust access to Visual Basic Project" in Excel > Tools > Macros > Security is checked. The "Network User", "ASPNET", "IUSER", "IWAM" users …

0
71
Member Avatar for myDAO

hello! everyone.. good day to all! I'm new here and i just want to know how to input directly in the flexgrid without using any textboxes?? please help me? god bless, Thank you!

0
32
Member Avatar for oscarresonable

Hi guyZz.... Can u help me with my project...??? I need a report designer that the end-user can design their own what they want... specifically you can design a report in runtime......! urgent please....... Any idea and some source is really appreciated..... thanks in advance....... Oscar Resonable

Member Avatar for vb5prgrmr
0
66
Member Avatar for vanathi_vb

Hi, I am using seagate crystal report version 8 with vb application. I need to send this applicaton and crystal report to client place.but they dont have crystal report software.kind of setup is enough or they have to insatll crystal report software.if set up is enouhg , how to make …

Member Avatar for vb5prgrmr
0
100
Member Avatar for liverpoolfc108

Hey! I'm working on this solution that wants me to code an application that displays the highest score earned on the midterm and then the highest score on the final exam. This is waht I have so far but it is not working... Option Explicit On Option Strict On Public …

Member Avatar for Teme64
0
138
Member Avatar for coachD

i want to mix a different fertilizers available in the market to create a new fertilizer WITH MY DESIRED AMOUNT OF NPK(Nitrogen, Phosphate, Potassium)... i can do that in so many ways but i want to get the mixture with cheapest cost. here is an example, ------------------N-P-K Numbers------------COST(Peso) Fertilizer 1-----(24-2-8)---------------------100/bag …

Member Avatar for cafasa
0
127
Member Avatar for Trevor Charles

I am new to VB, I am running VB6 and need to update a number of text boxes from information collected in a loop that is running, is theire an update text box command ?

Member Avatar for vb5prgrmr
0
40
Member Avatar for singoi

Hi Freinds, a Complicated situation for me. i Have a 2 tables in access with the same Field saying BANF_Nr which sees like " -BANF-0001" here this 0001 is an Autonumber like 0001,0002,0003,0004 and so on i have a textbox in Form txtbanf which should call automatically the next number …

Member Avatar for vb5prgrmr
0
167
Member Avatar for samuelmoneill

Hi, Does anyone know how to send commands to a shell that is already opened? I know how to open the shell to run a command, but how do I send another command to it? Here is what I can do Shell("C:\Backup\mysqlbackup.bat") This command runs the mysqldump command. But the …

Member Avatar for VIeditorlover
0
101
Member Avatar for wien

Hi I Have created a software program in VB6 that a customer can use to create job cards for jobs within the printing industry. it links to a database so all the information is saved and can be amended or updated or searched. I plan to market this to potential …

Member Avatar for wien
0
101
Member Avatar for dks1383

Hi all I want to set NumberFormat property in DbGrid in Vb6 so the negative numbers be red automatically please help me. Thanks.

0
51
Member Avatar for Piya27

Hi All, I have recently installed Visual Studio 2005 after system recovery... and now when I start debugging any program, it shows me the following error : [b]"Error while trying to run project : Unable to start debugging. The Binding handle is invalid."[/b] Please Help.

Member Avatar for vb5prgrmr
0
38
Member Avatar for oscarresonable

Hi guyZz.. I have a POS project..... how can I stop/pause the spooling of the receipt in the printer??? b'coZz it's too many space in the paper... I need this... urgent......... Any reply/some source are really appreciated... thanks

Member Avatar for vb5prgrmr
0
138
Member Avatar for santhanalakshmi

Hi, This is my code : Dim fullreason As String fullreason = " " Do While Not rswithd.EOF Dim fs As Integer fullreason = Trim(fullreason) + " " + "and" + Trim(rswithd!reason) Print #1, Trim(fullreason) Loop for example : fullreason contain values "10 pencil". i want only "10" from this …

Member Avatar for vb5prgrmr
0
72
Member Avatar for firoz.raj

i want to see all the installed font name using for each loop.i have written a code but it say object required.and it break at bold line. kindly let me know any idiea? [code=vb] Private Sub Form_Load() Dim f As Font B]For Each f In Fonts[/B] MsgBox f.Name Next [/code]

Member Avatar for vb5prgrmr
0
70
Member Avatar for thwias1b3008

Hi, I used PostgreSQL and i want to populate its fields in combo box. Is anyone know how to make it. . Please help me. . . it is for my project. . :icon_sad: Here is my code: Dim conn As ADODB.Connection Dim rst As ADODB.Recordset Dim sSQL As String …

Member Avatar for vb5prgrmr
0
218
Member Avatar for avisek_cts

I want to draw a graph in vb6 thta will take data from the database (here it is MS ACCESS) .The databse has a table with 2 columns,How to draw the 2d graph dynamically, I am connecting the databse and vb 6 but an error is occuring Please tell me …

Member Avatar for vb5prgrmr
0
900
Member Avatar for jbfsantelices

Hi to our community! Just want to get some idea regarding the connection setup of SQL Server 7.0, I've been doing an application written in VB6 and I used SQL Server 7.0 as a storage of my database. On my local pc I can successfully connected to SQL and manipulate …

Member Avatar for vb5prgrmr
0
192
Member Avatar for exzibit23

this is the code for tje fading effect of a form.. can anyone explain this code to me.. i really wanna learn this thing.. or do you have any site or ebooks to read related to my problem?? I dont know what book should I read. Is this all about …

Member Avatar for vb5prgrmr
0
101
Member Avatar for iiizuluiii

Im trying to take two different input fields and have a counter count them to see which one would reach my goal of 200 first. Im very slow when it comes to vb. Is there a timer tut that anyone knows of? Is there a base program I might be …

Member Avatar for iiizuluiii
0
76

The End.