debasisdas

May be you are dreaming, you need to wake up and check your application code.

now i learn that i must go to bed now ,almost after 15 hrs with my notebook.

Welcome to Daniweb.

You need to use [B]FileSystemObject[/B].

you need to read [URL="http://dev.mysql.com/doc/refman/5.0/en/exists-and-not-exists-subqueries.html"]this[/URL].

You need to hook up the height and width property of the text box with that of the containing form. Handle that in the form_resize event.

Welcome aboard.

Are you facing any problem with the control ? You simply need to take the value from the control, format is at per you database date format and store in DB.

Use printer for what ? What you want to print ?

You need to read [URL="http://books.google.co.in/books?id=a5iIRThV0RoC&printsec=frontcover&dq=visual+basic+black+book&hl=en&ei=KsFUTonVE8OzrAfiionJDg&sa=X&oi=book_result&ct=result&resnum=2&ved=0CDkQ6AEwAQ#v=onepage&q&f=false"]this[/URL].

what you have tried so far ?

TRY THIS [CODE]cnn.BeginTrans cnn.Execute "your sql udpate query goes here" cnn.CommitTrans[/CODE]

so, what is the problem ?

show some effort, to get any help.

You need to use ADO library in VB 6. Read more [URL="http://www.vb6.us/tutorials/database-access-ado-vb6-tutorial"]here[/URL] and [URL="http://www.timesheetsmts.com/adotutorial.htm"]here[/URL].

lets see the query that you are working on.

[QUOTE=Walahh;1628934]I am only getting results for converting a MS Accss 'database' to a SQL 'database'. ...... I just want to convert one MS Access 'table' to SQL Server (2008) 'table'. [/QUOTE] What is the difference ?

Why not loop through the items in the array by index..

for that you need to frame the query dynamically at run time. try this. [CODE]PREPARE sql_stmt FROM "your query"; EXECUTE sql_stmt; [/CODE]

You need to format the [B]DateTimePicker1.Text[/B] before passing the same into database for inserting.

what is the query that you are working on ?

You need to use common dialog control.

do you have index on [B]id[/B] column ?

You do that for windows phones.

more information please .

post your table structure and the query that you are working on.

try the fiollowing [CODE]SELECT * INTO OUTFILE 'result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table_name;[/CODE] also read [URL="http://ariejan.net/2008/11/27/export-csv-directly-from-mysql"]this[/URL].

Is it an attendance system ?

You need to use database for this. [B]new value = max of current value + 1[/B]

Welcome to Daniweb.

you need to round off the value to the desired decimal places.

Your data is in which format ?

you can't convert directly to previous version. you need to do it manually by re writing the code as suggested in the previous post.

First of all you need to store opening and closing time in date time format.

Hi Jonan, Welcome to Daniweb.

Welcome aboard.

In what format dates are being stored ?

are you trying to fetch the last record ?

Are you using database ?

There no distinct field ?

You must and should go with the approach of using relational database.

Kindly post the tables structures also post the query that you are working on.

No need to remember all. Use the one required for you.

Please pass more information.

please explain what exactly you are doing. I will explain the difference between the two.

[QUOTE=TIP.Synergy;1624511] how to insert a pdf file in database[/QUOTE] Read the file into a binary stream and store the same into a database table.

you need to fix the SQL query that you are using . Check for proper syntax.

oracle is an ORDBMS ---in short is a database. and dba is a human being----is one who manages/administers the database.

[QUOTE=ed_shaw;1604731]Many implications to this, but this is not the place to address them.[/QUOTE] Exactly.

Lets see what you have tried.