Posts by debasisdas

Leadership and learning are indispensable to each other.

try to use the microsoft commondialog control and use SHOWOPEN method to open any file and display the same in any picture box or any richtextbox.

Try to establish a composit key using keys specified as suggested in the previous post.

If you still have any doubts ,please do post back.

As per rules of normalization ,that sounds good but in most of the cases we have to de-normalize the database to avaoid un-necessary complexcity. You can go with the structure and always there is room for improvement. Different people have different openion on the same scenario, and this is my personal view only.

A rose by any other name would smell as sweet.

it seems to be a good design following norms, but all depends on what is the logic you are going to implement on that. How youare going to use that is more important , on which i have no idea. It might happen you have to make some minor changes later on.

it would be better to store the tags in a separate table and maintain relationship by tagid or somthing that is more suitable according to the condition.

thats OK ,but u have mentiond only PK ,what about foreign keys .
you have not mentioned how are you maintaining ralations.

what exactly u want to know is access.
If u want tto create on e thats so easy .It is a GUI tool u wont face any problem.
If u have any basic idea if database (not access) ,you should be able to easily work with that.

You will never "find" time for anything.
If you want time, you must make it.

Yes that is also a good one and is available locally.

Pllease specify your requirment clearly.
Do u want to load the data of all the three columns into a single listbox.
or you want only to display the records, in that case u can use any grid control.

Ok i will complete the rest for you.

saying somthing nice to my Dude.

that looks good.
have to take a try.

Do not follow where the path may lead.
Go instead where there is no path and leave a trail.

Ok you run and I will escape.

There are plenty of availabe in the market. you can gop for any one which suits yoyr requirments. I would suggest to go for the black book or any copy from a good publication house like WROX or TMH.

If dont think any one is still using DAO.
If one does he /she is simply dumb.

what if the the table2 contains more/different columns than the table1 ?
you have to specify the column name
Your code will work if both the tabels are having same structure.

If u want to use features of excel or handle wilr excel fiels any way u need to include the components in your development system.
Else there is only option left for you as AV said i need to write all that by your self if u can.
and I will also purchase that product from u with full license.

when u create the set up using package and deployment wizard , it will automaticall include all the .dll ,.ocx and other required files with the set up. All these files will be installed in the target system at the time of installation. So it is not necessary to install Excel in that system. your application will work fine.
But the only problem is u will not get an Excel file to work on.

Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
 
Private Sub Command1_Click()
con.Open "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=debasis;Persist Security Info=True"
rs.Open Text1.Text, con, adOpenForwardOnly, adLockOptimistic
Dim str As String
If Dir("c:\data.txt") <> "" Then
Kill "c:\data.txt"
End If
Open "c:\DATA.TXT" For Append As #1
Do While rs.EOF = False
For i = 0 To rs.Fields.Count - 1
If i < rs.Fields.Count - 1 Then
str = str & IIf(IsNull(rs(i)), "null", rs(i)) & Chr(9)
Else
str = str & IIf(IsNull(rs(i)), "null", rs(i))
End If
Next
Print #1, str
rs.MoveNext
str = ""
Loop
Close #1
rs.Close
con.Close
End Sub

After all the fight between both of you ,why not also post some RDO code.
That can help a some users.

Try using the function MID()

Set the button's Style Property to Graphical .
and then set the backcolor property of the button.

It's your aptitude, not just your attitude that determines your ultimate altitude

the user2 will still access the old data till the user1 executes COMMIT.
To avoid this user need to lock the table / record before executing any UPDATE command.

thanx for self learning, that really helps a lot.

do you want to trap mouse co-ordinates any where on the screen ?

The future belongs to those who believe in the beauty of their dreams.

put the timer on the MDI forn using any container control and run the search code the timer_timer event at the interval you want.

u need to frame the connection string at runtime.
but for that connection should not be opened.

can do that for ex at form load.

from vb6.0 u can connect to all versions of ACCESS.

then what are you waiting for ?

is it such that the number of delimerets can can in every string

then u need to write a sub-routine for that.

please specify exactly what u want to do in your project.

before you develop your peoject and i suggest you anything my i know what are the programming languages that you know,which can be used as frontend . and as u said u will be studying oracle ,it means u also have few or no idea of oracle it self. In this conditions i am confused what to suggest you . One thing i can suggest to you is first go through the languages and database (oracle) . AFter taht you can develop any project you want.

oh god
that is the funniest think i have ever heard any one trying in my entire carrier.

dear EXE file are not created like you have tried(smart try) .You need to write some code and compile it to make an Executable.
someday you will also learn that.

People do not lack strength; they lack will.

where is the zip file

it shows only the JPG file as attachment.

ok let me check it first

please check for the path

ok let me check

You can directly use the API PlaySound to do that .
No need to write all that code.

All the flowers of tomorrow are in the seeds of today. :)

there are 10 types of people

those who can understand this and those who can't.

not a bad suggestion

i have to be infront of the monitor, because that earns me my bread and butter.
I don't like to watch TV.
In my free time i smoke, smoke and smoke a lot.

VB 2004 and 2006 .........

my god what is that.

some one please tell this boy this forum is for VB 4.0 / 5.0 / 6.0 not for 2004,2005 2006