Search results for query: *

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...

Hello buddyel, Unfortunatelly there is no such thing as custom dialog boxies in VB (.net or classic) the only things that you can specify are the message, the icon, and the buttons. The icon and buttons are from a prefixed set of values. I am afraid that you have to go with the option of...

hello CAPSKOL, The only way of unloading an assembly (as far as i know :-)) is by unloading the application domain that holds the assebly. Check the following link on MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconunloadingdomainsshuttingdownprocess.asp...

Hello chiph, I'll have to disagree with you on this point, as misunderstandings are more likely to ocurr, as Americans expect the month first, and (most) Europeans expect the day first. This brings us back to Mattyboy2000's problem of not being able to tell the difference between January 7th...

Hello EmmeS i am not familiar with the ASP.net but one common way of dealing with the problem that you mentioned is by including a hidden field on the page. Store the information to that (depending on the user) and retrieve it when you need it. Hope that this helps, Camel

Hello Chiph, You are absolutely right. The "yyyy-mm-dd hh:mm:ss" is a better format if you want to sort dates but it is quite complicate sometimes for a user to find the important information. Important information is a "vague" term but let me explain: If you are...