- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
31 Posted Topics
 | Write this code in Module Public con As New ADODB.Connection Dim ttel_idxRs As New ADODB.Recordset Dim tsql As String The follwoing connection code can be written both in the module or Form Set con = New ADODB.Connection con.Provider = "Microsoft.Jet.OLEDB.4.0; Data Source = " & App.Path & "Telephone_IndexTelephone_Index.mdb" con.Open The … |
 | hi, Firstly, make a connection for your database 'db.mdb' After calling the connection, you have to write VB code for your need: Write the SQL command statement for searching in the btnSearch Click event as beow: if fldSearch.Text is the textbox in which you write the string/ any word to …  |
| | Hi, You cannot simply Add or Subtract time, first you need to get the time value and then subtract, you can get differnces betwen two time or date too as below TimetoAdd = TimeValue(Text1.Text) + TimeValue(Text2.Text) Text3.Text = Format(TimetoAdd, "hh:mm:ss AM/PM") I Hope you will understand now.  |
| | There are many ways to validate whether it is a text box or a button or submit button, the way you write the code and the place you put your code can be vary, depending upon your decision, one simple way is to write the validation code and make that … |
| | Hi, If you are interest in using MySQL as your back end database, here is one way to connect: By using ODBC: 'Declare ADODB variable Public ConnectData As New ADODB.Connection Set ConnectData = New ADODB.Connection ConnectData.Open "DSN=MySQL_ODBC" If you want to use MySQL ODBC 3.51 Driver , You can write …  |
| | Re: day problem Take the value of the date in Text1 and then add any number you want (Say7), format the result with any date format you like to display like- "dd-mmm-yyyy" and the display the result in Textbox2. You can get value of Year, Month and Day form the formal date format … |
| | Hi, if Your date column name is mdate, you have to slect the data as RecordSourse = "Select * from AdHocData Order By mdate" This would surely select the data as the order of date. If not correct for your computer, ssend your data to the forum and let me … |
| | Hi, all programmers of this Forum, I am using MS Axcel 2002 and I am trying to format Excel Sheet from VB so as to make a border within the selected cell. My CB code is as under and when I run this, it select the specified rangge, but no … |
| | I am doing one project in which Whenever I export the result, the list of record should be extracted as Excel file and the list of record should be listed within Excel Table with formated Line. So, I want to format Excel from VB so as to make line / … |
| | Re: Acces DataBase You can connect your Access Table with your VB form using different method. By using ADO, you can connect like this: You have to select "Microsoft ActiveX data Object 2.0 or higher" from the preference of your VB. Then, write this code in the module section: Public ConnectData As New …  |
| | You can Search particular word from any of the Column by using Searc string like this: Sql="Select * FROM YourDatabaseName WHERE ColumntoSearch like '" & Trim(txtSearchTextBox.Text) & "%' ORDER BY toSearchColumnName" So, the above code will Search whatever you write within the textbox 'txtSearchTextBox.Text'. I hope this will give you … |
| | I want to make line in Excel with a click of my VB Form button, but I do not know the correct code, can any one help me. |
| | I am new to ASP, and I used to write the connection for my Access Database using DNSLESS Connection like this: <HTML> <BODY> <% 'Actionvar=Request.QueryString("actionvar") '** Set Up a DSNLESS CONNECTION<BR> Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " 'DSNtemp=dsntemp & "DBQ=" & server.mappath("Record.mdb") DSNtemp=dsntemp & "DBQ=" & server.mappath("MyWeb/MyRecord/Record.mdb") … |
| | If Shift And vbCtrlMask And KeyCode = vbKeyE Then If cmdEdit.Enabled = True Then I think you want to asign a shortcut key , if so, IN VB, you can write this code in the Form Keydown event, like this: If Shift And vbCtrlMask And KeyCode = vbKeyF1 Then adodc1.MoveFirst … |
| | Hi, I am trying to Write web type application and connect my database (Access) with DNSLess Connection like this Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " DSNtemp=dsntemp & "DBQ=" & server.mappath("Record.mdb") conn.Open DSNtemp This is very much like to Connection to Database from VB6, but, I do not … |
| | In my VB6 Book, in the last chapter programming ASP for web design is written and, it seem that is to be done through VB6, but I dont under stand and I usually write ASP code using FrontPage? If VB is helpful (Even though understanding of VB coding is helpful) … |
| | Hi Friend, I want to know how to Select some range of Excel Say A1 to C5 and then make a line/Table using VB. Can any one help me by giving the VB Code. Also, can any one suggest some book to read relating to VB6 and Excel so as … |
| | I want to connect My Access Data in my Web Page. Is this possible? If yes, can you tell the way to connect. IS THERE ANY WAY TO USE ADO CONTRAOL TO CONNECT MY ACCESS DATABASE IN A WEB APPLICATION. CAN YOU PLEASE GIVE ME THE BASIC GUIDE. |
| | You can do this in a number of way, one simple way is that, 1. if you want to insert only student whose info is in students table but not in Section table, then select uisng this SQL SQL= "SELECT * FROM Student WHERE rno NOT IN(SELECT DISTINCT Rollno FROM … |
| | datepicker1.value = date.now().... is not enough if you expect to display date as you wish. I need to use format command so as to display date as you wish. The syntax to display date as 22-May-2008 is: Format(Now,"dd-mmm-yyyy") Other problem can happened if your system date is not correct, if … |
| | Whenenver I try to Save the Excel Workbook after editing the content by using this Code "xlwbook.Save", It always ask whether to replace the existing File or not. Is there any way to avoid this message? What shall I do to close the workbook silently (not seeing the Message). I … |
| | If you can help by giving guide to write this using VB, I shall be very glad: I want to get the quotient and a remainder when one number is divided by another one number, Can you please give/show me the Coding to this problem? |
| | Use to save the last number auto number in a separate table so that whenever you add another record, get the last number and then add one number for a new auto number and then update the last number in the Autonumber Table again. In this way, you can simply … |
| | Hi, Make your connection using DAO so that your problem will be solved. For writing connection, do like this: 'Declare the connection Public ConnectData As New DODB.Connection 'For opening the Database Set ConnectData = New ADODB.Connection ConnectData.Provider = "Microsoft.Jet.OLEDB.4.0; Data Source =" & App.Path & "\System\Record\Data\StatisticalRecord.txt; Jet OLEDB:Database Password=vlednst;" 'ConnectData.Provider … |
| | If any body help me, I shall be very greatful: How shall we write Code using VB so that the value of the product of two variable should be rounded to the nearest Integer number which is divisible by 5. Is there any way to check whether the given number …  |
| | Is there any way to display more than ten thousand list of Record using FlexGrid- all at once. If not, what will be the solution of this problem. |
| | Hi, I want to write VB code so that the any First letter of any Word entered in the textbox will be automatically converted to Capital. Whether there is one or more than one word in the text box, any first letter of the word should be converted to Capital …  |
| | Is there any way to display more than ten thousand list of Record using FlexGrid- all at once. If not, what will be the solution of this problem. |
| | Instead of writing like this cn1.Text = rc1.Fields(6) Write this line as below which will surely avoid null problem: If IsNull(rc1.Fields(6)) Then cn1.Text = "" Else cn1.Text=rc1.Fields(6) End If |
| | Re: vb There are a number of VB tutorial Book today, but see what which version of VB you are going to learn. Today, you can learn VB6 to VB.Net (VB2005), If you want to read from the printed book, go to book seller, you will see a number of VB book. |
| | Hi, You are facing the same problem which I had face before. This is very simple, let my tell you: First, make a database using SQL and let the database name be 'MyRecord' and your ID for your Database be 'Master' and make Password as '123'. So, to be able … |
The End.