12,425 Topics
 | |
 | i have a system that i want to send email if i have a near expiry item.. |
| | how to make auto numbering for an ID? but id has been given an initial value, examples of initial value: 100027 how to make the ID is automatically incremented by 1? thanks, |
 | Private Sub Load_Faculty() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim dr As OleDbDataReader Dim arrImage() As Byte Dim myMS As New IO.MemoryStream Dim sSQL As String = String.Empty Try sSQL = "SELECT b.FacultyFirstName, b.Image, b.Course, a.Course" sSQL = sSQL & " FROM studentsrecords as a left … |
| | Hi guys, I've been working on Vb.net for about 2 and a half years. It's easy and always has been. I did almost everything. I need some new ideas to work on. I did all the basic stuff such as: picture viewer browser calculator 'explorer' - to view files/folders reads/writes …  |
 | 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 & "*'"  |
 | 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  |
| | I use Visual Basic 2008 and the SQL server Compact Edition I got an error in fetching the numbers of the two tables i create please help...  |
| | 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 ?? |
| | hi, can vb6 detect if the unit is connected to a router or have a connection to the net or LAN ? example: if the user is disconnected to the LAN, a msgbox will appear that the unit is not connected, if connected nothing to worry about :) same as … |
 | I have several worksheets that list the following data on each sheet but different project number: A B C D E F G Date Hours Project Description Task/Account Comments Employee Hours Total Aug-19 4.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 Mexico iDirect; James 34.00 Aug-20 4.00 P09998 BID&PROPOSAL PRE-PREPOS P09998 Staff Meeting, … |
| | Hello Everyone, I'm extremely new to programming in Visual Basic and I have a programming exercise which I need help with. I have a textbox and a label on a form. The objective of the program is for the label to update with any text typed into the textbox as … |
 | urgent please i have a form with 3 sub procedures,i need to call on each of the sub seperately when i click a button in another form  |
| | I created a Save button and I also have made the code for the Save button But why the error message like this: Run-time error '-2147217913(80040e07) convension failed when converting the varchar value '28/08/2013 10:11:01 to data type bit mohon bantuannya, thanks, V |
| | I have a spreadsheet that has many columns. I want to search the titles of the columns and copy all the content in the column that satifies the search criterion and paste it in different worksheet. Copying these columns manually is very time consuming and I wanted to create Macro … |
| | I've noticed that comments in VB code snippets are ended in the middle of a line if an apostrophe is present(i.e. using a contraction), then continue from the next one over several lines until it reaches another. I'm wondering if that can't be changed to keep it as a comment … |
| | the basic idea is that i have a config file where i need to take entries in different formats(the key is always a string and the value could be any type: int, float, string etc) from and the file has the following style: firstentry 1.5 secondentry 35 thirdentry somestring and … |
 | I made a small web browser using the webbrowser control in vb6 but the Navigate2 method doesn't change the web page displayed. The URLAddress changes but the content on the web page doesn't .Can anybody help me plzzzz ????? |
 | hi i'm working on a project that requires a search code in visual basic to find data from a different table in ms acess..any help?  |
 | I am trying to write a code that directs the user to a specific sheet in the workbook depending on a yes or no answer. So basically there is information that will need to be completed and the information is specific to whether it is a YES or NO. So … |
| | please how do i code a search button in visual basic. my database is microsoft access and i am using a binding source to connect to the database. |
| | |
| | Hi all In my window form project I want to display only 2 columns among 3 columns Of my BRAND datatable in LISTVIEW column 1 BRANID display in listview 2 BRANDNAME display in listview 3 ID don't want to display in listview all brand & it's id display in listview …  |
| | Hi there, I like programing very much. Fortunately or unfortunately my sujects in collage was arts, because i hate maths. Visual basic is my favourite language. I have learned it partially. But it didn't support my native language. I need some menu button text in my native language, but it … |
 | Sub DUE() Dim strBuffer As String Dim strContents() As String Dim I As Long ReDim strContents(0) Erase strContents() Close #1 Open "C:\TEST\28-06-2013.TXT" For Input As #1 strBuffer = Input(LOF(1), 1) Close #1 strContents = Split(strBuffer, vbCrLf) For I = LBound(strContents) To UBound(strContents) 'Debug.Print strContents(I) Next I End Sub Problem out …  |
The End.