Search results

  1. D

    data entry forms and other processes

    Yes, I am using typed datasets. I use the 'Create New Data Source' wizard for my data source and then give it a specific name.
  2. D

    Normalization help with Treeview control

    Well I cant believe it has been over a year since I started this. But finally getting back to working on this. I have came up with the code below but it is only giving me 2 levels past the root. I see the Root, Level01, and Level02 but nothing past that. I need help with adding the 3rd and 4th...
  3. D

    data entry forms and other processes

    Using: VS 2008 Professional, SQL Server 2008 R2, VB.NET 3.5 on Win7 machine First, if this post is in the wrong area, please forgive me as the questions do cover many areas. Second, I am asking for help and direction to the resources to help me figure this out. I am not asking for someone to...
  4. D

    Normalization help with Treeview control

    I have an Access 2007 app that I created that we use to make our material purchase requests from. Basically there is a materials table that holds our material information, costs, labor units, and 3 levels of catagories. I use 3 cascading combos on a pop up form with a list box that the user...
  5. D

    fill combobox using sproc and variable

    Thanks for your help. Very much appreciated. Stored Procedures is a must on my application. SQL server is going to be a hosted SQL Server. Trying to be super efficient on the data transfer. Thanks again.
  6. D

    fill combobox using sproc and variable

    If I copy this code to the form load event, pass the variable to the fill textbox, and then hide the toolstrip, It will work. I actually have it working. Now, is this the best practice?
  7. D

    fill combobox using sproc and variable

    Private Sub FillToolStripButton_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillToolStripButton.Click Try Me.SpOpenEstimateTableAdapter.Fill(Me.MT3ds.spOpenEstimate, PrmJobNameToolStripTextBox.Text) Catch ex As System.Exception...
  8. D

    fill combobox using sproc and variable

    I tried this yesterday and still having a few issues. The global variable code works fine, except.... When I created the form, I created the dataset based on the sproc. When I dragged the dataset to the form it place a 'filltoolbar' on the form. The parameter has to be placed on the form, and...
  9. D

    TextBox Validation

    Thank you for posting a solution. I will be trying it out later tonight. Thanks again.
  10. D

    fill combobox using sproc and variable

    I have created the form and dataset. I have one major problem. 1. I created the dataset from the stored procedure. When it created it and I dragged the dataset to the form (details mode) it added a tool bar called toolbarfilltextbox. It is basically a textbox in the toolbar for the user to...
  11. D

    fill combobox using sproc and variable

    From the above post, I have shown that my combo box will pull the data. Now I am stuck on passing the value selected to the stored proc and open the next form with a single row using the parameter. My problem is, if I run the procedure from the combobox form, the next form can not access the...
  12. D

    TextBox Validation

    Sorry, been away for a while. We moved our office to a new location and I was the facilitator of the move. New T3 connection is awesome! anyway, back to your reply, I would like to validate textboxes to verify that they are not empty (blank) I have a stored procedure with input parameters, and...
  13. D

    fill combobox using sproc and variable

    Sorry I have not replied. We have moved our office and I have been the main coordinator of it. New T3 connection is incredible! Anyway, back to the post. I have read your replies and started this morning on trying it out. I have a few questions: 1. Can you show me how you declared the DS...
  14. D

    fill combobox using sproc and variable

    Yes, that is what I am trying to do. Thanks.
  15. D

    fill combobox using sproc and variable

    The above code works for what is needed. I am working on adding error handling right now. My next part of this puzzle is opening a form to display the returned datarow in all of the textboxes. Then if a user makes any changes I will need to update that record. I have the stored procedures...
  16. D

    TextBox Validation

    I understand the points you are making, but with my VBA background, I am looking at how its done in VB.NET. In VBA I would assign a value to the TAG property and then loop thru each control to find that tag and then see if is null using NZ() method. I am looking for examples, but yet I do not...
  17. D

    TextBox Validation

    I do not want to jump in someone's post, but if it is not acceptable, please delete. I apologize beforehand. My question is the last code tag section above where the parameters are set for the input. If on the form there is a textbox that is required (on the db side to not allow nulls) how...
  18. D

    fill combobox using sproc and variable

    Ok, been tinkering around. I have this code below, that when the dialog form with the combo box (frmSelEst2) loads then the combobox is populated from the stored proc with the parameter being sent. This works great, but I need someone to check if anything is bad or needs to be changed to make it...
  19. D

    fill combobox using sproc and variable

    Hello all. I have created a dialog form with a combo box, it has an OK and Cancel button. It is called frmEstSel. I have a stored procedure that has 1 input parameter (@Branch). The data for the parameter is in a global variable at 'modUser.ThisAppUser.Branch'. What I need is to connect to...
  20. D

    Login Form with added dataset

    Well, I have completed my changes to your code by adding the correct variable names and database column names, and then debugged. It has worked flawlessly and exactly as I need it too. I really appreciate you taking time out of your busy schedule and helping me. Now on to the next step. If I...
Top Bottom