vba x 200

12,155 Topics

Member Avatar for
Member Avatar for furjaw

Visual Basic.Net: I have a DataGridView in Last Name sequence. Is it possible to when a user types the first letter of a last name that it displays all rows with last names that start with that letter. When he types the second letter, it displays all records whose last …

Member Avatar for isharpk
-1
4K
Member Avatar for linky1hit

Read text file after change text " text1 " to " text2" Example text file name hhh.txt have content sdasdsa ádsaewf dsasa asdsa text1 asdksls text1 as +>>>> hhh.txt sdasdsa ádsaewf dsasa asdsa text2 asdksls text2 as Thk :)

Member Avatar for deepakbshitole
0
306
Member Avatar for vonnoy

hi, im new in vb6 how to search in datagrid where every keyword you type wil display the record found in database? here's my code in saving pls ned help here....this is our thesis God Bless>thanks. Sub search() 'search if student is registered then With ado .ConnectionString = connectdb .RecordSource …

Member Avatar for deepakbshitole
0
5K
Member Avatar for jakub.peciak

Hi, I have following code. Dim myData1 As MySqlDataReader Dim sqlquary1 = "INSERT INTO table1 (text1) Values (Value1); INSERT INTO table2 (text2) Values (Value2); INSERT INTO table3 (text3) Values (Value3)" Dim command1 As New MySqlCommand command1.Connection = mySqlConnection command1.CommandText = sqlquary1 myData1 = command1.ExecuteReader mySqlConnection.Close() I need to send few …

Member Avatar for Reverend Jim
0
1K
Member Avatar for gmissile1

well,i am a new programmer in vb6 so i dont know much about vb6.So i have 3 questions. 1) Finding sum of all the numbers from 1 to 100 by loop method. 2) Finding factorial of a number. 3) organizing table of any word. eg. 9*1=9 9*2=18 and so on …

Member Avatar for AndreRet
0
99
Member Avatar for slymdjay.gunshot

Hi geeks!! im working on a project (in visual studio 2008) where i need to create a reminder which will prompt every month for showing the actual state of fees a number of customers have left to pay. the project uses access as database and will have a fixed amount …

Member Avatar for phorce
0
596
Member Avatar for manishj9869

he y frnds i hve a project on mobile store in vb 6 ..but theres a problem in it whnevr i try to add any amount in that its always shows invalid amount ..i already chcked full coding of the project..is any 1 can hlep me out in this..its an …

Member Avatar for uro123
0
111
Member Avatar for maria.susai.7

Good to all. Here I have a doubt in Visual basic 6.0. I need have excel file as backend and the visual basic is to be the frontend for my project which I am on it. In the excel sheet keeps updating while saving in vb form. Please If any …

Member Avatar for samsylvestertty
0
1K
Member Avatar for bhemlhie
Member Avatar for anmolvatsa

FOR FOLLOWING CODE <%@language=VBScript%> <%Option Explicit%> <html> <body bgcolor="aqua"> <% Dim myConn Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open = ("DRIVER={Microsoft Access"&" Driver (*.mdb)};DBQ="&"C:\Inetpub\wwwroot\tizagASP\razor.mdb;") myConn.Close() Set myConn = nothing %> </body> </html> I GOT FOLLOWING ERROR The page cannot be displayed There is a problem with the page you are trying to …

Member Avatar for ptduran
0
164
Member Avatar for mc1202bc0077

hi, may i know how to compile visual basic 6.0 file with access 2007. I can link but when i save it in an external device and try to run th exe. in other computer, it could be run, but the connection is lost, i tried to change the location …

Member Avatar for abelingaw
0
2K
Member Avatar for tinstaafl

In a recent discussion these code snippets were developed to replace Convert.ToInt32 and Convert.ToDouble. The person I was helping had a very large number of conversions to do. In our tests, using these 2 routines we were able to do over 1 million conversions in less than half the time. …

1
157
Member Avatar for kazekagerandy

i am working on a POS as a school project. im having a problem in getting the stocks, which is a record in my database. this is what i need to do, i need to populate the combobox with drug names with suggests. when i choose a certain drug, its …

Member Avatar for kazekagerandy
0
289
Member Avatar for silversurf

Hello, I am trying to build a pos and inventory system in vb 6.0 with MS-Access database. I do not have much experties in vb 6. Ok here is the question now, I want to build a report like income statement. I have two tables with name tblsales and tblexpense, …

Member Avatar for silversurf
0
371
Member Avatar for marius2010

Need help with this code, it counts only the second after "And".And if it possible to do like if cell("2.3")<point reenter else Range.. Is it possible to do aritmetics with cells or do smth with other operators? Sub hugo() Dim point As Double InputBox ("Enter The Closing Point(Between 1.1-1.6)") If …

Member Avatar for tinstaafl
0
136
Member Avatar for ponnu

L1.ListItems.Clear Dim li1 As ListItem Set li1 = LV1.ListItems.Add() While Not (rs.EOF) li1.Text = rs(0) rs.MoveNext Wend rs.Close

Member Avatar for ImZick
0
184
Member Avatar for msnyder0019

Hello, I am trying to build a Football Scoreboard and I have performed alot of editing but I am getting hung up on this error Error 1 Variable 'strScore' hides a variable in an enclosing block. C:\Users\Michael\AppData\Local\Temporary Projects\WindowsApplication1\Form1.vb 41 17 WindowsApplication1 it keeps referring to this line of code -Dim …

Member Avatar for tinstaafl
0
149
Member Avatar for bangla

Excel cell(1,2) has data with blank lines as: " vb is hard language. test data. test vb. " I want to change to without blank lines as " "vb is hard language. test data test vb" Below code is not working. Please please help. ---------- Set ExcelApp = createobject("Excel.Application") ExcelApp.Visible …

Member Avatar for bangla
0
1K
Member Avatar for timon.bijl

Hello in this code i'm like counting the interest of the start capital and doing this untill the start capital is as much worth as its double but now beside of that i'd like to count with a for next the years so like start capital 100 interest 5 year …

Member Avatar for adam_k
0
99
Member Avatar for ian.murray.33821

hi, im using microsoft visual studio to make a game the game consists of a random number generator which ive completed and is working fine, when it generates a 7 a message tells you that you have a lucky seven, you get five goes at this then a message tells …

Member Avatar for ian.murray.33821
0
233
Member Avatar for fabio.bozzo

Hi to all, I'm using the WIA Aut. Library [url]http://www.microsoft.com/downloads/details.aspx?familyid=a332a77a-01b8-4de6-91c2-b7ea32537e29&displaylang=en[/url] , trying to capture photos from 5 digital cameras (Nikon D90) USB-connected to my pc. Now, I partially achieved my goal, what I do is: - loop through the attached devices, connecting to every camera; - fotocamera.ExecuteCommand (WIA.CommandID.wiaCommandTakePicture) ; - …

Member Avatar for vince8290
0
553
Member Avatar for chieria

how can i make a robot that can move it's arm and leg.... can you guys help me with the coding please

Member Avatar for tinstaafl
0
49
Member Avatar for kokiis

im using many textboxes one button and one datagridview, i want for example, textbox1.text to be shown i first row of column one, textbox2.text to be shown on first row of column2 and so one ... when i press button1. after i press button1, textboxes to be clean and to …

Member Avatar for Wolxhound90
0
556
Member Avatar for ram_kumar8970

Hi.. How can i use the commandline arguments in Visual Basic 6? I want to pass multipule arguments of different datatypes.

Member Avatar for hkdani
0
142
Member Avatar for marius2010

So there is a problem: I get data from the internet in table form( currency),and i want to get it into the chart form,and after refreshing-it could show the same as real forex trading platforms. And sorry for typing not in right direction, VBA close to /excel..and couldn't find any …

Member Avatar for marius2010
0
115
Member Avatar for robert.chen.3975

Ask kind help: VB6 How to read the string line by line from the MS_Office Clipboard Thanks in advance,

Member Avatar for robert.chen.3975
0
242
Member Avatar for PM312

Component comdlg32.ocx or one of its dependencies not correctly registered: a file is missing or invalid I am getting this error when I tried to run my application on my friends pc . I copied this file COMDLG32.OCX’ from my laptop and tried to paste on that pc in System32 …

Member Avatar for hkdani
0
410
Member Avatar for Bile

-->>Hi,I have developed a Program that accepts the inputs from an Input Box of Interger datatype,but whenever I try to Cancel the Input Box (That means if I decided not to provide any value and Cancel it) I get an Error saying "Type Mismatch" My Variable assigned to It's declared: …

Member Avatar for jhai_salvador
0
195
Member Avatar for goodi

Hello, My problem is I have a mainForm with a combo box that acts as a filter for a subForm/datasheet, the results are from a database, so depending on what what was selected, it will dynamically update the subForm/datasheet. The issue I want is whatever the user selects (and results …

0
58
Member Avatar for chern4ever

i would like to read some data and display it in textbox. my example of data in my txt file are: "moviename1", "movieshowtime1" "moviename2", "movieshowtime2" when i display it in text box, it shows exactly like above. i want it to display without the quotes. how i can achive tat? …

Member Avatar for Jx_Man
0
3K
Member Avatar for HibaPro

i uesed vb6 with crystal report 10 , when i try to open report.rpt file in crystal report this message appear to me : Invalid report schema , cant open the document,, anyhelp plz??

Member Avatar for HibaPro
0
78
Member Avatar for charuwaka

See i want to print my bill separated by lines and should appear like each column spearated by a lineand each row separated by a line. but these should no appear in main form only in print preview it should appear is it possible how can i do it clearly …

Member Avatar for john.knapp
0
123
Member Avatar for shhh

error connecting to databaseAccess denied for use 'root'@'localhost(using password:YES) using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; using MySql.Data.MySqlClient; using System.Windows.Forms; using DPUruNet; using System.Drawing.Imaging; using System.Drawing; namespace UareUBiometrics { class HelperFunctions { private static Fmd[] fmds; private static Fmd[] allDBFmds; public static Fmd[] GetAllFmds { get { …

Member Avatar for kyle.santelices.31
0
301
Member Avatar for kikiey

can anybody help me how to make a LAN connection for messenger such as yahoo in a big connection like in hostel? i use microsoft visual basic 6 and microsoft access as a database. pls help me :(

Member Avatar for AndreRet
0
341
Member Avatar for jean1234

Hi, I am new to windows forms. I used the 2 lines of code below to launch a c++ code from a windows forms GUI and it worked: Dim lngReturn As Long lngReturn = Shell("c:\MyProgams\cfile.exe", vbNormalFocus) I hope someone can help with the issue below: My interface includes some text …

Member Avatar for AndreRet
0
323
Member Avatar for sachins1986

how to get null field value from access in vb6 in my 2 record field the value is empty but i'm not able to get that empty field in vb6 ... .... set rs = new adodb.recordset rs.open ("select * from table1 where id = '2'") text1.text = rs!name please …

Member Avatar for AndreRet
0
2K
Member Avatar for ram_kumar8970

hi.... can you tell me how can i make the antivirus in visual basic 6? if you have somw source code it will be more benificial for me. thnaks in advance....

Member Avatar for AndreRet
0
248
Member Avatar for Bile

-->>Hi,I am getting tired of recreating the menus in every form I design my be due to lack of information... -->>Thus I was wondering if there is a way that I write codes in may be a module so that I may be using it... -->>by just calling it in …

Member Avatar for AndreRet
0
301
Member Avatar for Transworld

Well I have to make a microwave program in Visual Basic for school. I can't seem to find anything in the index that will help me with the timer/countdown. I found TimeOfDay() and was going to use that for the clock but I can't figure out how I would make …

Member Avatar for ranyone
-3
12K
Member Avatar for ashish.shende.714

how can i do visual basic coding for optimisation problem for steepest deecent, powel method, fiscer reeves, penalty function, geometric programming, . can u give us the whole code for any single problem on each method

Member Avatar for AndreRet
0
49
Member Avatar for meLiel

Private Sub cmdAdd_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection Dim rsAdd As ADODB.Recordset Set rsAdd = New ADODB.Recordset Dim Query As String con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Asus\Desktop\VBTHESIS_liel2\ListofMembers.mdb;Persist Security Info=False" con.CursorLocation = adUseClient rsAdd.Open "SELECT * FROM census WHERE ID ='" & strId & "'", con, adOpenStatic, adLockOptimistic 'If textboxes …

Member Avatar for hyesin
0
179
Member Avatar for bprosic

Hi, I have a simple program with datagrid view bounded to MsAccess DB in Visual Basic 2010. When user changes the width of datagridview columns and restarts the program, width of the columns have been reseted to original state. Now, what code can I use and how can I save …

Member Avatar for bprosic
0
572
Member Avatar for choeychoco

i am trying to execute an exe file on a remote computer using vb 6.0 and i'm using psexec here is my code: shell("psexec //computer1 d:\test.exe") but it is not working by. by the way i am using a cloned system. can anybody help me.. thank you so much.

Member Avatar for AndreRet
0
344
Member Avatar for jaasaria

hi guyzz i wanted to remove item in the lisview using the for each i want to delete multiple item with similar field in the listview. any help.. for this problem.. it could be possible ? i have here code but it delete only selected item in the listview. (ListView1.ListItems.Remove …

Member Avatar for bluemarine90
0
3K
Member Avatar for swapna7999

hi i need to connect a vb application to a mysql database which is in a remote server plz suggest solutions thank u very much

Member Avatar for choeychoco
0
817
Member Avatar for Stuugie

Hi all, With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure …

Member Avatar for Stuugie
0
203
Member Avatar for Bile

-->>Hi to all, now I was about to document the help file of my applicatiion and I thought "How or what kind of controls will I use to have something like waht Microsoft has in a Word application where I can just write the documentation in in such a way …

Member Avatar for Bile
0
183
Member Avatar for zalen17

Sir good morning. can you give me some codes of how to make a Online Grading Enquiry System using visual basic. i need your help sir beacause this is uour project. hope can you help me.. thnx in advance more power god bless

Member Avatar for jhai_salvador
0
66
Member Avatar for krunal1986

hi, i am getting Run time error '13': Type mismatch error. below is my code: Dim ndMain As Node Set ndMain = TreeMain.Nodes.Add(, , "Root", "Main Menu", "myappname") thanks, krunal

Member Avatar for Bile
0
343
Member Avatar for forjustincase

Students Details and Mark Entry Form Input : Number of students, Student Name , Student Id, 5 subject marks entered through inputbox by using dynamic array Output: List of all input Students Grade Form Input: - Output : List of students Name, ID, 5 subjects, Average, Grade Students Grade Analysis …

Member Avatar for forjustincase
0
249

The End.