nlarson1114-Nov-06 6:08

14-Nov-06 6:08

Me.Label1.BackColor = System.Drawing.Color.Transparent

Tip:

whenever you change a controls properties from their default in the design mode, the change is added to the form's designer for that control. so you if you put a label on your form and change it's background color, go look at the form designer and see how the ide did that. then use the same command at runtime.

Nathan

-- modified at 13:52 Tuesday 14th November, 2006

Re: Transparant background

Syed Shahid Hussain15-Nov-06 6:21

Syed Shahid Hussain

15-Nov-06 6:21

Hi Friend

I really appreciate your assistance and i really like your Golden tip. Gooooooooooooooooooooooooooooooooooooooooooooooooooooooooooood work Blush | :O

Regards

Syed Shahid Hussain

BindingNavigator

Joe Programm3r14-Nov-06 4:55

Joe Programm3r

14-Nov-06 4:55

Greetings All:

The issue is that when I execute the Fill method during a button's onClick event, it works fine. But when the Fill method is executed when a boolean propery is updated, the code executes but never populates the binding navigator.

Here's the code snippets in question:

Here's what works:

Private Sub FillToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillToolStripButton.Click <br />
Try <br />
Me.SpEDMS_EnumNIOSHByStudyTableAdapter.Fill(Me.Dataset_frmPerson_NIOSH.spEDMS_EnumNIOSHByStudy, New System.Nullable(Of Integer)(CType(glStudyId, Integer))) <br />
Catch ex As System.Exception <br />
System.Windows.Forms.MessageBox.Show(ex.Message) <br />
End Try <br />
End Sub

Here's the same code in the 'propery set' that executes but the navigator never shows any data

Private _QueryNIOSH As Boolean <br />
Public Property QueryNIOSH() As Boolean <br />
Get <br />
Return _QueryNIOSH <br />
End Get <br />
Set(ByVal value As Boolean) <br />
_QueryNIOSH = value <br />
If value Then <br />
Try <br />
Me.SpEDMS_EnumNIOSHByStudyTableAdapter.Fill(Me.Dataset_frmPerson_NIOSH.spEDMS_EnumNIOSHByStudy, New System.Nullable(Of Integer)(CType(glStudyId, Integer))) <br />
Catch ex As System.Exception <br />
System.Windows.Forms.MessageBox.Show(ex.Message) <br />
End Try <br />
End If <br />
End Set <br />
End Property

Why does it work in one part of the form but not another? Any ideas?

VB6 in VB.Net???

azmir1014-Nov-06 2:14

azmir10

14-Nov-06 2:14

Is there okay for me to use VB6 script in VB.Net?
Do I need to change the language of my program?

Thank you

SaM

Re: VB6 in VB.Net???

nlarson1114-Nov-06 3:22

nlarson11

14-Nov-06 3:22

I guess the question is "is it ok with who". if go through the conversion wizard vb.net will tell you what's not compatible and force you to find the equivalent code.

Saving bitmap to JPG in Compact Framework 2

Ostrich2214-Nov-06 1:46

Ostrich22

14-Nov-06 1:46

I've been on the MSDN and it has example code on how to save an image to jpg format, they say its compatible in the Compact Framework 2 but it doesn't seem to work. Here is my Code:

Dim img As Bitmap
img = New Bitmap(PictureBox1.Image)
img.Save("Bob.jpg", ImageFormat.Jpeg)

The PictureBox1 contral has a picture already. if I try save it as a BMP there is no problem. but to any other format it system returns a nonreferenced Exception.

Any Help would be greatly appreciated.

Thank you

In Vb Wininet problem

psiva198414-Nov-06 1:21

psiva1984

14-Nov-06 1:21

I m Developing an Ftp appplication which Uploadfiles .
I got a problem that when files r uploading ,when internet connection fail's
application got hanged for few mins.(i worte that if internet connetion failed than restart. even though appliction gets hanged and restarted for few mins)
how to solve.Why it is Hanging?
Pls Help me.

Re: In Vb Wininet problem

MatrixCoder14-Nov-06 9:57

MatrixCoder

14-Nov-06 9:57

Are you using a Try Catch statement to upload your files?

Re: In Vb Wininet problem

psiva198414-Nov-06 18:59

psiva1984

14-Nov-06 18:59

no i m developing in vb6.0 and not using try catch
tx for u r reply but pls help me

Re: In Vb Wininet problem

psiva198416-Nov-06 19:32

psiva1984

16-Nov-06 19:32

no i m developing in vb6.0 and not using try catch
tx for u r reply but pls help me

windows service question

Saleh_cs14-Nov-06 0:57

Saleh_cs

14-Nov-06 0:57

hi every body,
I am saleh from jordan, and i try to run exe file from an windows service,
and i try to use shell command and it is work but open the file as service
(hidden) and i want it shown for user.
Thanks

Eng.Saleh Alsaleh E-tech-Systems
www.etech-systems.com
ssaleh@etech-systems.com

Best Regards,

Saleh Al-Saleh
Software Engineer
MCSD.NET
------------------------------------------------
e-Tech Systems
Mobile +962 7 88551452
Office +962 6 5152172 Ext. 248
Fax +952 6 5160725
E-mail Ssaleh@etech-systems.com
Web www.etech-systems.com
------------------------------------------------
Thinking PAPERLESS, Think e-Tech

Re: windows service question

MatrixCoder14-Nov-06 9:59

MatrixCoder

14-Nov-06 9:59

Try this:

Shell("C:\Path\File.exe", AppWinStyle.NormalFocus)

Set password on existing excel application

zenithmaximus14-Nov-06 0:05

zenithmaximus

14-Nov-06 0:05

Hi,

I've been trying to set security password on a existing excel, and been trying these codes:
Im Using COM for Excel 5.0

Public myExcel As Excel.Application
Public myBook As Excel.Workbook
Public mySheet As Excel.Worksheet

myExcel = CreateObject("Excel.Application")
xlsFilename = "C:\samp.xls"
myBook = myExcel.Workbooks.open(xlsFilename)
myBook.SaveAs(xlsFilename, password:=txt_password.Text)

error that i'm getting is "Member not found" and points
to
myBook = myExcel.Workbooks.open(xlsFilename)

when i try to look at the intellisense after workbooks. the only thing that appears
is Gettype.

Any other approach? or recommendation for this would be appreciated.

Thanks.

-::maximus::-

Re: Set password on existing excel application

Ostrich2214-Nov-06 1:39

Ostrich22

14-Nov-06 1:39

In office XP I do it like so:

xlSheet.Protect(Password:="SomePassWord", _
DrawingObjects:=True, _
Contents:=True, _
Scenarios:=True, _
UserInterfaceOnly:=True, _
AllowFormattingCells:=True, _
AllowFormattingColumns:=False, _
AllowFormattingRows:=False, _
AllowInsertingColumns:=False, _
AllowInsertingRows:=True, _
AllowInsertingHyperlinks:=False, _
AllowDeletingColumns:=False, _
AllowDeletingRows:=True, _
AllowSorting:=True, _
AllowFiltering:=True, _
AllowUsingPivotTables:=False)

Its not necessary to have all the following settings, but I like to leave them there

Re: Set password on existing excel application

zenithmaximus14-Nov-06 14:39

zenithmaximus

14-Nov-06 14:39

Office XP has Interop, but im running this application in NT...
if I can have it work without installing DLLs would be much better.

-::maximus::-

Trouble with Form and Show() method

RainFox13-Nov-06 23:30

RainFox

13-Nov-06 23:30

Hi
I'm trying to just display a simple form to inform the user to please wait while some things are happening in the background. Here are some snippets of my code:

------------------------------------
Dim WaitMessage As New Form2
WaitMessage.Label1.Text = "Please wait while the data is being gathered..."
WaitMessage.Show()
'....some database access going on....
WaitMessage.Close()
------------------------------------

What pops up though is the window, but the label is white and doesn't display the text. If I test this with WaitMessage.ShowDialong() instead of Show(), the form and the label displays perfectly, but off course the background database stuff cannot happen while the form then has the focus.

Any ideas??

RainFox - cunning, with some cloudy clueless moments, yet cool and fresh Rose | [Rose]

Re: Trouble with Form and Show() method

Leah_Garrett14-Nov-06 0:30

Leah_Garrett

14-Nov-06 0:30

This can happen when you application is busy working and not updating the user interface. A good solution here would be to use the backgroundworker to execute the database access in the back ground while you display the message.

I have done this at work basing my code on an example I found at MSDN:
http://msdn2.microsoft.com/en-us/library/system.componentmodel.backgroundworker.aspx[^]

Re: Trouble with Form and Show() method

MmM.net</

14-Nov-06 0:47

MmM.net</

14-Nov-06 0:47

try to use application.doevents
it may works

Dim WaitMessage As New Form2<br />
WaitMessage.Label1.Text = "Please wait while the data is being gathered..."<br />
WaitMessage.Show()<br />
application.doevents<br />
'....some database access going on....<br />
application.doevents<br />
WaitMessage.Close()

Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer

Re: Trouble with Form and Show() method

RainFox14-Nov-06 23:16

RainFox

14-Nov-06 23:16

Hi
Thanks, that did the trick. The second "application.doevents" wasn't necessary before closing the form though.

Thanks again!

RainFox - cunning, with some cloudy clueless moments, yet cool and fresh Rose | [Rose]

Help needed for datatable printing in vb.net?

TC2813-Nov-06 23:06

TC28

13-Nov-06 23:06

Dear All,

any one can help to generate reports from dynamically created datatable.
In my project i am creating datatable after processing some data and load this data in to datagrid. now when user click on print button, i want to print this grid results to printer?

How can i do this? Please help urgently..

Re: Help needed for datatable printing in vb.net? [modified]

Duncan Edwards Jones14-Nov-06 1:27

Duncan Edwards Jones

14-Nov-06 1:27

Put the data table in a datagrid and use one of the many "How to print a data grid" articles (including this one[^] by me) from this site?

-- modified at 8:55 Sunday 19th November, 2006

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Re: Help needed for datatable printing in vb.net?

PlayByTheRules14-Nov-06 4:22

PlayByTheRules

14-Nov-06 4:22