Posts by debasisdas

You need to use some third party controls for the desired results.

It is always recommended to register the component with windows and then use it in VB 6.0.
Add the same from Project---->References

and then use it.

I strongly believe there is no limit for the number of records in access database.
Try to create index on the fields for faster data access.

Instead of using addnew ,you need to use Edit .

In simple terms instead using Insert you need to Update the existing record.

The code from Shouvik will work fine. But i would recommend you to use use COUNT to findout existance of the username and password in the database.

1.Accept the username and password from user input.
2.In the database username field should be the primary/unique key to avaoid duplicate user name.
3.Check for existance of the same useing COUNT().
4.Login to application iof count returns 1 else ask to re-enter the username and password.

Since using COUNT this will give you better performance even in case of a large user database.

It is always better to go for .Net. It has a lot of advantages over age old VB 6.0. But if you still want to use VB 6.0 ,you can go for the same.

The following code should work for you.

Data1.RecordSource = "SELECT * FROM waqf where cardno LIKE "'%" & Trim(s) & "%'"

Timer is one of the easiest controls to code. It has the minimum properties and responds to timer event of the control.

You have designed the browser yourself or using any other browser(like IE) component ?

Nothing comes in the way of the ONE Who has DECIDED.

The mind that is anxious about future events is miserable.

Was he really accurate ?

ammonia-------->poison

4489

-822

tell

ball

-820

frankly, i even could not get that to 2.

Please find a related discussion here.

1. remove the begin end part
2.use INPUT BOX instead of PUT
3.accept the value from inputbox instead of GET.

rest almost remains

You need to fight not play to win.

The lvbutton.ocx file might have got corrupted .

Please do not start a thread for such kind of things.

Are you commiting after each Delete operation in the code ?

We can't do great things in this life . . .
We can only do small things with great love.

-- Mother Theresa

Are you planning to do that using VB 6.0 ?

1.read the file
2.copy the content
3.convert to uppercase
4.then compare line by line with master file.

The code syntax is correct . it seems there is some logic error in your code. Run the code using brake points and check.

What is the data type you are using in Access . Try using decimal .

You need to enclose the quotes by enclosing quotes since it is a string.

You need to parse sysdate+1+2/24+20/(24*60) to proper format before processing in database.

Is you application connected to oracle database ?

Live now. Make now always the most precious time.
Now will never come again.

Love hurts, too much...............

What is that 4 ?

You want to print 4 copies at once
or
Four labels on a single page ?

Some of the required system files must might got corrupted.

Pure logic is the ruin of the spirit.

Have you connected to database and fetched the total attendance from database table ?

This happens if the project file is copied from a CD where all the files are read only. After copying the files to system from CD check to ensure that the files are not read only (uncheck the read only check box).

Growing old is mandatory. Growing up is optional.

What is the problem you need to store the values in a variable. No need to sue second textbox.

One is not born, but rather becomes, a woman.

try using the API PlaySound.

The less people speak of their greatness,
the more we think of it.

Through activity, man attains purity of consciousness.

That is available already in VB 6.0. You only need to change the style property of the listbox form Standard (default) to Checked.

Find purpose, the means shall follow.

You need to check if F1 has already been pressed which pressing F2 key. It is always recommended to avoid using F1 and F10 key.

What are you trying to do using tab key ?

Try setting the KeyPreview property of the form to TRUE.