Posts by debasisdas

i don't think that is VB 6.0 code.

if vb 6.0 then try this

Dim Sql As String = "insert into Customer_tbl (Custsql )values '" & txtFirstName.Text & "','" & txtLastName.Text & "')"
con.begintrans          'con-----ADODB connection object.
con.execute sql
con.committrans

The simplest method will be create a view based on the table with last five days record. That will be always refreshed every time you run any query on the view.

then you need to push the power button on your computer.

you need to convert the date and time to proper format before passing the same to database for processing through SQL statement.

you need to use the function REPLACE.

The query that you are using to frame the query needs to be framed dynamically by input from combo and passed to report.

what exactly you mean by over internet ?

are you in the same network as the server ?

try the simple code

con.begintrans              'con-----adodb connection object.
con.execute "your DML statement here"
con.committrans

you must be connected to the database.

if you are using oracle as database then can use external table for the best solution,but you need to extract the zip first.

you need to open the recordset as per selection of the combobox input and pass the same recordset to report.

try the following

dim con as new adodb.connection

con.open "your connection string here"

add my previous code after this line

better use ADODB library for the purpose. try the sample code below

con.begintrans        'con-----adodb connection object
con.execute "your sql insert statment here"
con.committrans

try the following code with ADO

con.begintrans            'con--ADODB connection object
con.execute "put your sql statement here "
con.commitrans

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

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

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

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

at command prompt type exp help=y you will get the list of parameters for export . repeat the same for import with keyword imp

how are you calling the report ?

you need to frame the sql dynamically at runtime and pass the same to the report.

Congratulations on your infinite wisdom!!!

That is because of this Until today I just assumed it wasn't an option. You posted as if that was released the day you found it. If you do not know something do not assume that the whole world is ignorant of it.
There are so many things we do not know. That does not me those did not exist till we came to know about it. If you are learning old things like VB 6.0 and that is new for you ,then that is perfectly fine.

can you post what you have tried so far .

I think you heard of that recently. I have that component with me for years now.

1.what about simply formatting that using some string function. why not simply take the system time instead of entering the time. that way no one can enter wrong time.
2.you need to code in change event not lostfocus.
3.i dont understand your question.

you need to format the time value properly before processing.

everything is possible ,but nothing happens automatically. You need to code that.

using DOEVENTS just might help you .

download those from net

the following query should work fine for you

"Select * from accounts where emp_code='"+d+"' AND emp_name='"+n+"'"

that is because VBA is used to define macros notto compile an EXE or DLL.

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

any ways you have to run the application . you can always call a specific sub on a button click for testing.

you need to capture the row numner and colum number in the grid ,read it and pass the value to the textbox on another page.

byusing

Dim rs As new adodb.Recordset

your problem is solved.

if you mean sql server then in simple i can say sql server is an ORDBMS while access is not.

5. Not necessary .Yes

6. The latest the best .

please correct this

b = "Employee Number Like """ & a & "*"""

please find the details here ,here and here.

do you have Service Pack 6 for Visual Basic 6.0 ?

You can do this ata database level using SQL queries.

if the employee number is a number use emp_number=number
if the employee number is a string use emp_number like '%string%'

vb suppoerts all version. i think the problem is you are not having required patch files /updates in your system.

what happens if you insert NULL to the field ?

is there any constraints on the database table fields.

so what is your problem ?

1.assign two flags for the files.
2.generate a random number.
3.display one picture if the number is even or the other if that is odd.

please explain your problem.

i am not used to opening any zip i come across in net.

you need to use some third party component for that.

i would suggest to go for oracle.

try to use this

conn.begintrans
Conn.Execute "DELETE FROM <tablename> WHERE FIELD1 = '" & cmdField1.Text & "'"
conn.committrans

you can connect any version to VB.

how you are trying to connect.

try to use MID fuction for the purpose.

make that dynamic.