Search results for query: *

  1. R

    Form Refresh Issue

    Hi Ian, I added the message box code lines and I am getting values back for both data tables. I know we have made some changes, so I have included all my current code below if that helps. I appreciate all the help. So, when I click the OK button on my search form, it doesn't hide or anything. It...
  2. R

    Form Refresh Issue

    Thanks, Ian. I removed the Shared keyword from the variables, but I still cant get the controls to refresh on the main form. I tried putting in a stop again and it is passing the values to the variables OK (from the search form back to the main form). I just cant get it to refresh. Help appreciated.
  3. R

    Form Refresh Issue

    Do I need to call Initialize component or something like that? Help appreciated. Thanks much.
  4. R

    Form Refresh Issue

    Hi Ian, I made those changes, but I still cant get the frmMenu to run GetData() and refresh the controls. Dont know if it is a problem, but I'm getting a informational message under the .SearchField and .mySearchString variables. The underline indicates: Access of shared member, constant...
  5. R

    Form Refresh Issue

    Hello, I am having trouble with a refresh on my main form. When I put a stop in my main form, it appears that my search variables are being sent correctly by the Search form's Button1_Click, but the main form is not being refreshed. Help appreciated. Here is my code so far: Public Class Menu...
  6. R

    DataGrid Question - Separate Dataset

    Hi Ian, I’m sure I need to use the data relation method described in the post, but I'm still confused about a couple things. My transaction table has over 200k rows. As you can tell from my SQL in my earlier example, I’m doing a select * from my original "parent" table. In my forms, I need 40...
  7. R

    DataGrid Question - Separate Dataset

    Hi, my windows form has a tab control. The code below to search for a person by name is working great. However, Im not sure how to do the next part of my form. I need another tab that just has a data grid view. The grid will be sourced from a different table than what I have in my code below...
  8. R

    Text Box Formatting

    Thanks jmcilhinney and Ian. You both really helped me a lot. I switched my app to use the data bindings and the formatting within the binding object. Wow, this is great!
  9. R

    Expand Record Search Capabilities

    Sorry, I used txtName1.DataBindings.Clear() before binding again and that worked great. Thanks!
  10. R

    Expand Record Search Capabilities

    Very cool, Ian! The data binding works for me and I'm able to move next. The only issue I'm having is when I try to do a another search, I get an exception on the line: With txtName1.DataBindings.Add("Text", myBindingSource, "NAME1") Error: This causes two bindings in the collection to bind...
  11. R

    Text Box Formatting

    Hi, I have text boxes on a form that read data from a MS access database. Most of the money and percent fields are currently set to double in the database and the date fields are returned with a full date/time format. I want to format the money fields like 1,253.00 the date fields like...
  12. R

    Expand Record Search Capabilities

    Hi, I need to expand the search capabilities of my app. Right now, I'm using an input box to collect name search criteria. But now, I need to be able to search on Name1, Name2 and customer number. Should I use a modal form instead in order to have more control or can I still use an input box...
  13. R

    Search Code Not Working

    That does help! Thanks, Ian. Works great.
  14. R

    Search Code Not Working

    Thanks, Ian. That's great. I was able to get everythig working except the like operator. I put the mySearchString variable up in the class level and then set as so: Public Class Menu Dim mySearchString As String Dim mySelectionString As String = "SELECT * FROM DEBTOR WHERE NAME1 like...
  15. R

    Search Code Not Working

    Hi Ian, thank you so much! Based on your advice, this is what I did. Works great: Private Sub DisplaySearchResults() txtName1.Text = myDataSet.Tables("Debtors").Rows(TheCorrectRowIndexOfTheTable_BasedOnTheSearchCriteria).Item(2).ToString txtAddr1.Text =...
  16. R

    Search Code Not Working

    Hi, I have been using a code example I found to search the access db and populate 3 text boxes on my form, but it does not appear to be working correctly. This code is returning the wrong record Im searching on. Not sure why. the item mappings are good with the text boxes, as they appear to be...
  17. R

    Connection String Problem

    Correction, I used: Provider=Microsoft.ACE.OLEDB.12.0 and that worked great, thanks!
  18. R

    Connection String Problem

    Hi Ian, I changed it to the following, but now I get "unrecognized database format" on my con.Open line. Not sure why that is unless it has something to do with the newer access database extension (.accdb)? Thanks. Private Sub Menu_Load(sender As System.Object, e As System.EventArgs) Handles...
  19. R

    Connection String Problem

    Hi, I am getting an unhandled exception on my connection string line below when running. Not sure what the issue is, but I get the following message when running from VS 2010 Pro: Format of the initialization string does not conform to specification starting at index 33. Code: Private Sub...
  20. R

    Customer Form with Lookup and 3 Tabs

    Thanks for your suggestions on this, that makes sense. I will need to start with a modal customer search dialog that will pop-up when I hit the seek button laying outside the tab control. Are there any examples on how do to this? Basically, I need a popup window with a text box I can type in...
Back
Top