vba x 200

12,155 Topics

Member Avatar for
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
159
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
104
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
110
Member Avatar for dholt

I think this is the right forum as the Question pertains too php. I was just wondering as I think this is a very nice feature to Daniweb. The Text that is Displayed when you go to post in the background. I was wondering if someone could share that little …

Member Avatar for dholt
0
78
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
216
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
406
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
162
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
111
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
225
Member Avatar for ankit007

i am developing an application where i have to break a stream of numbers which are in .txt file and save it into access database.I need to know how to do this in visual basic.I have created a database at runtime and also created table with required fields but am …

Member Avatar for sknake
0
104
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
121
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
145
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
225
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
49
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
99
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
309
Member Avatar for fernando82

Hi everyone! i'm here again with another problem... this time i need to get a total from a field called "cantidad" (quantity) on the database... is there a way to get it with the recordset? or do i have to make another thing? Here is the code where i get …

Member Avatar for vb5prgrmr
0
87
Member Avatar for magenta_lover

Hi all, i'm newbie in vb, and i wanna learn a lot from u guys, i try to run this code, [code] Dim linetext As String Private Sub open_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 …

Member Avatar for magenta_lover
0
154
Member Avatar for Member #2466

Hiya, Just curious as to what scripting tool you may use for creating vbscripts. Just curious...I do most of mine using a text editor, but I'd be willing to check out other resources. Anyone have any recommendations?

Member Avatar for jp26198926
0
142
Member Avatar for siu17

Hi I need the code in [COLOR="Red"]VB6[/COLOR] to display data from a database in a listbox i tried the following code but its not working Do While Not rec2.EOF List1.ItemData(List6.NewIndex) = rec2.Fields(4) rec2.MoveNext ' i even tried Do While Not rec2.EOF List1.ItemData rec2.Fields(4) rec2.MoveNext

Member Avatar for jp26198926
0
130
Member Avatar for Esmael

Hi to all, Am studyng Biometric Fingerprint and i already have a hardware Finger Key Hamster by NITGEN. The problem is i dont know how to code that on VB6... Is their anyone can tell me how it works? does anyone have code for the SDK's Like enBSP SDK,FSIM SDK …

Member Avatar for Sukhraj Singh
0
88
Member Avatar for firoz.raj

when i press cancel button.it still prints.Kindly let me know .any help would be Highly appreciated.here is the following code what i have written. [code=vb] Private Sub btPrint_Click() Dim frm As IspecialForm Set frm = Me.ActiveForm frm.GetTextBoxInvisible frm.Refresh 'CommonDialog1.Flags = cdlPDReturnDC + cdlPDNoPageNums CommonDialog1.Action = 5 CommonDialog1.PrinterDefault = True CommonDialog1.CancelError …

Member Avatar for firoz.raj
0
2K
Member Avatar for shizu

Hi all, I'm using microsoft visual C++ 6.0 with SP4 and SP5.. I had a program which content a CScrollView.. Now I would like to add in a image into CScrollView.. but my image is buffer..not from resource.. I can save my image, bitmap form, into local drive.. but I …

Member Avatar for shizu
0
166
Member Avatar for sal21

Hi friend i use this code to connect via vb6 a mysql database in local. Is possible to connect other pc with the same code on the dsn on original pc where reside the dsn? Tks for all and sorry for my bad english i'm italian. Sub uno() Dim conn …

Member Avatar for vb5prgrmr
0
187
Member Avatar for shiv0013

how to delete a particular record in all the tables? i am not sure wat r the tables as i wil create them at run time i am maintaining an attendance for employees. a table wil be added for every month and when i delete a employee, his record should …

Member Avatar for vb5prgrmr
0
124
Member Avatar for shiv0013

how to find the number of fields and their names in ms access using vb6? i am using dao database.

Member Avatar for vb5prgrmr
0
50
Member Avatar for sbala_810
Member Avatar for naziatarannum

Hi All, Please help me in this. I'm a new member. I have a page with grid view appearance, data is coming in from table. For each column of the grid I have a button to sort data in asc/desc order of that particular column. I did this: <recordset_name>.Sort="<column_name> DESC" …

0
75
Member Avatar for moshe12007
Member Avatar for Member #248612
0
282
Member Avatar for bryan69

hi,im doing a Mobile Banking System for my project. how is it possible for me to use arrays as my data. n viewing it

0
78
Member Avatar for walter clark

Why can't I declare this near the top of the Form1.h file... int trackArray[4][999]; It strikes error C4368; something about mixed type. What is mixed about the types? Walt

Member Avatar for Ancient Dragon
0
149
Member Avatar for kehar

Hi everybody, I have used one textbox to accept date say ([B]dt.text[/B]) in which during form load two forwardslash will appear to accept [B]DD/MM/YYYY [/B]type date. Now when I click a [COLOR="Red"]Save[/COLOR] command box and if the [B]dt.text [/B]box is [U]not[/U] filled up with date OR say it has only …

Member Avatar for schanglani
0
151
Member Avatar for vanathi_vb

Hi, i have created a store procedure having 2 input parameters. i am using this procedure in crystal report. how can i send parametrs to crystal reports for input parametrs of store procedures using vb6 pl send some sample coding. its urgent. Thanks in advance, Vanathi.G

Member Avatar for schanglani
0
111
Member Avatar for shuffy

Problem is, The following code displaying the first node set out of results. I want to display all the results. PLS help. Private Sub cmdCallSoap_Click() Dim objResults As MSXML2.IXMLDOMNodeList Dim objNode As MSXML2.IXMLDOMNode Dim pstrPhpURL As String 'This is your web URL name Dim pStrFunction As String 'This is your …

0
64
Member Avatar for nikhil2911

i have an project in my TYBSc-IT to make calculator i dont understand how will my calculator will display its answers n also the expression on single text display as it is done in normal calculator which we people use daily plzzzzzzzz help.......

Member Avatar for vb5prgrmr
0
116
Member Avatar for brieghz23

VB Code About Closing 2 or more forms pls.. Ex: Unload me (close the current or 1 form) what about closing 2 or more forms..?? can anyone help me? pls.. thanks..

Member Avatar for vb5prgrmr
0
95
Member Avatar for sotvisal

Dim s, op, op1, op2 As String Private Sub cmd0_Click() s = s & cmd0.Caption txtresult = s End Sub Private Sub cmd1_Click() s = s & cmd1.Caption txtresult = s End Sub Private Sub cmd2_Click() s = s & cmd2.Caption txtresult = s End Sub Private Sub cmd3_Click() s …

Member Avatar for vb5prgrmr
0
142
Member Avatar for neuquevi

Please, has anyone how to connect to a folder that it's on the server using visual basic 6??? Thanks in advance

Member Avatar for vb5prgrmr
0
70
Member Avatar for samuelmoneill

Hi, I have written an application in VB6 to take in SMS messages from a SIM card and store them as Alarms in a MYSQL database. Each Alarm is stored in the database with the date and time of the alarm. I need to add a function to the application …

Member Avatar for vb5prgrmr
0
137
Member Avatar for Dangazzm

A bit vague I will try to be as descriptive as possible. Im making a program in Visual Basic my first one. And I want there to be 2 combo boxes and a Windows Media player Addon, Combo Box 1, I will select which TV Show I want to load …

Member Avatar for Dangazzm
0
97
Member Avatar for hjdaniel.sun

Hi I used the Data Source Configuration Wizard to connect to my access database, how do I write code to manipulate the data from the database? I read the book "Microsoft Visual Basic 208 step by step", it only teaches how to display data on the form. So how do …

Member Avatar for hjdaniel.sun
0
194
Member Avatar for PinoyDev

[Good day.! I need to bind a combo box in a list view.Once the user select an item in the combo box that has been binded, the combo box text will remain on the cell of the listview where the combo box has binded. Any help will be greatly appreciated. …

0
49
Member Avatar for rude04

is it possible to set the position of the picture inside a pictureBox? like making a small pictureBox and putting a larger picture inside,,instead of showing only the upper-left most part of the picture,,it would be able to show different parts of the picture..

Member Avatar for rude04
0
127
Member Avatar for gingank

Regrading to the topic can anyone help me about this and give me some example code for add and update data to ms sql 2000. I'm using the ADODB connection for the vb program! Help me i newbie on it. Please!

Member Avatar for vb5prgrmr
0
103
Member Avatar for erialclaire_238

I would like to know how i could continue to another form(form2) in visual fox pro when i use a command button next in form1.

Member Avatar for alcskid
0
95
Member Avatar for dinilkarun

Hi friends, I want to copy few cells of an excel sheet and paste special(picture) in ms-word. I want to develop a vb code code for this. Please help!... Regards, Dinil

Member Avatar for h.khuraidah
0
944
Member Avatar for roryt

I have posted this thread in the microsoft software forum as well but with no luck. If anyone can tell me how I can save a active excel file using a macro to save it in a folder using the current date as the file name. I hope that was …

Member Avatar for leecker
0
873
Member Avatar for samuelmoneill

Hi, I am writing an application in Vb6 to take in SMS text messages and store them in a database. I have 3 timers The first has an interval of 2 seconds In this time it checks the SIM card for messages and sorts them into a database and displays …

Member Avatar for vb5prgrmr
0
111
Member Avatar for gingank

Hi guys i need to ask if i have create a table then display it on the data grid on the vb program but the table have many Same ID number but different people so do it got any problem if i do like that ?

Member Avatar for vb5prgrmr
0
63
Member Avatar for shouvik.d

Hi All, Currently I have an excel workbook which can send emails using smtp mail server on a specific trigger. The limitation I am having is the mail body is in Plain Text. Is there a way to create HTML emails via the Macro and send it across using SMTP …

0
131

The End.