Posts by debasisdas

Welcome aboard.

Tell me first which data base you are using.

Is it MySQL or Ms Access ?

This may help.

also try --- Shell "shutdown -s"

The following links may help.

http://www.vbforums.com/showthread.php?t=350570
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=8224
http://www.winpim.com/anigif.htm

you need to pass the parameter for bill_INV_No dynamically using some control.

try this

Private Sub Report_Initialize()
CrystalReport1.SQLQueryString = "Select * from bill_client where bill_INV_No = & val(text_INV_No.text)"
End Sub

You will never find any database online that caters to your exact requirement. So you need to design your own DB. Ans so far as log in concerned create a table to store user_id, password and other required information.You need to check for existence of userid/ password in the database. If it exists log in successful and allow the user to proceed further.

From where you got this error ?

What code , which application, which database ?

You can't do that.

How about handling that using numeric keypad.
use the keys 1,3,7,9

Are you able to connect to oracle using the same tool ?

Which database you plan to use ?

What ever the database is , create a table to store user_id, password and other required information.

You need to create a parametrized function with $artistID as the input.

Then call the function from your application code.

try this (oracle code)

select to_char(sysdate,'ddspth fmmonth yyyysp') from dual

If dates are being stored in oracle DB then you may use this.

What is jtds000001 ?

Actually selecting the table and field names should be handles from front end application and the same need to be passed into back end and the database procedure should process the input parameters to process the job.

Are you storing the login credentials in database ?

i dont have any idea.

I don't have any idea either.

This may help.

you can search for those. Most of them are not free to use.

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.

You need to use some third party tools / components to generate barcode.

How you populate the datagrid ?

what is the code that you are working on ?

Please read more here.

what is the application ?

What exactly is the error message ?

Why the table name is within parenthesis ?

NOTE:--Do not use dataset as name of an object, it is a predefined key word..

That will depend how the value is stored.

Sql Server and MySql may behave differently to the exact same piece of code, after all they are two different databases from two different vendors.

check for date format.

Negative number in a timers interval property does not makes any sense.

Please read more here and here.

What exactly you are trying to print ?

What exactly you are trying to print ? Is it a report ?

You need to handle that part in your code.

Lets see your code.

Spread the word, tell your friends.

C # .NET with SqlServer is good option. Also try php with mysql.

the project is on its way.

what is the source of data.

1. try to print the sql before executing
2. try to execute the sql at backend and check if you are getting any error.

your problem seem to be an application issue than database.

I dont know where to start.:sad:

design the database first.

creates password for what ?

4. How does it happen that people here misunderstand each other frequently?
There.

We do it frequently for some serious fun and to confuse others.

You need to read this.

I think his main worry is -- Google Toolbar not compatible with Firefox 5.

for what ?

Have you compiled the package specifications before trying to compile the package body ?

i think that code is for vb6 not for vb.net.. that's why its not accept hte other function in vb.net ...

That code is in .net only.

Looking the syntax itself you should be able to know what language it is in.

Lets see the code that you are working on and fix it.

It is highly recommended for you to read this.

can you give me some search engine code.

No, You have to show some effort for that first.

I know only one language SQL, and people still refer me as Senior Programmer. :cool:

That is not practical if using almost 50 or more text boxes in scenarios like this.

Simply try this

Private Sub ValidateControls()
        Dim cControl As Control
        For Each cControl InMe.Controls
            If (TypeOf cControl Is TextBox) Then
                'check for what ever you want to check
            End If
        Next cControl
    End Sub

Your code is horrible.
Columns names are qualified by table name not the reverse as mentioned by you in the SQL.