Posts by debasisdas

Knowledge is not what you can remember, but what you cannot forget.

Don't compare vb 6.0 with its successors .

capture the username and password from input and compare with database. Try to use COUNT through SQL. If that returns 1 then login is successful.

Treat objections as request for further information.

That never happens in database. That might be because of improper coding.

Try this sample connection string.

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mydb.mdb;" & _ 
           "Jet OLEDB:Database Password=MyDbPassword", _
           "myUsername", "myPassword"

Obstacles are the things we see when we take our eyes off our goals.

Yout post is bit confusing, please post your question clearly about your requirment.

There is no problem with access 97 if mutilple users looking, printing data. That is no way going to create any problem for you. There can be any number of users looking at the same record at the same time.

so far as other databses are concerned ,you can connect to Oracle ,MySql or SQL Server databases also with VB 6.0 by making minor changes to the code.

Try to incluse and use Microsift Scripting Runtime from project ---> References.
Make use of FileSystemObject .

Then kindly post the question in the proper forum only.

What do you mean by form contain ? If want to save the data in the form use database connection for the purpose.

Why don't you use database for the purpose. It will be very simple with that option.

I don't think that is anyway related to VB 6.0.

That is quiet simple but too vast to expalin over here. Please follow a good book for the same. You also find a lot of related topic / code here by using the search utility in this forum itself.

Fortune favors the brave.

Empty pockets never held anyone back. Only empty heads and empty hearts can do that.

The essence of knowledge is, having it, to apply it; not having it, to confess your ignorance.

Try to register the ocx file using REGSVR32 key.

any one can help me please.

blinds

3461

-412

4209

That is because both the variables P_ID and P_NAME are IN type variables. So you cant asign value to a In type variable in a select into statment.

Please pass few more details . It is very difficult to suggest anything based on the very little info passed by you.

sir
how can i display contents of a certain field in a certain table on a combo box

please show me

Please refer to code in post #4 .

Try this sample connection string for Access database.

Con.ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Debasis\Desktop\cypic.mdb;Persist Security Info=False"

What exactly you are trying to do ?
Are you trying to play the sound files ?

What is the type of connection that you are using.

What you do off the job is determining factor In how far you will go on the job.

the variable will store the first reord from the NmPeg field of your recordset . But for that you need to use movefirst of the recordset.

There are so many simply ways to be famous. Which one would you prefer ?

There is no problem with this piece of code. It is better to close the recordset and connection at the end.

If you are not using the form itself to show the picture then trry to use a image control stretch the image and resize the control to the size of the form.

Your question is too much theoritical to explain over here. It is beyond the scope of this discussion to expalin all that here. Please go through some good book for the same. You can easily find all that by little web searching. I'd suggest you have a look around the web for tutorials. You see, we're not really much of a tutorial or "getting started" site. We're more geared toward helping developers who run into bugs in their code.

Don't expect tothers to write code for you . You need to post the code that you have tried so far to get help from experts of the forum.

You simply need to add Microsoft Scripting Runtime to your project from Project ---> references.

Rest all is fine . Hope that solves your problem.

That which does not kill me, makes me stronger.

What bout trying like this.

Connection1.ConnectionString = "......connection string here.........."
sql = ".........sql query here.........."
Connection1.BeginTrans
Connection1.Execute sql
Connection1.CommitTrans

The people who remained victorious were less like conquerors than conquered.

You are most welcome.
I am glad to know i could help you.

"If I have ever made any valuable discoveries, it has been owing more to patient attention than to any other talent."
–– Isaac Newton

after creating the connection object establish the connection to the database. Right click on connection and add a command object .Right click on the command object and select sqlstatment in the general tab in properties . add the sql statment that you want.

Hope that solves your problem.

Your question is toomuch throritical to explain here. There are lot of example code here. You only need to spend some time to search for them.

I think one text box for message entry and another Listbox would be better to display the message back to back.
But why you need connect to database for that.

Kindly pass few more details .
What is the database that you are using and how you are conecting to database.

The few who do are the envy of the many who only watch.

Are you expecting the complete code with proper documentation.

Can you post the code that you are trying to execute.