Printing a Form - Visual Basic Discussion Boards

First Prev Next

Re: Unload Close Command

Dave Kreskowiak26-Oct-06 18:02

Dave Kreskowiak

26-Oct-06 18:02

Check out the Form.Closing[^] event, complete with a sample of what you want to do.

Are you really sure you're an "Ultra" coder? Big Grin | :-D

Dave Kreskowiak
Microsoft MVP - Visual Basic

Resolving Excel Open Processes after ADO Connection

pao_e_vinho26-Oct-06 8:57

pao_e_vinho

26-Oct-06 8:57

Hi
I need some help with this piece of code bellow.
I'm extracting pieces of information from Excel throug the following ADO connection.
This is a piece of VBA code implemented inside Access.

[code]Dim con As ADODB.Connection
Dim rs As ADODB.Recordset

Set con = New ADODB.Connection
With con
.CursorLocation = adUseClient
.Mode = adModeRead
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=E:\ExcelFileTool.xls" & _
";Extended Properties=""Excel 8.0;HDR=Yes"""
.Open
End With

Set rs = con.Execute("SELECT Site FROM [Clients$] WHERE Site = 'SiteOne'")
Debug.Print rs.Fields(0)

rs.Close
Set rs = Nothing

con.Close
Set con = Nothing [/code]

This code is part of an Access Module and it's inside a loop process. The problem it's related with Excel processes are kept open in the memory.

I'll try to explain the best I can, and sorry about my bad english.

If I run this piece of code without the Excel file opened, everything runs Ok.
But when I run the code with the Excel file in question opened (and I need it opened for other reasons), every loop will increase the Excel process memory about 250KB plus (I see it in TaskManager), and there's more.

When the loop ended, even closing the opened Excel, the Excel Process keeps open on the TaskManager.

The 250KB increasing is very problematic because this macro will run thounsands of loops per day.

Thanks
P&V

VB 2005

Pete Newman26-Oct-06 8:52

Pete Newman

26-Oct-06 8:52

I have a vb2005 logon.aspx page and i have on that page i have the standered System.web.UI.WeControls.login. what im trying to find out is how to dynamicly poition the control in the centre of the page

I really do need help..... all this computer stuff is way over my head !!

TextBox Property

andy3826-Oct-06 7:38

andy38

26-Oct-06 7:38

Hi, using VB net(2003) I have 2 questions. First how to change dynamically the property of textAlign in a textBox, see my ex: property of textAlign in the textBox1 is already set to the right, what I would like to do is when I change the value in that txtBox would be that data move to left, and after I finish then hit tab button on keyboard data move back to the right. My second question is how to set a value like zero 0 as a default in that same textBox only when that textBox is empty. Thank you in advance for your help.

Re: TextBox Property [modified]

AlexeiXX326-Oct-06 8:21

AlexeiXX3

26-Oct-06 8:21

You just need to capture the events: Enter and Leave
This code might help you:

<br />
    Private Sub TextBox1_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.Enter<br />
        Me.TextBox1.TextAlign = HorizontalAlignment.Left<br />
    End Sub<br />
<br />
    Private Sub TextBox1_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.Leave<br />
        Me.TextBox1.TextAlign = HorizontalAlignment.Right<br />
    End Sub<br />

If you are using this code many times, you might wanna implement this code in your custom textbox, so you wont have to repeat this code for every textbox you have in your form.

-- modified at 16:54 Friday 27th October, 2006
Dave Kreskowiak (Below) is very right, For your second question, capturing the TextChanged Event would fire the same event again.
If you explain a little bit more about what you are trying to do, maybe someone could give you the best way of doing it.

Alexei Rodriguez

Re: TextBox Property

ADY00726-Oct-06 8:56

ADY007

26-Oct-06 8:56

you can use this:

Private Sub Textbox1_TextChanged(byval .....)
if Textbox1.Text = "" then
Textbox1.Text = "1"
End if

Regard,
Adrian

Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.

Re: TextBox Property

Dave Kreskowiak26-Oct-06 10:02

Dave Kreskowiak

26-Oct-06 10:02

That won't work because it will continuously fire the TextChanged event. If you change the Text property in the TextChanged event handler, you have to take precautions to tell that your in the handler a second time.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Printing a Form

dptalt26-Oct-06 7:00

dptalt

26-Oct-06 7:00

Is there a way to print a form to a printer at runtime?

Re: Printing a Form

Dave Kreskowiak26-Oct-06 7:56

Dave Kreskowiak

26-Oct-06 7:56

A little search on MSDN for "printing a form" reveals this[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Printing a Form

dptalt26-Oct-06 8:25

dptalt

26-Oct-06 8:25

Hey thanks!

Delete key in table fields doesnt work?

Muntyness26-Oct-06 6:46

Muntyness

26-Oct-06 6:46

I have access to a program, in which all of the text editing is done through table fields.

However the Delete key doesnt delete text. Only the backspace key will delete text.

Also, Ctrl-C/CtrlV is spotty at best.

Any ideas as to what might cause this?

Re: Delete key in table fields doesnt work?

Dave Kreskowiak26-Oct-06 7:54

Dave Kreskowiak

26-Oct-06 7:54

Is this an app you wrote or you're using??

You question sounds like it's one you're using, in which case the answer would be because the developer didn't add support for the Delete key, or removed it, depending on the control he/she used.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Delete key in table fields doesnt work?

Muntyness26-Oct-06 23:35

Muntyness

26-Oct-06 23:35

It's an application I'm using, but I have access to the source code, so I can change it if I need to.

From the looks of it, the controls used are PropertyGrids and DataGrids.

How do I declare a class as a collection in VB

Sean_B26-Oct-06 5:15

Sean_B

26-Oct-06 5:15

Hi,

I'm fairly new to vb.net and I'm trying to declare a class that is a collection of another class.

I believe this is possible in c# using syntax like the following

public class myList : List<myItems>

I'd be very grateful if any one can tell me the answer, even if it is that you can't do it in VB.

It makes the code a lot easier if you can refer to the list within the class as "me."
, also I'd like to be able to refer to some of the data types I've declared in myItems within myList

Thanks

Sean

Re: How do I declare a class as a collection in VB

mr_lasseter26-Oct-06 6:29

mr_lasseter

26-Oct-06 6:29

Public Class myList : Inherits List(of myItems)

Keep in mind the only thing you can now add to the collection is objects that are of type myItems.

Mike Lasseter

Re: How do I declare a class as a collection in VB

Sean_B26-Oct-06 7:26

Sean_B

26-Oct-06 7:26

Thanks Mike,

greatly appreciated.

I'd tried inherits and : but not both together !

Sean

Sean

Re: How do I declare a class as a collection in VB

Dave Kreskowiak26-Oct-06 7:49

Dave Kreskowiak

26-Oct-06 7:49

A colon is just a statement seperator. It has nothing to do with declaring a class or inheritance. You can do the exact same thing like this:

Public Class myList
    Inherits List(Of myItems)

Dave Kreskowiak
Microsoft MVP - Visual Basic

Voice Over Ip

Kofiwusu26-Oct-06 5:13

Kofiwusu

26-Oct-06 5:13

i'm a new member here and was wondering if y'all can help me with this project i'm about to start? i want to write a program that will track phone call durations on a landline using either visual basic.net or VB6. i want to ask if this is possible and how to go about things.
thanks everybody.

kofiwusu

Re: Voice Over Ip

Dave Kreskowiak26-Oct-06 7:44

Dave Kreskowiak

26-Oct-06 7:44

On a land line? This isn't Voice over IP. VOIP is a phone call made over an IP network.

If you're talking about a land line, how is the machine going to know that the phone was even picked up? Or are you talking about some other hardware setup?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Voice Over Ip

Kofiwusu26-Oct-06 22:59

Kofiwusu

26-Oct-06 22:59

thank you very much, i guess i didnt know the difference. i'm talking about the land line. i'm talking about how the machine is going to know about when the phone is up, duration and very thing. let me tell you what i really want to do:
I'm a student at the catholic university in Ghana, west africa, i want to use either visual basic 6 or .net to write a program for my project work. i want to write a program on monitoring phone calls (landline) using a pc. i'm thinking the program should be able to recognize the number been dailed, duration of the call so that i can use it to calculate the cost, also record incoming calls. i have done visual basic 6 and .net not into details but i hav no idea on how to start this project. anyway u can help me i'll be very grateful.

event handler

Smithers-Jones26-Oct-06 4:07

Smithers-Jones

26-Oct-06 4:07

vb.net

how do i remove an event handler from a control, when i don't know, which one is currently connected to this control?
depending on the situation, i want to add different handlers to a button, and before adding a new one, i have to remove the old one.

Re: event handler

The Man from U.N.C.L.E.26-Oct-06 6:48

The Man from U.N.C.L.E.

26-Oct-06 6:48

The only way to do this is to take control of all event handlers yourself.

1. Remove all the Handles clauses that the designer puts in.
2. Explicitly define all your handlers using AddHandler.
3. Before adding new handlers always use RemoveHandler to remove all the handlers.
(It does not matter if the handlers are not added when you call remove)

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)

Re: event handler

Smithers-Jones31-Oct-06 3:19

Smithers-Jones

31-Oct-06 3:19

thanks

displaying picture in crystal report

aransiola25-Oct-06 23:55

aransiola

25-Oct-06 23:55

I am writing a vb6.0 program that stores Pictures and Signatures in SQL Server 2000 database. I am also using the Crystal report viewer from cr8.5 for my reporting.
I want to display & print teh stored Pictures on my report
please any help to archieve this

t.aransiola

Problem in LIstView grouping feature

MAP Tiger25-Oct-06 22:02

MAP Tiger

25-Oct-06 22:02

Hi guys

I am working in VB.net 2005 and using group feature too.

The problem is that it doesnt refresh the group headers when scrolling horizontally i.e. the group header is more wider then the data displayed on screen at the start of the application. So to see the remaining data if user scroll the listview horizontally n of course other than items group header is also at that offset screen area so items are ok with that scrolling but header doesn't display until the control is scrolled vertically.

Someone plz guide me for this asap.

thanks...

MAP Tiger
Tiger Softwares

Software Designer and Developer
VB.NET, ASP.NET, VFP

Last Visit: 31-Dec-99 18:00 Last Update: 3-May-24 21:32

Refresh

ᐊ Prev 1...3070 3071 3072 307330743075 3076 3077 3078 3079 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.