debasisdas

The keyword [B]User[/B] might not be supported, check for that in the databse that u are using.

What is the code that is throwing the mentioned error message ?

all icon files comes with .ICO extension. You may also able to use .CUR (Cursor files) also.

Yes exactly.

You need top pass more information. Do not expect us to guess and solve the problem that you are facing. MY GUESS :--May be there is a TRIGGER to control the log in activity at system level.

You need to use [B]Common Dialog Control[/B] for that functionality.

1. You can use DBMS_JOB or DBMS_SCHEDULER on a Oracle DB to execute a procedure at interval . Other questions are totally irrelevant without the knowledge of the actual requirement.

What is [B]l_employees[/B] ? It does not have any definition in your code .

what is the code that you are working on ?

try this [code]# rs.open "select * from table2 where gender='" & cbgender.list(cbgender.listindex) & "'",conn,adopenkeyset,adlockoptimistic,adcmdtext # [/code] this code should fire after selection of the combo box not before that

by writing some SQL. What is the database that you are working on ?

You need to add ORDER BY clause to your SQL. Select the field on which you need to sort (may be payment _date in your case)

Have you designed the database according to your requirement ?

What about using LIKE for pattern matching.

It seems to be a school or college assignment. Before deleopment of the project you need to gather all the requirments ,next step is database design and final step is coding.

You need to concatenate the fields to display as address and then populate the grid with the address field.

Please find the details [URL="http://www.google.co.in/search?hl=en&q=partion+in+oracle&sourceid=navclient-ff&rlz=1B3GGGL_enIN354IN354&ie=UTF-8&aq=0&oq=partion+in"]here[/URL].

Please find all that [URL="http://www.google.co.in/search?hl=en&q=oracle+vs+sql+server&sourceid=navclient-ff&rlz=1B3GGGL_enIN354IN354&ie=UTF-8&aq=0&oq=oracle+vs+"]here[/URL].

What is the table. Would you mind posting the table structure.

you can use GUI tools like TOAD or PL/SQL DEVELOPER. if you want a free tool try SQL DEVELOPER from oracle corporation.

You need to read books for a complete detailed description of all those recordset types and mode of lock of recordset.

If you are planning to manage all that by yourself then it will depend on your level of expertise and your budget.

Copying a file to CD is not like copying the file to some physical drive. You need to add some code to write/burn that file to the CD using the device.

Do you know how to take Backup My SQL Database without using vb from command prompt. If yes, put all that into a batch file and call the same from VB using SHELL.

You need to use [B]PlaySound API [/B]

Ok i will give you code. How much you are ready to pay me ?

[QUOTE=jemz;1131060] ..everytime i always add data it always already exist .... [/QUOTE] What exactly is the problem ?

That never happens. It seems you mis-understood the concept of Roles and privileges. In your case if the user has both the privileges ROLE1 and ROLE2 then the user will have SELECT and INSERT and UPDATE on the table1. one role will not over write to another it only adds …

Which file ? What the file contains ?

You need to define the function in a standard module (.bas file). Once the function is public it will have global scope.

You may need to change [B]NLS_CHARACTERSET[/B]

Saluting the indian tri color.

What about posting what is the basic design that you have come up with, later experts can share their views on the same.

try to use [B]SELECT distinct JobNumber FROM myTABLE;[/B]

You need to capture ,user clicks on which cell. Then capture the data in that cell. Store in public variable. Show the form 2 and display in a textbox.

If that tool supports what you want then you need to go through the product documentation.

Please find all that [URL="http://www.dba-oracle.com/oracle_create_database.htm"]here[/URL].

What exactly you mean by [b]generate user's to my database[/b] ? What is your database ?

Try using MS office Visio, but that is not a free tool.

Use ADO. Please find the connection string [URL="http://www.connectionstrings.com/access"]here[/URL].

What is the interface you are using to send SMS ? How you plan to connect to SMS gateway ?

You need to use predefined functions and features.

Hi Terry, Welcome to Daniweb.

to get the list of oracle tables use the following [code]select table_name from user_tables order by table_name[/code] to get the list of columns of a oracle tables use the following [code]select column_name from user_tab_cols where table_name=upper('table_name') order by column_name[/code] You can use 2 combo boxes one to populate the list …

your code does not say anything about binding of control and database .

You need to handle the ascii value of the keys on keypress event of the control.

you need to refer the textbox by its index and collect the values in a loop.

to enter single quotes you need to enter 2 single quotes ('') also do not forget to enclose those by enclosing single quotes.

we all are ready to exchange our knowledge.

Hi Sheva, Welcome to Daniweb.