Visual Basic

10-Mar-07 18:15

dBrong wrote:
It's either the line length or the size of the batch file. Anyone know of any constraints or a work around?

There are no limits in the Process class for the line length or the size of the batch file. Let's see the batch file and the code launching it.

Dave Kreskowiak
Microsoft MVP - Visual Basic

TopMost and TopLevel...

Daytona_67510-Mar-07 12:32

Daytona_675

10-Mar-07 12:32

Hiya,

Just a quick question, I've researched about this briefly but couldn't find anything that actually pinpointed what I'm doing wrong, or if in fact it is possible. I don't have any code because it's pretty general what I'm trying to do.

What I'm trying todo is this:

(Form A)
I have a form that is the main form of the application (only one instance at a time)

(Form B)
At some points in the application I launch another form that needs the users full attention, so is launched with ShowModal(). (only one instance at a time)

(Form n)
I have multiple other forms (similiar to stickey notes) that the user can open in the application. These forms I want to always stay on top of the main form. At the moment they are set to TopMost = True, which does work fine, but they stay on top of everything that is running on Windows. These are just shown using the Show() method. (multiple instances)

Problem is that if Form n (could be multiple ones) is already showing and I launch Form B (the one with ShowModal(), the Form n forms are on top of Form B.

I've tried having Form B set to TopMost as well - this works fine, Form B is now on top of all the Form n forms. Only thing is that it is also on top of all the other applications Windows is running which is not really what I want.

What I'm trying todo is have the z-order for all the Form n forms above Form A and the z-order for Form B should be above all the Form n forms, but not staying on top of all the applications running on Windows.

I'm thinking it has something todo with the TopLevel property of a form, but havn't found much document on this property, or I just havn't looked hard enough.

Hope this makes sense without any code samples, but it would be really hard to provide code for this - more of a concept and possible ways to accomplish this rather than just straight out asking for code.

Christian Graus10-Mar-07 12:39

Christian Graus

10-Mar-07 12:39

TopMost means on top of all other apps, even if you click on them. You can call BringToFront() to bring a window to the top, without making it topmost.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Daytona_67510-Mar-07 14:57

Daytona_675

10-Mar-07 14:57

Cheers for the reply,

Problem I found with that was then when the main form received focus, all the other forms (that should stay above the main form all the time) were no longer visible. Even if the main form has focus, the other forms should always be on top of it.

The only way I've found to do this is with TopMost, but it's not 100% what I want as it sort of crosses into other application interfaces, which is probably not a good idea!

I have taken a look at other applications and how they accomplish a similiar thing, and I think that I'm just going to redesign the process of displaying and accessing those multiple forms.

Anyways, cheers for the help, probably put this question on here before I had a good think about it!

TwoFaced10-Mar-07 15:09

TwoFaced

10-Mar-07 15:09

Try setting the owner property for each Form N. You can do this by passing the current form as a parameter when you call show (frm.show(me)). Or you can just set the property before calling show (frm.owner=me). "Owned" forms stay on top of the owner but won't stay on top of other application windows.

SQL query from MS Access on VB.net

Daytona_67510-Mar-07 15:46

Daytona_675

10-Mar-07 15:46

Hiya,

This is exactly what I needed! Only change I had todo is because the code that is creating each Form N doesn't exactly know about Form A (the main form of the app) - I can't exactly get a reference to it easily.

I remember seeing something in My.Application a while back and found that you could get a reference to the main form by using something like:

<br />
Dim OwnerForm as Form<br />
Dim StickyForm as frmStickyForm<br />
<br />
OwnerForm = My.Application.OpenForms("class_name_of_parent_form")<br />
If (OwnerForm IsNot Nothing) Then<br />
    StickyForm.Show(OwnerForm)<br />
Else<br />
    StickyForm.Show()<br />
End If<br />

Works exactly how I wanted it to - thanks for the help!

aslamshaikh0410-Mar-07 9:52

aslamshaikh04

10-Mar-07 9:52

In MS access i have an SQL query which depends on the other query to work. In VB.net i have got one of the queries to work.

SELECT idsBookingId, idsEmployeeId, idsCustomerId, idsCottageId, idsCottagePriceId, dteBookingMade, tmeBookingMade, dteArrival, dteDeparture,
dtePaymentDue, curTotalPaymentAmount, dtePaymentMade, txtBookingNotes
FROM tblBooking
WHERE (dteDeparture >= ?) AND (dteArrival <= ?)

This gives me which cottages are booked with the given date ranges.

What i need is to see what cottages are available. In Acess this code worked for me:

SELECT tblCottage.idsCottageId
FROM tblCottage LEFT JOIN qryCottageBooked ON tblCottage.idsCottageId=qryCottageBooked.idsCottageId
WHERE qryCottageBooked.idsCottageId Is Null;

It calls up the qryCottageBooked. I cannot call up the query in vb.net

Re: SQL query from MS Access on VB.net

Dave Kreskowiak11-Mar-07 4:12

11-Mar-07 4:12

It should work without a problem. We'd probably have to see the code that's launching this query. Also, you might want to put these queries in the Access database and just call them by their name (usually referred to as "stored procedures"), to make your like bit easier.

Dave Kreskowiak
Microsoft MVP - Visual Basic

connectivity with oracle

vishal dhir10-Mar-07 8:49

10-Mar-07 8:49

hi to all!!
please guide me how to make connectivity of oracle 10g with vb 6.0

mdi form

vishal dhir10-Mar-07 8:47

10-Mar-07 8:47

hi to all!!
please guide me what is the functioning of mdi form in vb 6.0

Re: mdi form

manni_n11-Mar-07 0:24

manni_n

11-Mar-07 0:24

well i use dot net so i am not fully familiar with vb MDI form..
but i knw a bit.
its jst first start the window application, nw u'll be having a form in it, delete it.
now add an MDI form in it through add item. this will be MDI parent form
add one more normal form say form2
go to property of that form make Ismdichild as true
Now place a picture box on MDI form it.
place a button on that pic box..
under clickin event of that button, code
dim a as new form2
a.show()
now your form2 will be displayed in the place remained on MDI parent form(Pic box is also on MDI parent ) .
bye ...

Re: mdi form

Dave Kreskowiak11-Mar-07 4:09

11-Mar-07 4:09

"MDI" stands for Multiple Document Interface. It's made up of a MDI Parent form that has multiple MDI Child forms displayed in it. The user can work on multiple "documents" at the same time inside the same instance of the application. It's alot like how Word and Excel used to be.

Dave Kreskowiak
Microsoft MVP - Visual Basic

deployment

vishal dhir10-Mar-07 8:44

10-Mar-07 8:44

hi to all!!
can anybody tell me how to make executable set up for a project done in vb so that it can run on any machine
thanks in advance!!!

Re: deployment

A*****10-Mar-07 11:49

A*****

10-Mar-07 11:49

What version of vb.net are you using?

FOR VB.NET 2003(any version)
If you are using vb.net 2003 then the users computer will have to have .net1.1 framework installed(otherwise the program won't run)
But if the users computer is connected to the internet then if the .net1.1 framework is not installed on the users computer then when the setup file for the project is run it will ask the user to install .net1.1 framework.

FOR VB.NET 2005(any version)
If you are using vb.net 2005 then the users computer will have to have .net2.0 framework installed(otherwise the program won't run)
But if the users computer is connected to the internet then if the .net2.0 framework is not installed on the users computer then when the setup file for the project is run it will ask the user to install .net2.0 framework.

Hope this helps!

Re: deployment

vishal dhir10-Mar-07 19:38

still having problem: backup using vb.net

10-Mar-07 19:38

sir it is visual basic 6.0

Re: deployment

A*****10-Mar-07 19:51

A*****

10-Mar-07 19:51

That changes things than i haven't used the setup project part in Vb6 but i know that most computers should have the Vb6 framework on them so you should be able to run your program on any computer no trouble.

shreya12310-Mar-07 3:00

shreya123

10-Mar-07 3:00

i am working on project online testing system using vb.net as frontend & oracle as backend. i want to add backup facility in my project .for this i need to create a stored procedure in oracle.can someone guide me to create the procedure because i have no idea about it.

Re: still having problem: backup using vb.net

Dave Kreskowiak10-Mar-07 3:59