Please post your code that you are working on. Our experts will advice you to improve the same. Don't expect the complete code.

the first one uses client side cursor.

There are different ways to connect to database.

you can either you code or components.

try using ADO or DAO.

What is the database that you are using.

you need to copy the activex component also to the system and register that using REGSVR32 command.

What happens when you call the function / event in Form_Resize event ?

Is that not getting executed ?

try the following code, make changes as desired


Dim CN As New ADODB.Connection
Dim RS As ADODB.Recordset
Dim DataFile As Integer, Fl As Long, Chunks As Integer
Dim Fragment As Integer,...

that has nothing to do with database connection . check your other code.

you should get correct output with your code. there is nothing wrong with it.

You can't disable the windows key.

what is the source of data in the control ? is it getting populated from database ?

* is not required in delete statement. use this

strSQL = "DELETE FROM Product WHERE Expiry_Date = '" & Text1.Text & "'"

but where is the loop in your code ?

i don't see and disadvantages.

You need to pass more information.

What do you mean by when an exe is ended ?

There are many applications that can be finished in your time frame. Now it depends on you what you decide to develop.

If you are looking for the connection string find it here (http://www.connectionstrings.com/).

from vb 6.0 you need to use ADO.

try this sample function for the job.



Code:
Public Function NumToWord(numstr As Variant) As String

Dim newstr As String

numstr = CDec(numstr)

You need to work with CDO.

i didn't understand your question .

What is a forum window ?
What do you mean by update without saving ?

comment Unload Me in your code and i hope the rest wills tart working. use Me.Hide instead of unload Me.

You need to format the date to proper format before pasing the same to database.

what is that CON in your code ?

What type of object is that ?

Are you using ADO to connect to the database ?

i don't think that is VB 6.0 code.

if vb 6.0 then try this
Dim Sql As String = "insert into Customer_tbl (Custsql )values '" & txtFirstName.Text & "','" & txtLastName.Text & "')"
con.begintrans ...

then you need to push the power button on your computer.

you need to convert the date and time to proper format before passing the same to database for processing through SQL statement.

you need to use the function REPLACE.

what exactly you mean by over internet ?

are you in the same network as the server ?

try the simple code

con.begintrans 'con-----adodb connection object.
con.execute "your DML statement here"
con.committrans

you must be connected to the database.

if you are using oracle as database then can use external table for the best solution,but you need to extract the zip first.

try the following


dim con as new adodb.connection

con.open "your connection string here"


add my previous code after this line

better use ADODB library for the purpose. try the sample code below


con.begintrans 'con-----adodb connection object
con.execute "your sql insert statment here"
con.committrans

try the following code with ADO


con.begintrans 'con--ADODB connection object
con.execute "put your sql statement here "
con.commitrans

1. select the month.
2. findout all the dates.
3. findout the days by passing the dates ---use WEEKDAYNAME function for the purpose.

since you will need to display a lot of records why not use a grid instead of number of textboes.

only practise can make you perfect as there is no shortcut to success.

how are you calling the report ?

you need to frame the sql dynamically at runtime and pass the same to the report.