debasisdas

How do you expect us to help you without having any detail idea of what is happening at your side and what exactly is your requirment.

Can you post a sample code to create a Screen saver in this thread please.

Do u have any difault printer on the pc. You better consult the person who made the changes.

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.

How do you expect the application to open the database without knowing its location. It never happens that application will run without knowing the location of an access database . You have the option of asking the user to specify the database location initially at the start of the application.

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

I don't think this question has anything to do with database designing.

Check wheather thers is any lock on the table . Use indexes to increa the performance.

Why don't you go for database connection instead of storing all that in Excel files. By using databse you will have better data security and reporting options.

Dead mummy returns.

try using rs.movelast and then use rs.RecordCount

What do you mean by created database with ms .You are using MS Access or MS Sql Server ?

You can specify the size of data thast you need to retrive in the Sql squery.

That might be cecause of the resource is busy and it is taking too long to establish the connection with database.

To succeed the most import thing is how you design your database and of course you have to use LIKE search.

Once the report is filled with data the report will be automatically shown.

Thanx for shairing the info .the book is really useful. I have already gone throught that one.

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.

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 …

Try this sample connection string. [code=vb] oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\somepath\mydb.mdb;" & _ "Jet OLEDB:Database Password=MyDbPassword", _ "myUsername", "myPassword" [/code]

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

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

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

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

Try to create the view using simple where clause for checking the PurchaseDescription field and change the other fields accordingly.

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

Try to register the ocx file using REGSVR32 key.

Photography is my passion.

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

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.

What is the type of connection that you are using.

Kindly mention what is the databse you are using and how you are trying to connect the control to the database.

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.

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.

If you are trying to store value retrived from database then try to use [B]x=DE.rsPegawai!NmPeg[/B]

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

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 …

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.

try this sample query [code=oracle]insert into temp values(101,'vijaya''s');[/code] 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.

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

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.

Are you expecting the complete code with proper documentation.

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

[quote=vidyahajare;461160]hi folks, i want some help with dlls i want to create dll which will take image file path as input string do some processing, and five different strings as output. how to use it. can anyone give sample code thanks[/quote] What exactly is your requirment ? What is the …

You simply need to join the tables to get the desired output. Try from your side and post the query that you have tried to get further clarification on the topic .

Actually ADO and DAO are totally different technologies. DAO is much older in comparision to ADO,which is the best technilogy as per performance and security that is available in VB 6.0. theya re not compartible with each other. so if you wna to change your cod efrom DAO to ADO …

Then u need to do the same from your frontend application. For encription or decription u can use any logic that is more suitable to your project.

The logic is so simple .This can be implemented at the database level it self by using SQL statments. When the user tries to login check for existance of such an user with the corresponding password . If the user exists then go further. To check for existance try to …