Posts by debasisdas

The Integer data type is a 16-bit number which can range from -32768 to 32767.

You need to use Long data type which is a 32-bit number which can range from -2,147,483,648 to 2,147,483,647. Long variables can only contain non-fractional integer values. You need to use Long variables over Integers for increased performance.

what is the code that you are working on.

You need to call VScroll inside the desired event.

what happens if you update the record at 1st form ?

is it not getting updated in the other form ?

Try inserting some dummy data from back end and recheck.

Also you need to handle NULL properly.

I am not very sure what is the cause of the error.

That version of VB is gone from my system long long back

If both the controls are using database as source then why you need to populate data from one control to another ?

1. Add a check constraint with numbers only as value.
2. For the values refer to another column in some look up table.
3. In that table store the actual meaning of the numbers
i.e.-- 1="pending" 2="watched" etc..

(length of the string including space ) - (lenth of the string after LTRIM) = number of spaces in the start of the string.

Len("Visual Basic") - Len(ltrim("Visual Basic"))

You need to update the database using SQL.

Try to frame queries as per your requirement and execute them in proper event.

Don't expect someone to supply you the complete code.

Have you tried handling the error using ON ERROR and then tired to find out what is the error number or message is ?

You need to merge the fields of profile with user.

Profile_id should be added to profile table.

1.try using ascii value of the character.
2.increment the number part till max value
3.increment the ascii value by 1(one) and repeat step-2

In the login table stare a flag value, which specifies if the ligin use is a normal user or an admin.

Based on that flag value you can enable / disable other dependent forms.

Why not solve that using a Procedure instead.

you need to find a function for the purpose.

The answer is a big NO.

But there are couple of work around for the solution.

You need to take and export of the schema and import the same into the target system.

you need to use the following commands for the purpose.

EXP
IMP

please find the details here , here and here.

You need to use a counter in the button click and based on the counter value decide what is displayed in the textbox.

try the following sample code.

MsgBox("Do you really wish to quit this program ?", vbOKCancel + vbQuestion, "Confirmation")

You need to use the function Replace.

You need to download the proper version and install the same.

umm.im using visual 6,where i can find the built in log in system?

It is there in the fist screen (after splash screen), where you select the project type.

or

go to add forms from there also you can add.

Just as simmple as that.
Thanks.

Why don't you do it yourself then ?

Just try to use the built in login form in VB IDE.

Simple modification will solve your problem.

The info in the link in the previous post is about the database not the system.

do you understand that oracle is a database and not a system programming language ?

the error message is self explanatory.

check if the target database is up and running.

use the following

select level from dual connect by level<=2

May be you can you MEMO field.

This is how you store and retrieve image from database.

It is really difficult to understand why ORA-01841 is be raised in your case , without knowing your table structure.

I don't think that version is available any more.
That has been de-supported by the parent company.

How your tables are linked to each other ?

I don't think they are.

Can't see anything meaningful (you just try to open and check how it looks)
Please attach as a PDF atleast.

you need to handle the keydown event of the control.

go ahead and post your database design here.

thats the main problem....till you take initiative and start writing and post the code that you are working on, no one here is going to write code for you.

so what is the problem ?

post the code that you aare working on currently to get any help from experts.

NOTE:---You need a procedure not a function.

change style to graphical and then set the icon property.

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

What is l_employees ?

It does not have any definition in your code .

try this

#
rs.open "select * from table2 where gender='" & cbgender.list(cbgender.listindex) & "'",conn,adopenkeyset,adlockoptimistic,adcmdtext
#

this code should fire after selection of the combo box not before that

If you want to store the image in database then this is how you store and this is how you retrieve image

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 to the privileges of the other existing/granted roles.

..everytime i always add data it always already exist ....

What exactly is the problem ?

Use ADO.

Please find the connection string here.

What exactly you mean by generate user's to my database ?

What is your database ?

Please find all that here.

Try using scheduled jobs, if your database is ORACLE.