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...

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,...

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.
...

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...

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 =...

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...

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...

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.
...

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...

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...

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.

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,...

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...

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...

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...

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...

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...

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....

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=...

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...

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...

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...

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...

Hi selvaganapathy,

Thank you very much for your precious help.

Please post your sample code and Table , from that I will try the corrected code.

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...

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...

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...

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...

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
...

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...

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...

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...

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,...

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.

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...

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.

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.

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...

[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...