Posts by debasisdas

create two tables and link them by using primay key and foreign key.

very very emotional

496

one of the best servering moderator .

So i give you 9.

-1008

bill

see this beautiful world.

harry potter --> the wizard

Bangalore, India.

try to create the package using package and deployment wizard to use the application on naother system, instead of simple exe file.

you need to convert the data in text format to date format and then sort.

may i know how can i help you. but do not expect me to write any code for you .

can you post what you have tried so far .

I think you heard of that recently. I have that component with me for years now.

1.what about simply formatting that using some string function. why not simply take the system time instead of entering the time. that way no one can enter wrong time.
2.you need to code in change event not lostfocus.
3.i dont understand your question.

flexgrid for dataentry ?

why so ?

what is the use of textbox then ?

you can't assign a value to the dtpicker control. You can only read a value from the control,infact you can change other properties like mindate and maxdate.But value is a readonly property of the control.

is that throwing any error or simply not functioning ?

1. you need to declare the variable as public in a module (.bas file).
2.timers are not visible at runtime ,so what is the problem.
3.right click on project ans add module. it has no UI but only code window.
4.what is the problem with MDI ?
5. that should work for you.

you need to code the text_change event of the textbox.
and calculate the length.
once length reaches the desired length set focus on to the next control.

what did google say ?

is that throwing any error ?

you need to run the sql statements as script

try to register the componenet with windows by using REGSVR32 key.

you need to format the time value properly before processing.

everything is possible ,but nothing happens automatically. You need to code that.

you need to use excel library for the purpose.

you can do that in acess.

donot use DATE as a field name ,that is a datatype in database .

you need to handle that form your application

what is the problem with IF ?

make the field as primay key or add a unique constraint on the field or define a composit key.

I work for money.
If you want loyalty-hire a dog.

now i learn that i must go to bed now ,almost after 15 hrs with my notebook.

using DOEVENTS just might help you .

if you have any of those agents/tools installed on your system ,its componenets must be in your system as well. the to access those from project------>componenets menu of VB ide.

then why not insert the third field also by concatinating the 1st and the 2nd value . still you have to enter 2 values only.

here no one waits for anyones questions to reply. all those who help other s are volunters and are not and can't be forced to reply to any questions, and all those who viewed your question are not necessarily experts or have any knowledge about what youa re asking.

i do not open each and every file i come across in net ,sorry .

so what is your problem ? any errror with your code ? i think this question should have been in the .NET forum not here in the traditional VB forum.

you just need to follow the wizard. do not forget to add the database file also along with the package.

you might to to use some of the compressing/de-compressing agent components for that.

please find related discussions here and here.

you need to update the third field by concatinating field1 and field2

use this for system IP

msgbox winsock1.LocalIP

Try to use WINSOCK component for the purpose.

Try using this

con.begintrans  'con--adodb connection obejct
con.execute "insert statment of data selected from oracle database"
con.committrans

what about defining a separate procedure / function for your required functionality

you need to create views based on access tables.

it is always better to store those in database for security reason.

i hope the above psot solved your problem.