Search results for query: *

Hi Pat, thanks a lot for the reply. Sorry for the little information but thats because I don't really know anything :-) On the left I have 'Mailbox - John' and under that I have 'Archive Folders'. I have just deleted my e-mail account through outlook and my tasks, emails etc were no longer...

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, thanks very much for the reply. I'll give that a go, sure it will work great. Cheers John .NET 2.0, Visual Studio 2005, SQL Server 2005 Express

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 Sorwen, your assumptions are correct. If I don't mess about with making items visible/invisible then the form works perfectly. All boxes are bound whether they are hidden or not. My InhaulierTextBox is always visible as it is part of my 'general boxes' but the others such as...

Hi Sorwen, totally understand where you are coming from and thanks for the reply... The procedure that is causing me problems is as follows: Private Sub ChangeToCleanScreen() 'Adjust boxes so they reflect the type of service you are creating a job for TankStateComboBox.Text =...

Hi Ron, thanks for the reply. To be honest I don't think posting code would help (I may be wrong) but this is why I think it.. Lets say my textbox1 is not populating correctly. I delete it completely from my form and then add it again. When I run my app now - textbox2 doesn't work properly. So...

Hi Perrin, suprisingly that works perfect!! I have read so many pages hovering around the answer (giving workarounds etc..) but never anything that worked as it should but thanks to you I have found it! Thank you so much. Really appreciate it. Jebenson - thanks for your reply, I was doing...

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

Thank you. That should be enough to get me started. Cheers John .NET 2.0, Visual Studio 2005, SQL Server 2005 Express

Hi all, thanks for the responses... I actually am familiar with normal form and I understand your points. Main reason I avoided doing the related tables route is because I wanted to ensure that the speed of this one particular query was a fast as possible and I thought (maybe naively) that...

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, I've never chosen to show my SP's in the DataSources tab because I didn't see the benefit. I do know though and it is working perfectly! Thank you so much for your help. John .NET 2.0, Visual Studio 2005, SQL Server 2005 Express

I am using datasets (not sure what strongly typed means, i'll take a look). When doing something like this I generally drag an item from the table in the dataset onto a form which then creates the tableadapter and bindingsource. I then fill/update etc.. using these. Hope that helps. Thanks for...

Hi ppl, thanks for the replies and apologies for the limited information. After reading some other posts I think I need to un-simplify my request as it may not actually be possible. Here is my actual query.. SELECT a.MethodCode, COALESCE (b.RECustPrice, a.REListPrice) AS Price FROM...

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, got it working now. thanks a lot for your help John .NET 2.0, Visual Studio 2005, SQL Server 2005 Express

Hi again, my datagrid already has a bindingsource which saves back to the table. Datagrid has 4 columns: ProductCode, ProductName, QTY, Price My idea is to enter the ProductCode which will then populate the ProductName box from tblProducts and the Price from the same table (QTY is always 1)...