Forum: Visual Basic 4 / 5 / 6  Nov 10th, 2008 |
| Replies: 1 Views: 939 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 24th, 2008 |
| Replies: 0 Views: 375 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,... |
| Forum: Visual Basic 4 / 5 / 6 Oct 22nd, 2008 |
| Replies: 6 Views: 629 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.
... |
| Forum: Visual Basic 4 / 5 / 6 Oct 22nd, 2008 |
| Replies: 4 Views: 592 Hi Debasi,
It does not give error, it simply not functioning, that is why I am very confusing. It tried in so many ways for about three night. If you can give me the correction / my fault, I shall... |
| Forum: Visual Basic 4 / 5 / 6 Oct 19th, 2008 |
| Replies: 5 Views: 3,426 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 =... |
| Forum: Visual Basic 4 / 5 / 6 Oct 19th, 2008 |
| Replies: 4 Views: 592 Oh Debasi,
I always expect you to answer my question, but your answer too vaque, I just find the answer tonight from some site, and I am trying for this, but line is not funtioning till now, do... |
| Forum: Visual Basic 4 / 5 / 6 Oct 19th, 2008 |
| Replies: 14 Views: 1,618 Hi,
I used select text for the date filed so that the date can always be displayed with the format you like / exspected and that is not effected by date format selected in the control pannel. For... |
| Forum: Visual Basic 4 / 5 / 6 Oct 18th, 2008 |
| Replies: 4 Views: 592 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.
... |
| Forum: Visual Basic 4 / 5 / 6 Oct 18th, 2008 |
| Replies: 14 Views: 1,618 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 18th, 2008 |
| Replies: 1 Views: 1,235 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 13th, 2008 |
| Replies: 1 Views: 755 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. |
| Forum: Visual Basic 4 / 5 / 6 Oct 13th, 2008 |
| Replies: 3 Views: 674 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,... |
| Forum: Visual Basic 4 / 5 / 6 Oct 13th, 2008 |
| Replies: 11 Views: 1,087 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 11th, 2008 |
| Replies: 1 Views: 680 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 11th, 2008 |
| Replies: 2 Views: 478 Thanks to Sen, for you explain my doub about ASP and VB6 environment. As I am new to ASP or web type development, it will be my pleasure if any one can tell me more the basic direction on using VB6... |
| Forum: Visual Basic 4 / 5 / 6 Oct 10th, 2008 |
| Replies: 2 Views: 478 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 10th, 2008 |
| Replies: 0 Views: 747 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... |
| Forum: ASP Oct 10th, 2008 |
| Replies: 4 Views: 1,067 Thank to all who reply my problem, but unfortunately the connection which you suggested is not working using this (For MSAccess with Password, using DSNLess Connection):
Set conn =... |
| Forum: ASP Oct 8th, 2008 |
| Replies: 4 Views: 1,067 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 3rd, 2008 |
| Replies: 1 Views: 493 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.... |
| Forum: Visual Basic 4 / 5 / 6 Sep 11th, 2008 |
| Replies: 2 Views: 741 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=... |
| Forum: Visual Basic 4 / 5 / 6 Sep 11th, 2008 |
| Replies: 2 Views: 1,077 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 21st, 2008 |
| Replies: 6 Views: 5,503 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 21st, 2008 |
| Replies: 0 Views: 681 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 16th, 2008 |
| Replies: 11 Views: 2,278 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 16th, 2008 |
| Replies: 2 Views: 2,902 Hi selvaganapathy,
Thank you very much for your precious help. |
| Forum: Visual Basic 4 / 5 / 6 Aug 16th, 2008 |
| Replies: 6 Views: 5,094 Please post your sample code and Table , from that I will try the corrected code. |
| Forum: Visual Basic 4 / 5 / 6 Aug 14th, 2008 |
| Replies: 6 Views: 5,094 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 14th, 2008 |
| Replies: 2 Views: 2,902 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 8th, 2008 |
| Replies: 2 Views: 928 Mr debasisdas, you are correct. Thank you very much. I never though of MSHFlexGrid that is why I simply trying with MSFlexGrid only.
Is there any limit in the number of rows for MSHFlexgrid? If... |
| Forum: Visual Basic 4 / 5 / 6 Aug 8th, 2008 |
| Replies: 3 Views: 804 Hi, Mr. debasisdas,
thank you very much for your response. I wamt to tell you that Ican round the number only to the nearest number by writing like this:
C=AXB
D=round(Val(C)+0.001)
But I do... |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 4 Views: 882 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
... |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 2 Views: 473 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 4 Views: 1,869 Hi,
If you are makeing connection using DSN/ODBC, you will have to set it manually for every install programme.
Make your connection using DAO so that your problem will be solved. For writing... |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 4 Views: 1,869 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 2 Views: 897 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,... |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 3 Views: 728 As I am having thousand of records already entered in the table but I need to tranfer these record to other database and need to change record ID before tranfering to the new database. |
| Forum: Visual Basic 4 / 5 / 6 Aug 7th, 2008 |
| Replies: 3 Views: 804 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... |
| Forum: Visual Basic 4 / 5 / 6 Aug 6th, 2008 |
| Replies: 3 Views: 728 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. |
| Forum: Visual Basic 4 / 5 / 6 Aug 6th, 2008 |
| Replies: 2 Views: 928 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. |
