debasisdas

You need to show some effort to get any help here.

what is a hidden constraint ? try to use MS visio .

Tanhayee------------Sonu Nigam

[This](http://bytes.com/topic/visual-basic/insights/783723-backup-restore-access-database) may be useful to you.

Day before yesterday i got an alert on my mobile for a transaction of $25 on my VISA credit card. Since i was traveling i got suspicious may be someone has stolen the card. Once i realized the card was with me only i had to call the bank to …

If you have some sample data in an excell sheet or in .CSV format, you can upload those into tha table using SQL*LOADER.

[QUOTE=yamunacbs;1634041]What are the requirements of Search Engine Optimization?[/QUOTE] To Optimize the Search Engine. :cool:

use Me.Close() on the button click event

You need to design your own database objects.

There is a bult in login form available in Vb 6.0 IDE. Try to enhance that.

You need to read [this](http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf) and [this](http://docs.oracle.com/cd/B19306_01/appdev.102/b14261.pdf).

if you want to download somthing then better to sue browser control. IF still want to use mediaplayer use this [code=vb] WMP.launchURL ("http://www.yahoo.com")[/code] but that will still lunch the browser.

To create jut an exe select makeEXE in File menu. To create a complete setup use the Package and Deployment wizard .

try using .05 in place of '.05'

Please follow these links SQL http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf PL/SQL http://docs.oracle.com/cd/B19306_01/appdev.102/b14261.pdf

The answer is a big NO.

You need to compile the above piece of code into a function and use the output as your PK and populate in the form. Later insert the same value into the table.

Which control you are using to create the graph ? Does that control support spider web graph ? If it supports you just need to change the property, if not you can't do that. You may need to look for some other control for the purpose.

That is how you reuse the same piece code.

Why you need to select the color using a label and why 4 buttons just to change the color. Select the color using a combobox and use a single button.

You need to read a lot of books.

OutpatientDetails should be a subset of InpatientDetails. Technically only the patients how have come in can only go out. You need to maintain the same id in both the tables. Later if it is required you need to join both the tables based on the ID field for any reporting …

Please post, what you have done so far and in which step you are struck, for further assistance from our experts.

in what format ?

You need to read [URL="http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf"]this[/URL] and later on go for [URL="http://docs.oracle.com/cd/B19306_01/appdev.102/b14261.pdf"]this[/URL].

Why you need to use INTO clause in the SELECT statement ? Elements after INTO clause needs to be variables and those needs to be declared in the current scope.

How are you capturing the flow of process of a SQL procedure ?

Only if you are ready to pay the full amount in advance.

Use [URL="http://www.microsoft.com/download/en/details.aspx?id=23903"]this[/URL] and set the chart type as desired.

Creating view is a better option for that.

This info is not enough to provide you with any solution. You need to hire a professional for the job.

Is that your own code ?

You are using MySQL or Oracle ? You command you tried is not a valid SQL syntax.

try this [CODE]text2.text = list1.list (text1.text)[/CODE]

For searching it is always better to use [B]LIKE[/B] than "[B]=[/B]"

You said that is your code. but it does not seem the same to me.

Before jumping into coding ,u need to study the actual requirment ,analise those and then go for designing. Who do u expect us to help you without knowing what eactly you are trying to develop.

What you want to do ? use either one or all the parameters to filter records ?

You need to read [URL="http://docs.oracle.com/cd/B14117_01/server.101/b10759.pdf"]this[/URL] to understand the basics.

What exactly you mean by Horizontal Fragmentation ? What are you trying to achieve ?

Creating database at run time does not make any sense. You need to use EXECUTE IMMEDIATE to create tables at run time.

You need to understand the basics correctly. scott is a schema within the database not the other way around.

You need to use filelistbox for the purpose.

How you decide which is the most recent upload ? Are you storing the upload date and time in the DB table ?

You need to read [URL="http://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm"]this[/URL] and [URL="http://docs.oracle.com/html/B13916_04/joins.htm"]this[/URL].

try this Select count(*) from TimeLog where EM_Name = '................. If it returns 1 display the message else proceed further and save the data. You need to ensure that [B]EM_Name[/B] is the primary key of the table

ALTER SESSION set NLS_DATE_FORMAT = 'DD/MM/YYYY'; PLEASE USE THE ABOVE CODE

Better to load the dates as string and convert later.

Hope you did not forget to COMMIT, after executing the INSERT.

What exactly you mean by explode a piece of a pie chart ?