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.

kindly post your table structure.

Welcome Spyder, You have one of the best intros.

Hi Aldo, Your intro is so cool. Welcome to Daniweb..

Hi Joe welcome to daniweb.

Hi welcome to daniweb. Hope to see you contributing soon.

Please find out the connection strings [URL="http://www.connectionstrings.com/"]here[/URL].

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.

Hi Keith, You can start contributing right away.

Hello Edward, welcome to daniweb.

Welcome I really like the way you said [B]our forum[/B]. Initially we all learn and later help others do the same.

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

Hi sheila Our experts can surely help you.

Welcome to Daniweb.

I really enjoy welcoming you. We can really learn a lot together.

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.

Are you using data report ?

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

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

If you are having a licensed copy of windows and net is connected. You can directly update the system with framework latest version.

If you are looking for the connection string find it [URL="http://www.connectionstrings.com/"]here[/URL]. from vb 6.0 you need to use ADO.

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 …

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.

i don't think this if statement can be changed to a loop as there are too many conditions to check.

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

Why not simply use the WHERE clause along with the SQL statement to find the record. You can also use COUNT to find if the record exists and then display the message accordingly. Using COUNT will be really fast.

You need to use ADO with any database of your choice for optimal performance.

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

i have the code but not now. I will send you that later on.

you need to format the input to date for before passing the same to database for processing.

You need to work with CDO.

What about simply using a COUNT on the database table !!! something like the following [code=sql]select num,count(num) from table_name group by num[/code]

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

not a bad suggestion

what is your table structure ?

you can code in both the events of the control [B]change[/B] and [B]scroll[/B]

You need to use the trigonometrical functions SIN and COS for all that.

is the follwing is your query [code=sql]SELECT Products, TABLE 1;[/code] what does the query mean ?

if you are looking for the connection string please find it [URL="http://www.connectionstrings.com/access"]here[/URL].

try the following sample code [code=vb] Dim CN As New ADODB.Connection Dim RS As ADODB.Recordset Dim DataFile As Integer, Fl As Long, Chunks As Integer Dim Fragment As Integer, Chunk() As Byte, i As Integer, FileName As String Private Const ChunkSize As Integer = 16384 Private Const conChunkSize = 100 …