11,868 Topics

Member Avatar for
Member Avatar for teppuus

Hello, I am trying to write a macro for Excel 2003 that will allow me to search for two words in Sheet1, copy all the data below those words, and then paste that data in Sheet2. That part I can get to work. My problem is that I have multiple …

Member Avatar for PerplexedB
0
413
Member Avatar for Carlo Miguel

whats wrong with this.. its not working! Set rs = New ADODB.Recordset rs.Open "select * from Personal inner join Company on Personal.CompanyID = Company.ID", conn, adOpenKeyset, adLockOptimistic rs.Filter = "FirstName LIKE '*" & searchtxt.Text & "*'"

Member Avatar for kennethjohn.esada
0
65
Member Avatar for iamsponge

for those people who are good in making a visual studio C++ program.. I need some help for my project about creating a program that will convert dollar value into peso and vice versa.

Member Avatar for rubberman
0
263
Member Avatar for SaRa Ahmad

hi again , how i can read a path of file that location on a server in vb6 ??? for example my server is 192.168.1.222 and folder is software

Member Avatar for SaRa Ahmad
0
128
Member Avatar for SaRa Ahmad

hi everybody , i need to solve this case as soon as possible : i have the master table that include the following data : (SerialNo - integer (P.K), civil-bit, mechanical-bit, etc) and form that include the serial no text field that automatic increase by one each time the user …

Member Avatar for SaRa Ahmad
0
156
Member Avatar for firoz.raj

can anybody tell me why i got syntax error(missing operator) in query expression'ID='; here is the code what i have written.any help would be greatly appreciated. [code] Private Sub Command2_Click() If CheckInput = True Then Dim success As Boolean Set con = New ADODB.Connection success = OpenConnection(con) If success = …

Member Avatar for babu.shahulhameed
0
208
Member Avatar for valter.schmaltz

Can someone help me create the code that moves the second table when clicked the next. because tables are connected but I can not make the code to keep the two aligned tables. What I want and clicking to move the main table to select other data that automatically.

Member Avatar for rishif2
0
67
Member Avatar for jemartalaban_1

hi my program is need to print different forms but each forms must use different printer and all printers was connected to my pc via usb port, my problem is if i want to print a form A i will click the command box then it will use the EPSON …

Member Avatar for rishif2
0
6K
Member Avatar for rohit.jajoo.3
Member Avatar for baabjitvk
Member Avatar for rishif2
0
201
Member Avatar for zain_1
Member Avatar for rishif2
0
122
Member Avatar for abdu_1

Help my program gives me error:argument not optional Private Sub Command1_Click() Dim First_Number As Integer Dim Second_Number As Integer Dim Answer As Integer first = Val(txtFirst_Number.Text) second = Val(txtSecond_Number.Text) Answer = First_Number + Second_Number MsgBox ("The total is " & Answer)

Member Avatar for rishif2
0
76
Member Avatar for eshajoshi

Hi can andbody help me? Below is my code. I get this message: Run-time error '-2147217900(80040e14)': Table 'PreampAutoDetect' already exists. The error points to the line below with the stars around it. stringSQL4 = ... Please help me ... Private Sub Command4_Click() ' Copy Tables from List1 to Database(s) in …

Member Avatar for ss125
0
2K
Member Avatar for anJelo.towT

can someone help me ? whenever i start this program its always says that " compile error type-declaration characters does not match declared data type. then the rs.Fields! will go hightlight. can someone help me ? Dim rs As Recordset Private Sub Form_Load() Dim list As ListItem ListView1.ListItems.Clear Set rs …

Member Avatar for tinstaafl
0
139
Member Avatar for eshajoshi

Hi, I am having some with my program. I want to copy table content and data from one database to identical tables in different databases. (overriding the old tables) So far, in the different databases, I am able to delete the original table, create a new table with the same …

Member Avatar for eshajoshi
0
143
Member Avatar for venomv1

I have encountered a block in my programming escapade. The project that I am working on is from a visual basic 6.0 programming book and is a program that opens a data file filled with roman numerals, read to end of file, and outputs the numerals digit form, performs a …

Member Avatar for Klahr_R
0
191
Member Avatar for sshinde

Hi can anybody please let me know how to print barcode in visual basic 6.0 with code 93 font,i am using printer object to print on to the printer.also code through which i can minimize the width of the barcode so that it can print completly on the label.

Member Avatar for asaa
0
3K
Member Avatar for anto_nee

hi frnds here i found many solutions for vb thanx for all your help and now i came with a new problem i have a file (doc,xls,txt, jpg or whtever it is) here i have to open that file from vb i have the filename i cant imagine i have …

Member Avatar for Md Saiful
0
223
Member Avatar for jason.craft.5439

So I have this assignment for school and I've got the program working, but some minor issues (maybe major issues with cleanilness of code, but working on it). I'm having to make a Guess My Number program and it seems to work, but when I start a new game it …

Member Avatar for kRod
0
459
Member Avatar for gudboi.ian

Can anyone help me making this Gasoline Meter Simulator? Here's the problem, Using .NET construct an application that will simulate Gasoline Meter. The users allows assigning the amount of gasoline per liter. The user can select whether by liters or by amount. If the user select liter, then he will …

Member Avatar for gudboi.ian
-1
412
Member Avatar for ADPYvette

I am building an application that needs to access a database. I installed SQLite.net, made references to SQLite for Windows Runtime and Microsoft Visual C++ Runtime Packages. Now, how do I connect to the database? In other words, what are the Visual Basic codes? Note that I do not see …

Member Avatar for ADPYvette
0
208
Member Avatar for SaRa Ahmad

this is my code , it should save a pdf file from sql server to a folder but nothing happened can anyone help please ?? Set rs = New ADODB.Recordset rs.Open "select * from PDFStore where filename='" & co_name.Text & "'", db, adOpenKeyset, adLockBatchOptimistic If Not rs.EOF Then Set pdffile …

Member Avatar for SaRa Ahmad
0
268
Member Avatar for Michael Leung

When I copy the VB program to a directory, how can the program find the directory. So, it can read some data on this directory.

Member Avatar for Klahr_R
0
115
Member Avatar for eshajoshi

Hi, I have two databases. In my code, I open the first database and list all of its databases. With my code, I open the second database. Essentially I want to override the tables in database2 with the tables in database1 so I am trying to delete the tables in …

Member Avatar for eshajoshi
0
351
Member Avatar for suad.ibrahimhussain

The following VB code to reference many excel sheets using index variable in a loop; but I got error Sum = 0 For i = 1 To 10 Step 1 Sum = Sum + Sheets(i).Cells(6, 9).Value Next i

Member Avatar for Klahr_R
0
62
Member Avatar for jhonm

i am connecting online to MYSQL server(dsn less connection) through vb6 and displaying result on form.. as you know to connect we need to input "database name" , "password" , "username" , "server_name" so anyone can decompile and view the login detail (i have tried...it works). I cant accept it …

Member Avatar for Klahr_R
0
114
Member Avatar for jhonm

I am using windows media player in my vb6 form using wmp.url = "link" But it doesnt play online url eg."www.music.com/song.mp3" i found a solution : open local windows media player software --> type same url ---> MESSAGE APPEAR ASKING TO CONNECT OR "WORK OFFLINE" --> click connect and it …

Member Avatar for jhonm
0
559
Member Avatar for JD69
Member Avatar for anand.mahato1
0
4K
Member Avatar for babankamal

Dear friends, I need to create vb6 program that can search entire system(computer) documents for a string passed and report back number of occurences, list and sources(file name and address) on listbox. Thanks friends.

Member Avatar for Reverend Jim
0
55
Member Avatar for SaRa Ahmad

hi everybody , i would like to know how to view data in my crystal report depend on InputMessage that ask from the user how to sort the data to view on the report , as date or status , any one can help how to do that ??

0
67

The End.