Recent content by Camel

Hello Experts, I am new to the DTS (so please excuse me if the question is very silly) and so far it is looking like a very handy tool. In one of my projects I have to import some data from an excel spreadsheet that contain company details and contacts on the specific company. Due to the way...

Hello Experts, Recentlly i start developing an application in VB.net and SQL server. On the server there are some fields that can be empty. I was wondering what is the best practice, use empty values or NULLs for the non required fields? In the tables i got dates, currency, strings. The strings...

Hello there, In some controls (e.g. Textbox) there is a method ResetText. You can always use those to reset them to a 'blank' state). Please note that if you have set the text of (say) the textbox to "HelloWorld" on your on load event, after the reset it will be blank Camel

Hello Chris, Sorry for that I did not test the code before i post it , really stupid of me [tongue], but never the less i came up with a different approatch to solve the problem. Create a public variable: Private _Menu As Boolean = False on the popup of the contextmenu add the following...

Hello buddyel, In order to print the text you need to add a printdocument object on your form. then you need to add the following: ----------------- PrintDocument1.PrintPage ------------- Private Sub PrintDocument1_PrintPage(ByVal sender As Object, ByVal e As...

There is no real disadvanage of doing so but it can be "processor and memory hungry", if you are geting data from the database, or genneraly do something intense on the onload of the form. Camel

Hello buddyel, I am afraid that you need to use the PrintDocument to print the text. Camel

Hello Chris, The problem that you are describing can be complicated and easy to solve at the same time [wink]. Basically you can detect that the user clicked on one of the items by adding a line on the event of that menu, for example: Private Sub MenuItem1_Click(ByVal sender As System.Object...

Thx deed59 :-) i am glad that this helped you

I was never good with maths :-)

Hello Axien, Try the following printDocument.DefaultPageSettings.PaperSize= new System.Drawing.Printing.PaperSize("PaperA4",840,1180); This should set the size of the paper to A4. The next two parameters (after the "PaperA") are the Width and Height of the paper on 100th...

Hello buddyel, Set as a startup form your frmMain. try the following: -------------- frmMain ---------------- Private Sub frmMain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Hide() Dim frm As frmSplash= New frmSplash()...

Hello buddyel, It is very easy using the .net framework to distribute your application along with the database (I am not quite sure about copyright information). You create a zip file containing your application along with all the other required files (remade, help, etc) AND your database. Make...

There is a very useful tool on the web for regular expression validation. It is called RegexDesigner.NET (you can downlaod it free http://www.sellsbrothers.com/products/ Also there is a veb page that you can use to validate a regular expressions (http://regexlib.com/) it also contain a number...

Hello buddyel, The error that you are getting is quite common because it tries to convert a string (the format function returns a string) to a single. You can use that IF you want to display the data (also you can use LO.ToString("####.##") ) If you want to store the number in the...