Posts by debasisdas

please do not double post your questions.

if the form is not part of the project you can easily add the files by pressing Ctrl+D you need to save that to project.

you need to code your requirments.

you want to connect to anexisting database or create a new one at run time ?

Those who teach can't do ,those who do may not teach.

you can use string functions with concatination or just follow the previous post.

search the net . you can easily find some third party compoents for your purpose.

are you trying to modify a radonly file copied from a read only media like a CD ?

to take assistance of our experts you need to post what you have tried so far .

kindly post what you have tried so far .

what you have tried apart from this code ?

instead of hard coding the recordset object open and close that dynamically through a sub procedure.

Please find a related article here. the code is for access . You just need to change the connection string for SQL Server.

If you are familar with oracle procedures then you just need to take care of the syntax and just implement the logic in PLSQL.

Please find an article on the topic here .

It is tested on oracle 10.2 and uses UTL_SMTP.

if you have oracle server installed in your system then it must be the default database name or the name you have choosen at the time of installation.

If you donot know the name of the database how you have connected to the server.

If using only username and password to login then check in the default database in your system.

Please do not try MySQL commands in SQL.

creation of database is diffent in oracle .
Refer to books/manual for details.

What you cannot enforce.
Do not command.

Hope is the dream of the waking man.

.................................
I do not understand what is the problem.
...................................

I don't understand all that junk code .

Please pass more information. What do you mean by table will be created automatically. You can check if the table exists in database or not by using simple SQl statments.

using the cache increases the performance but that can create problem in some circumstances also.

You can easily downlaod that from Oracle site.

You need to decide which database you want to work on .Because there are several databases in market . After that you can start learning the database from scratch.

What did Google say ?

Have you tried for that option ?

kindly post your code for reference of our experts.

you need to call the function on button click.

option1

use EXECUTE IMMEDIATE for such commands

option2

use ADOX instead of ADO.

try to change the border style.

try to use this

me.backcolor=rgb(rnd*255,rnd*255,rnd*255)

and call this on a timer .
set the timer interval as desired.

You need to work with command objects .

That entirely depends on the type of projet you are doing.

Add reference to ADODB and then create objects . Then you just need to play with those.

Sorry we don't do home works here.

you need to create two connection objects. Insert in access and if connection exists open the second connection and repeat the step1 again.

You need to learn for basics first instead of going for certifications. Certifications will definately add some weitage but that is not compulsary.

Have run the nextval from any other query or only for testing the values ? it never happens that it will get incremented automaticalyy or affect other sequence objects.

try to execute the commands with EXECUTE IMMEDIATE .

We make our fortunes, and we call them fate.

It is always bettter to open and close the connection in the application itself.

where do u plan to store the username and password ?

Please find the connection string here.

please find related discussions here and here.

It is not what happens to you but how you respond to what happens to you that determines how you feel.

Kindly post your code that you are working on for reference of our experts.

What do you mean by the focus may also be changed ?

One of the best uses of your time is to increase your competence in your key result areas.

There are other better GUI tools like TOAD and PLSQL DEVELOPER but you need to purchase those.

You can use the inbuild tool SQL*PLUS. if you want GUI then can download and use SQL DEVELOPER for free from oracle site.

Please find a related discussion here .