Posts by debasisdas

If still there is any problem then let me know.

You need to use convertion function.

BTW which version of VB you are using ?
Is it Vb 6.0

You need to use the LEN function.

You mean to say , you want to retrive the source code from exe file ?

If that is the case then not possible.

You ned to add the crystal report viewer from project--->Components and then display the report .

Then what is the use of property pallet.
Can you do the same for name property from code window.

Live means if it is a production database or multiple users are working on it and the database contains some critical data which is important to any organization.

Some people find fault like there is a reward for it .

No maintanance at all if using for personal use.
If it is live definately needs maintanance.

There is no point at which having arrived we can remain.

You should be able to work with that one. There is no such restriction.

You are most welcome .

Your code contains some basic level errors

1.Why ctr2 is string type ?
2.You need to run the loop upto ctr2-1 not ctr2.
3.The values in the listbox are strings not numbers . Why using val to compare the values ?

Setting up oracle for personal use is pretty easy . If you are going to use that for the purpose of a realtime database server then you need to be an expert . Since you are going to use the free version no need to bother about all that.

You need to use Query\T && P System

in the caption property.

One of our greatest gifts is out intuition.
It is a sixth sense we all have –
we just need to learn to tap into and trust it.”

There will be no differeance for VB. As i told earlier you only need to change the connection string. In oracle you can create procedures and functions and execute them from Vb also.

You need to set everything to its default value with the default form.

The best solution for the problem is to use COUNT() .
Take the user input from textbox and using count findout the number of records in database which satisfies the condition. If it is 1 then say OK (login successful and proceed further) else wrong(login failed)
For this the username field should be the primary key of the table.

Are both the projects part of a single solution ?

Thats what i asked . How much closer to the input time.

1 GB of ram is enough for installing Oracle 10g.

tryb to use this sample code for reference.

Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii >= 97 And KeyAscii <= 122 Then
KeyAscii = 0
End If
End Sub

You need to use some third party tools.

You need to handle the keyascii in the keypress event .

Always be on time . Because too late is a crime.

You need to use reports like Datareport or Crustal report for reportin g purpose. That gives you better options like data foramtting etc.

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.

The code you require has been posted here a number of times. Please spend some time to search here for the same.

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

I know that . I have designed a lot of them myself .

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

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.

Yes oracle 10g is the best database from oracle (11g already released, but i am yet to use with VB).
It is very easy to setup and use .
You only need to change the connection string . Try this sample connection string.

Provider=MSDAORA.1;Password=debasis;User ID=debasis;Data Source=das;Persist Security Info=True

What do you mean by nearest .
What is the parameter of nearest
1 min
30 min
1 hr
2 hr
.....
....
What you want ?

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

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.

I trhink it is better to learn by youself than paying to anyone fo these simple things.

You need to use microsoft commondialog control for the browse button and use the show open method and you can use multimedia control or windows media player control to play the file.

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

Dead mummy returns.

try using rs.movelast
and then use rs.RecordCount

Your own mind is a sacred enclosure into which nothing harmful can enter except by your promotion.

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.

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

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

My handwriting is getting worse day by day.

Happiness is not an accident.Nor is it something you wish for.Happiness is something you design.