Posts by debasisdas

Hi amir,

Welcome to daniweb.

There is no hard and fast rule or database structure for something like library management system. That entirely depends on how and what exactly you want to implement.

Hi Aldo,

Your intro is so cool.

Welcome to Daniweb..

Hi Joe

welcome to daniweb.

You can find all info on line.

Please find out the connection strings here.

Welcome Spyder,

You have one of the best intros.

Hi Keith,

You can start contributing right away.

Hi

welcome to daniweb.

Hope to see you contributing soon.

Then take help of Google, the is the best source for finding anything.

Hello Edward,

welcome to daniweb.

I never felt true love until I was with you, And I never felt true sadness until you left me.

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

"Joy is a net of love by which you can catch souls." Mother Teresa

Hi sheila

Our experts can surely help you.

Welcome to Daniweb.

Welcome

I really like the way you said our forum.

Initially we all learn and later help others do the same.

I really enjoy welcoming you.

We can really learn a lot together.

that can be easily done by adding ORDER BY key word in your search criteria.

"Where there is great love, there are always miracles." Willa Cather

Welcome Gary,

We all learn by helping each other.

Welcome to daniweb.

Just keep using your system and do post here in case you are struck anywhere.

Hi,

Welcome to daniweb.

I was also new here oneday.

Hello skyer.

We are glad to have you around.

Hi Hachimi ,

Welcome aboard.

Hi Derek,

Welcome to Daniweb.

We are pleased to have you around.

You have one of the best intros.

Welcome Ani ,

We all learn here everyday by sharing , Waiting for your contribution.

Welcome Brandon,

Hope you will have a nice time here.

an vb application creates a session in oracle once you open a connection and is closed when you close the connection object.

you need to start reading the book and try to understand the basics first before starting any sort of coding.

you need to substract the system time from the user input and do the rest with a timer control.

You never win Silver, but always loose Gold.

"Love involves a peculiar unfathomable combination of understanding and misunderstanding."

Diane Arbus

It is so simple to be happy but so difficult to be simple.

If you are looking for the connection string find it here.

from vb 6.0 you need to use ADO.

all the companies will fight to find a place in the list.

"Love is loving what your lover loves". Anonymous

please check lblStartTime refers to a lebel or not or is there any control array.

Stay true to Nature, your Nature.

you do not need an intermediate table only defining the relationship by PK and FK will do that for you. But from your post i am not use what exactly you are looking for. I think you need to pass more information.

1. open the recordset only for itemID
2. in a for loop add the items to combobox
3. open another recordset for itemname by passing itemID in where clause at runtime dynamically by selecting the itmes from combobox

Are you using data report ?

you need to check if BOF or EOF properties are TRUE before using the move methods.

try this sample function for the job.

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

Dim newstr As String

numstr = CDec(numstr)

If numstr = 0 Then
NumToWord = "Zero"
Exit Function
End If

If numstr > 10 ^ 24 Then
NumToWord = "Number too big"
Exit Function
End If

If numstr >= 10 ^ 12 Then
newstr = NumToWord(Int(numstr / 10 ^ 12))
numstr = ((numstr / 10 ^ 12) - _
Int(numstr / 10 ^ 12)) * 10 ^ 12
If numstr = 0 Then
tempstr = tempstr & newstr & "Bilion "
Else
tempstr = tempstr & newstr & "Bilion "
End If
End If

If numstr >= 10 ^ 6 Then
newstr = NumToWord(Int(numstr / 10 ^ 6))
numstr = ((numstr / 10 ^ 6) - _
Int(numstr / 10 ^ 6)) * 10 ^ 6
If numstr = 0 Then
tempstr = tempstr & newstr & "milion "
Else
tempstr = tempstr & newstr & "milion "
End If
End If

If numstr >= 10 ^ 3 Then ' thousand
newstr = NumToWord(Int(numstr / 10 ^ 3))
numstr = ((numstr / 10 ^ 3) - Int(numstr / 10 ^ 3)) * 10 ^ 3
If numstr = 0 Then
tempstr = tempstr & newstr & "thousand "
Else
tempstr = tempstr & newstr & "thousand "
End If
End If

If numstr >= 10 ^ 2 Then
newstr = NumToWord(Int(numstr / 10 ^ 2))
numstr = ((numstr / 10 ^ 2) - Int(numstr / …

The rules of the nature never changes but nature itself keeps changing constantly.

"I never knew how to worship until I knew how to love." Henry Ward Beecher

A couple of years back i was working at the data center of one of the largest paper plants in Asia. Actually i was not supposed to go inside the plant but once i decided to go inside and find out what exactly happens. There was a vacuum lift crane that lifts paper rolls up to 6 tones which operates over our head. As i was just passing by it dropped a six ton roll seconds after an alarm went off. and luckily i was couple of feet away.

I feel really sorry for all those who are still using DAO or RDO.

I don't understand why one needs to use different technologies for different databases.

It is better to be married once that be divorced thrice.

The SHOW method is used to SHOW (make it visible) the form at run time.