11,868 Topics
![]() | |
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 … | |
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 & "*'" | |
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. | |
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 | |
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 … | |
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 = … | |
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. | |
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 … | |
Need a project on mobile apps in vb 6.0 as desktop application | |
hi i'm new to vb. how can i write to iterate while loop till the end of the string.. can any one help please... | |
I want save 1one image and tow text with one image example :card person | |
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) | |
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 … | |
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 … | |
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 … | |
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 … | |
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. | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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. | |
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 … | |
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 | |
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 … | |
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 … | |
Is there code in visual basic 2008 where i can set my program to expire every 30 days ? Thank You | |
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. | |
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 ?? |
The End.