10,992 Topics

Member Avatar for
Member Avatar for sotvisal
Member Avatar for arice
0
82
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
73
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
146
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
121
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
104
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
86
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
154
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
54
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
77
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
47
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
87
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
74
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
35
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
68
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
101
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
139
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
129
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
41
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
171
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
103
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
103
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
53
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
39
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
142
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
75
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
72
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
221
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
911
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
211
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
104
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
77
Member Avatar for redear

help me on how access employee.mdb thru Data Combo and the data will display in txtbox...example in Data Combo will only display employee number and if i press employee number in Data Combo, the name, designation, address will display in textbox..how to code this? can you give me the module …

Member Avatar for redear
0
77
Member Avatar for gingank

Hi guys i have a question need to ask. I create an application for filling up information. After filling if he want to update when press update and fill up active = from yes to No then it will remove the table 1 to table 2 by using the sql …

Member Avatar for vb5prgrmr
0
124
Member Avatar for Petrock6

Hello. I'm a bit confused, and I don't know QUITE how to explain it, however I'll try my best! Anyway, say I wanted to code a API, that would grab a list from ANOTHER program. For example, if I had a small chatting program, and there was a list of …

Member Avatar for vb5prgrmr
0
96
Member Avatar for brieghz23
Member Avatar for siu17

I have been trying the following code for a code to search for a record and display it in a textbox Option Explicit Dim conn As ADODB.Connection, rec1 As ADODB.Recordset Dim esql1 As String Private Sub Form_Load() Set conn = New ADODB.Connection Set rec1 = New ADODB.Recordset conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data …

Member Avatar for vb5prgrmr
0
144
Member Avatar for gingank

Hi guys can you all help me with this. I need to sure will the this idea can be make in vb6. I have a update command button. When click then type the badge id , it will automatic get the data and show the employee name then the rest …

Member Avatar for 9884616532
0
304
Member Avatar for siu17

hi i have been able to update a database using the following code Option Explicit Dim conn As ADODB.Connection, rec1 As ADODB.Recordset Dim esql1 As String Private Sub Command1_Click() On Error GoTo 2 If Text1 = "" Then Command1.Visible = False Command2.Visible = True Exit Sub End If rec1.AddNew rec1.Fields(1) …

Member Avatar for vb5prgrmr
0
97
Member Avatar for iiizuluiii

Hey guys, Im new to the forum, so hello first off. I guess Ill get right to it. Im trying to make a computer program for my xbox 360 clan to download to help us calculate wins in a match. Its call of duty - domination game type, if any …

Member Avatar for vb5prgrmr
0
105
Member Avatar for iiizuluiii

so its been a verrrry long time since I messed around with vb. I am trying to make a program for my clan and here is a simple question I hope some one can answer. I am trying to make a button activate a radiobutton to checked if you press …

Member Avatar for iiizuluiii
0
196
Member Avatar for renu_kj

Hi, Is there an option/ or a formula to generate random numbers without duplication...Currently i'm not storing the random generated numbers in the database. Please help me..its quite urgent

Member Avatar for johnly
0
362
Member Avatar for kinger29

I am trying to create a program that analyzes sports statistics. I want to extract statistics from a website such as yahoo or espn and put it in a database. Does anyone know if this is possible to do with vbscript? Is there an easier way to do this? Any …

Member Avatar for johnly
0
152
Member Avatar for abu taher

I made a queiry. but every data show in this queiry double. I mean every data show two time in this queiry. why this problem occured. any body help me please.

Member Avatar for johnly
0
99
Member Avatar for srivathsa_4

hi, 'm a beginer. . i need a lil help to start learnin VB.. i dont hav much idea about it.. Kindly give me info of which book i can refer.. look fwd for much needed help..

Member Avatar for srivathsa_4
0
215
Member Avatar for Rajesh Ranjan

Hi everyone, Can any one tell me about the uses of let and get property in VB and how to use it?

Member Avatar for Rajesh Ranjan
0
102
Member Avatar for magenta_lover

Hi all, i want to open a file with this code [code] Dim linetext As String Private Sub Command1_Click() CommonDialog1.Filter = "Text Files(*.txt) | *.txt" CommonDialog1.ShowOpen If CommonDialog1.FileName <> "" Then Open CommonDialog1.FileName For Input As #1 Do Input #1, linetext Text1.Text = Text1.Text &linetext Loop Until EOF(1) End If …

Member Avatar for magenta_lover
0
126
Member Avatar for craigallansmith

Hi Everyone. I am busy building a VB 6 APP that will access a MS Access database. For the sake of this problem I will abreviate the DB. It has two tables. the main table has 6 bound text boxes to a data control. They work fine on there own. …

Member Avatar for craigallansmith
0
212
Member Avatar for firoz.raj

can anybody tell me how should i fill supplier name .in a list view using collection.here is the code what i have written.any help would be highly app reciated. [code=vb] Private Sub Command1_Click() Dim Item As ListItem Dim supp As Supplier 'object for class Set supp = New Supplier Set …

0
43
Member Avatar for ITTOBE

I'm trying to write a code that will allow for items to be displayed and when two are selected those two will be displayed in a different list box as a "receipt". If I'm not mistaken the code and everything is correct, but for some reason the items are not …

Member Avatar for firoz.raj
0
80
Member Avatar for brieghz23

Sir, can you please Give us a VB code for our cmdDelete button? a code that will delete a data from the database (ms access).. our form looks like this >>> [url]http://img229.imageshack.us/img229/7583/image002p.jpg[/url] or [ATTACH]10893[/ATTACH] we used the "listview" for displaying the searched item/s and be deleted... note: search and add …

Member Avatar for vb5prgrmr
0
294

The End.