debasisdas

are you trying to convert the horizontal model to horizontal ?

you can use loop inside a sub program for the purpose.

1) FRM-----form file contains all the componenets and code there of. 2) BAS-----module file contains objects with global access 3) FRX-----form binary file contains images of FRM file. 4) OCX----windows components. 5) CLS----class file contains the classes defined if any. 6) VBP-----visual basic project. hope that helped you.

are you trying to prepare the insert script for all the tables ?

better use ADODB library for the purpose. try the sample code below [code=vb] con.begintrans 'con-----adodb connection object con.execute "your sql insert statment here" con.committrans [/code]

try the following code with ADO [code] con.begintrans 'con--ADODB connection object con.execute "put your sql statement here " con.commitrans[/code]

oracle does not support the data type BOOLEAN in sql. use some flag for true and false and process accordingly.

select substr(ss_id, -6) from id_table this should work for you

debasisdas i love my id and name

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

1. select the month. 2. findout all the dates. 3. findout the days by passing the dates ---use WEEKDAYNAME function for the purpose.

one of the best servering moderator . So i give you 9.

have you created the DSN in the target system to connect to database ?

Try use this sample code [code=vb] Private Sub tv1_NodeClick(ByVal Node As MSComctlLib.Node) LV1.ListItems.Clear rs.Open "select * from EMP", con, adOpenDynamic, adLockOptimistic Dim li1 As ListItem Set li1 = LV1.ListItems.Add() If Not rs.EOF Then If IsNull(rs(0)) Then li1.Text = "" Else li1.Text = rs(0) End If If IsNull(rs(1)) Then LV1.ListItems(1).ListSubItems.Add , …

what is the table structure and what is the query that you are working on ?

you want me to write a complete accounts package in VB 6.0 and give it to you for free ?

Please find a related discussion [URL="http://digg.com/programming/Handling_Picture_Box_in_VB_6_0"]here[/URL].

what do you mean by [B]only distinct row [/B]. i believe that means all the fields in a row are same. [B]distinct[/B] will definately filter that out.

is that in VB 6.0 ?

what exactly is a [B]fade in and fade out label [/B]?

you can use recordset for the purpose. open a recordset from temp table and insert to temp2 table. later if you want to delete the records from temp then go for it.

only practise can make you perfect as there is no shortcut to success.

1.i can't understand the first question. 2.if you are looking for the connection string find it [URL="http://connectionstrings.com/"]here[/URL].

and just to explain vbcrlf----stands for---VisualBasicCarriageReturnLineFeed. even though a bit long, i hope that is quiet easy to undestand .

what is [B]My[/B] ? is that an object ?

even better to use any grid control.

why not run the exe by using Scheduled Task ...

try to use some flag setting for loading and unloading of child forms and check the same during unload of the MDI form.

you deserve a pat on the back. so pat pat pat.......pat pat pat ....pat pat pat .... i hope that is enough

kindly post the codde that you are working on, and the part you are faing problem in.

that is not possible (to reverse engineer the EXE to get the source code).

then you need to findout the time difference between the start time and end time and keep on adding them

why you need to connect Vb to another GUI tool , not a database. I hope yo know SQLyog is a GUI not a database like msaccess. if you are looking for the connection string to mysql ,find it [URL="http://connectionstrings.com/mysql"]here[/URL].

that will be easy if you use .NET not vb 6.

You need to design your own compoent for that.

please find the connectionstring at [url]http://www.connectionstrings.com/?carrier=oracle[/url]

What do you mean by [B]compiler for VB6 [/B]? If you want the VisualStudio, that is not supported any more by MS so VB6.0 is not available for purchasing anymore .

If you arer not happy with the free controls, try to define your own component.

what is the problem for you ? i suggest you to better use DTPicker control instead of a calander.

is that for interface of VB applications ?

you need to pass the sql query dynamically at run time as per user input.

What you want to impliment in online examination project ?

if using ADO that can be done by using SQL queries using LIKE search.

Wishing Happy New year to my immediate neighbours, a bit in advance though.

Wishing the best ever happy new year to all at daniweb.

Are you getting any error in your code ? that should work for you.

you can also use Multimedia control to play audio/video files.

you need to use MAPI control.

since you will need to display a lot of records why not use a grid instead of number of textboes.

YOU DO NOT NEED ANY EXTRA CODE. when you read the barcode using the device ,it directly inserts the code into any comntrol having focus on the form. Next you just need to process the code as per your requirment.