debasisdas

You need to red [URL="http://www.visualbasic.happycodings.com/code_snippets/code9.html"]this[/URL].

I am not very sure what is the cause of the error. That version of VB is gone from my system long long back

I am confused from your post, can you please explain in detail what exactly you are trying to do. Are you using any specific tool for the purpose ?

(length of the string including space ) - (lenth of the string after LTRIM) = number of spaces in the start of the string. [code]Len("Visual Basic") - Len(ltrim("Visual Basic")) [/code]

This is how you [URL="http://bytes.com/topic/visual-basic/insights/641548-blob-save-image-database"]store[/URL] and [URL="http://bytes.com/topic/visual-basic/insights/641546-blob-retrieve-image-stored-database"]retrieve[/URL] image in Database. The code is for SQL server. You need to make some changes to do the same in Ms Access.

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..

what exactly you mean by [B]binary format[/B] ?

[QUOTE=javanew;1454299]Yeah things have changed,, and stop wasting my time to read your trash replies. Instead of making critics, you can just try to help a university student! And you the worst moderator i have ever seen, i am going to find a better forum ![/QUOTE] That sort of behavior is …

At first look this design seems to be too critical. Some tables can be merged. Needs dedicated time to provide a solution.

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

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.

I suggest the supplier part needs to be handled separately as that can't be managed in a single table.

I really do not understand the link between student_apps and posted_jobs via status_messages.

If you understand what a cipher text is and how to encrypt and decrypt data that should be quiet easy task for you. 1. Collect data 2. Encrypt (using algorithm ) 3. Store in DB 4. Retrieve. 5. Decrypt using reverse algorithm. 6. Use the record.

As a rule of thumb for deleting record form tables based on referential integrity . Step 1. Delete record from child table. Step 2. Delete record from parent table.

How enterprise edition of any version of any application can be free to use ? It must be either trial or limited period editions .

Why these button are there on my own post ? [B] Flag Bad Post Post Reply[/B] How useful are these for me ?

I really do not understand what is [B]the table is callable from other procedure.[/B]

You need to merge the fields of profile with user. Profile_id should be added to profile table.

Is that a paid job ? Waiting for your response.

You need to hit google with proper keywords. What you are asking for (index choice and every other database optimization related aspect ) comes with experience only and there is no rule of thumb for that. That varies from db to db based on use, data size , hardware implemented …

Hi Machete, Welcome to the forum. If you know how to copy and paste with little intelligence, your future is bright so bright. :)

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.

Do you know how to write SQL ? That will be the easiest solution for your problem.

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

Just try to use the built in login form in VB IDE. Simple modification will solve your problem.

Better start designing from scratch and keep adding new stuff as your requirements keep on changing.

Hi Don, Welcome and you have a nice time here at Daniweb.

Is that a paid job ? Waiting for your response.

You can simply try this logic. select count(*) from useraccounts where username = val1 and password= val2. if the above query returns 1 (as count). login should be successful and allow the user to proceed further else re-prompt for correct username and password(and repeat the same logic). For the above …

Why not solve that using a Procedure instead.

my dear, you need to read books for that.

You need to read [URL="http://en.wikipedia.org/wiki/Enterprise_resource_planning"]this[/URL]. No [B]11i[/B] is not a database like [B]11g[/B].

You need to position the control by resting its X, Y co-ordinates using trigonometric functions SIN and COS.

You need to connect to SMS gateway for that. Contact your telecom service provider for details. All that does not come free like mailing service.

try to write a script for this or a better option would be to write a cursor and then drop the tables .

The answer is a big NO. But there are couple of work around for the solution.

Hi Abellac, Welcome to Daniweb. But i am sure you are definitely not new to everything :)

Welcome to the forum. What you said is very true, there is really no age bar for learning. Hope you have a nice time learning new things.

Welcome to Daniweb.

Hi Brad, Welcome to Daniweb.

Hi Sam, Welcome to Daniweb.

Hi Rob, Welcome to Daniweb.

you need to find a function for the purpose.

Please find the details [URL="http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm"]here[/URL] and [URL="http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm"]here[/URL].

[QUOTE=;][/QUOTE] can you post the exact syntax that you are using for reference of our experts.

[QUOTE=;][/QUOTE] What did Google suggest ?

[QUOTE=;][/QUOTE] I think what you are looking for is Merge statement. [url]http://psoug.org/reference/merge.html[/url]

[QUOTE=;][/QUOTE] You need to write password protected macros for that .

[QUOTE=;][/QUOTE] First of all that version of oracle is desupported. If you still want that read some oracle 8i books, it is not possible to describe all that here.