Search:

Alright thanks I think the best thing for me to do woudl be to go through some tutorials and try to figure out how I can write something to implement this.

Hi

I would really like to try this module out but need help please.
Using Excel and/or Access how can I make use of this module?

Thanks in advance

Thanks fellows

I have used the Unload Me since this better suits my application (as I need to initialize everything and begin a new instance). But I would take RobDog888 advice and try desiging...

Thanks a lot RobDog888

Thats a great idea but I would actually want to implement a way so that the load event is triggered so I was just thinking weather there was I could "Unload" the form. I...

Hi

I am writing a program where I call one form from another usign the form.show function. I have noticed that usign that function it actually just makes the form visible but does not load it...

Hi

Could anyone please tell me how to store a certain index value in an integer?

I am trying to retrieve the index of the selected radio button from an array of radio buttons.


Thanks

i am using windows authenticated login... where i use a blank password to log into windows..

could someone please tell me the syntax of the connection string please ?

thanks a lot .. that error is gone...

now its telling me that the log in has failed. i suppose i need to give it te user name and the password.

could you please tell me how and where in the...

Error: an attemp to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bank.mdf failed. A database with the same name exists, or specfied file cannot be...

Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName= C:\Program...

thanks

i've tried this


Provider=SQLNCLI;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;

but what should i put in the place of a provider..??

Could you please tell me how I can connect VB6 with SQL 2005 server via ADODB.


Does anyone know what connection string to use to connect to the database (mdf files)?


thans

Thanks a lot
You have been very kind to actually take the time out to do all this but I have by now completed my whole software and for the date entry I have used masked edit control. I would...

Al right ... my apologies

It would have been easier if DigiRev emphasized on it ... I didn't absolutely realize. Thanks a lot DigiRev .... my application is running just fine

Thanks to ala for replying. My thousand thanks to randem now that my problem is solved. I made an installation package ans it can be installed anywhere and run. Thanks a lot randem for also taking...

As I've already said that I'm sure my database works just fine becase I can make changes to it through other forms and yes I have made use of the App. function and my database resides exactly where...

You see I'm sure the OCX files are registered I mean I have exactly copied them to the folders where they resid in my desktop. If the OCX files were not registered the application would have thrown...

I have developed an application that works fine in my computer with no error what so ever.

I made an executable to run that in my laptop with no VB installed in it. I am have used MS Acess 2003...

hey thanks

that is what I wanted to know

I used to know a way where I can get rid of the close button on a form (on the upper right hand corner) but I just cant remember it. I don't want to use the "Border Style Non" from the Properties...

Hey thanks a lot ZenDisaster, I really appreciate you taking the time out again to explain it.

Sorry, I just woke up and found your post.

That is now a lot easier to understand.


Regards

Thnaks alot ZenDisaster

That is a lot of code.

Regards

Can someone tell me how can I make a window stay "ALWAYS ON TOP" of other windows?

Thanks

Hey

Thank you so much guys. Both of the replies were exactly what I was looking for. Thanks a lot Bruce Fox for the detailed code this is definitely going to help me a lot and thanks MarkDorf for...

Hi

Could anyone please tell me how I can disable (or set an action in) the CLOSE button on the upper-right hand corner of a window?


Thanks alot

Thanks to both of you and thanks a lot lintz for the piece of code and the idea. Below is the code that I've used.


For Each frm In Forms
If frm.Tag <> "Main" Then
If...

Thanks lintz

I'll try that right now

Yea thanks gavio

but that is exactly what I need to know

How can I loop throufh the froms collection, could you please tell me?

Hi

Could anyone please tell me how I can build a function
that would "check weather all the MDI Child Forms were hidden/closed"
and then return a boolean value YES or NO.


Thanks alot

Thanks Merri

I absolutely forgot that. It solved the problem


Regards

Could any one please tell me how I should convert a given string into date format to store and retrieve from the database?

I dont want to use any date pickers so I have created a masked control...

Hi guys


Thanks alot for all the replies.
i tried not usinf IIF functin but nothing else seems to work.
This is how I finally got it to work:

chk(i).Value = IIf(tbl(i, 0) = "True", 1, 0)

Thanks DigiRev

What I needed was the IIf function. Sorry didnt reply u earlier as I just woke up.

Thanks a lot my friend

RhinoBull was right ... using only ABS works just fine.

But now I've got another problem .... I cant read the string values (Yes/No) directly into the check box/s value.

Any suggestions?

Thanks alot guys, taht was quite helpful. I think I might use DigiRev's way with the convertion since the checkbox only accepts 0 and 1. I might as well need ganeshmoorthy's way since i'll be readign...

Just a quick question

Can anyone tell me how i should convert a boolean value into integer?

I need to use that value in a checkbox


Thanks

Thanks everyone for replying to my post and especially to sessi4ml.
I have solved my problem. The error was in the SQL here is the one that i've used


SQL = "Select * from Trade, ChkLType,...

Thanks sessi4ml
I tried removing but it still gives the same error. I would anyways nwws the Question table since the last field belongs to that table.


Could you tell me weather the debug.print...

I am sorry I'm sorry but somehow i dropped the comma (,) when pasting the code. There are three different tables:
Trade, ChkLType and Question

SQL = "Select * from Trade, ChkLType, Question...

Can anyone please check and tell me weather my SQL is grammatically alright?


SQL = "Select * from Trade ChkLType, Question where (Trade.Tid = " + searchID + " AND " + _
"Trade.TID =...