Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: johnc83
  • Order by date
  1. johnc83

    Locations of items

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

    Locations of items

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

    Can I program a 'click' on a datagridview

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

    Textbox Validation

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

    Textbox Validation

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

    Textbox wont fill until second load

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

    Textbox wont fill until second load

    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 =...
  8. johnc83

    Textbox wont fill until second load

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

    possible to insert NULL into datetime field via textbox

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

    possible to insert NULL into datetime field via textbox

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

    Textbox wont fill until second load

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

    Best way to do SELECT statement

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

    Best way to do SELECT statement

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

    Best way to do SELECT statement

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

    Filling a datagrid with varying columns

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

    Filling a datagrid with varying columns

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

    Filling a datagrid with varying columns

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

    Filling a datagrid with varying columns

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

    Get multiple values from one query

    Hi again, got it working now. thanks a lot for your help John .NET 2.0, Visual Studio 2005, SQL Server 2005 Express
  20. johnc83

    Get multiple values from one query

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

Part and Inventory Search

Back
Top