Search results for query: *

Hi all, im a newbie with Exchange so please pardon my stupidity. I have managed to set up our server to send and recieve e-mails and I can get them to arrive in my outlook inbox. I am fairly confident that my e-mails are on my own PC and also on the Exchange server. I have created some test...

Hi all, could someone tell me if this is possible please.. I have a bound datagridview and underneath it are bound textboxes with the same fields. Idea is user clicks on particular row and the boxes react so he can make edits there. A problem I am having is that when I fill the datagrid for...

Hi all, I have an annoying problem and would appreciate help please.. My textbox is bound to a numeric table field. If a user types in something other than a number then it won't let them leave the box. Don't get me wrong, validation is a necessary thing but I would like the user to have the...

Hi, My title basically says it all. My datetime field is bound to a textbox. Entering dates is no problem, the update works but I need to be able to enter NULL if the user has accidentally saved a date in there and needs to remove it. Im starting to think this isn't possible and I hope I am...

Hi all, I have a really annoying problem that I just cannot figure out.. My form have several textboxes including a JobNumberTextBox. When I type in a job number and press enter in this box all the other boxes populate with the details of that job number. I have a type field in the table which...

Hi all, once again I am faced with a select statement that, although I could probably work it out myself, chances are that it will not be the most efficient way to do it.. Here is an example table to show what I am talking about: ProductCode, ProductName, LinkProduct1, LinkProduct2 001...

Hi all. Hoping someone can help me with this please... My stored procedure is like this: Select Product, (Quantity * Price) As TotalPrice From tblProducts Could someone show me how to get a datagridview to populate with the results of this query.. if this was a normal query I would just drag...

Hi again, sorry for those who have noticed my many recent posts but I so close to completion now! :-) If I have two textboxes (CustomerName), (CustomerContact), is it possible to run ONE query against the tblCustomers which will fill in both of them boxes? I don't want the textboxes to be...

Hi all, got a problem and I'm starting to think what I am trying to achieve may not even be possible.. I want to programatically add a new row to my bound datagrid view. I've read a lot of times that I need to add the new row to my binding source as opposed to my datagridview. Will this mean...

Hi all, I ma having troubling displaying images using PrintDocument. The images are originally big but I can't seem to resize them without distorting the image, Does anyone know how I can add it and reduce the size by a percentage or something like that rather than by width and height. He is...

Hi All, I have been creating a new windows VB application for the past few months and it has become necessary for part of it to be web-based. I have never created a new asp.net web site before and was hoping someone could point out the basics. How would I go about setting up a home page where...

Hi all, I am trying to use a checkbox and I'm sure I'm overcomplicating it. Would appreciate help pls.. My tblCustomers has a field called 'OnStop' which tells the user if he/she is able to sell a product to them when they come to book them in. At the moment I have it as a varchar datatype...

Hi all, In the creation of my database (SQL Express 2005) and my application (VB.NET) I have used the 'sa' login for SQL without exception. I am now starting to heed the warnings of not using this login and have set up a new user. I would just like a little help with a couple of things if...

Hi all, could someone help me create a procedure to accomplish the following please.. Lets say I have 5 job records in my tblJobs JobNo, CustomerCode, Price, Status, InvoiceNo, 1, A000, £100.00, Completed, NULL 2, A000, £100.00, Completed, NULL 3, A000...

Hi all, I have a small problem which I'm hoping is easy to fix: I have a textbox called JobNoTextBox. The only format allowed in this box is 2 letters followed by 6 numbers. i.e "AB123456". I need to automatically format the text if someone enters a value which is not in this format...

Hi All, could someone help me with a textbox binding problem please.. I have a textbox called JobNumberTextBox which is currently bound like this.. Me.JobNumberTextBox.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.MYSERVERTblJobsBindingSource, "JobNumber", True)) How do I get...

Hi, I am trying to get an output from an SQL update command to appear on my VB.NET form but at the moment I am very much at the basics and have one question please.. Example: Lets say I have the following table (tblUsers), it has 2 fields and the current data looks like this: UserName...

Hi all, could someone point me in the direction of a solution for this please.. I am planning an invoicing module for charging out the records in my Jobs table. I would like to issue an update command, something like this: update tblJobs set Job_Status = 'Invoiced' where Account_Number =...

Hi all, this is surely really simple but I cannot find any info on it. I would like to know how to exit out of a procedure and request that it ends there (i.e it doesn't go back to the original caller and doesn't go onto to the next sub in the list) I tried 'Exit Sub' but it still returns to...

Hi all, got a niggly little problem with my select statement and would appreciate some help pls.. I have a tableadapter which should return the output of this query.. Select ProductID From tblProducts Where ProductName = @Param1 Problem I have is that when the ProductName has a NULL...