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!

Register Log in
  • Congratulations Chriss Miller 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: Tim8w
  • Order by date
  1. Tim8w

    Using Imap4 to access Office365 Email

    Hi, Before the company moved to Office365, we used to be able to connect to the Exchange Server using Imap4 as follows: Private Sub ReadOutlookEMail() Dim imap4 As MailServer = New MailServer(ExchangeServerName, UserName, Password, True, ServerAuthType.AuthLogin...
  2. Tim8w

    Relax or turn off constraints in your dataset

    Sorry, Figured it out. I removed all the queries from the TableAdapter and started fresh with my Query. Worked correctly...
  3. Tim8w

    Relax or turn off constraints in your dataset

    Hi, I have created a DataSet in VB.Net. The Table it is connected to has a PrimaryKey. All works fine as long as my SQL Query is a Standard one like SELECT * from.... I want to use a GROUP BY but when I do I get "ConstraintException was unhandled" with the suggestion that I relax or turn...
  4. Tim8w

    Getting the outline of a region...

    I have a custom-shaped form created by setting the Region to an image. I want to be able to highlight the edge of the form when it has focus. To do this I believe I need to get the outline of the form and convert it to a path so I can draw a two-pixel gihlight around the edge of the form. (1)...
  5. Tim8w

    RegularExpression to convert from Fraction to decimal

    I ended up using four different RegEx to catch all the cases: sPattern = "((?<whole>\d+) (?<num>\d+)/(?<den>\d+))" ' 1 1/2 case regExp = New System.Text.RegularExpressions.Regex(sPattern, RegexOptions.Compiled) m = regExp.Match(dgvc.Value) If m.Success Then dDecValue =...
  6. Tim8w

    RegularExpression to convert from Fraction to decimal

    Now only missing the case for "1 3/4" and "2" (No decimal)
  7. Tim8w

    RegularExpression to convert from Fraction to decimal

    I need a RegularExpression that can convert a string from a fraction or decimal like "1/2" or "0.5" to a decimal "0.5". It needs to handle both cases. Input can be either fractional or decimal, output must be decimal...
  8. Tim8w

    DataGridViewComboBoxColumn setting SelectedIndex

    I finally figured it out. Here's what I had to do: Dim CBox As DataGridViewComboBoxCell = CType(dgvRecipe.Rows(e.RowIndex).Cells(e.ColumnIndex), DataGridViewComboBoxCell) cmbColumnIngredient.Items.Add(e.FormattedValue) CBox.Value = e.FormattedValue
  9. Tim8w

    DataGridViewComboBoxColumn setting SelectedIndex

    ousoonerjoe, That looks like a plausible solution, unfortunately in CellValidating where I am adding the item, the e variable is of type: System.Windows.Forms.DataGridViewCellValidatingEventArgs which members do not include Row. The member variables are: Cancel ColumnIndex FormattedValue RowIndex
  10. Tim8w

    DataGridViewComboBoxColumn setting SelectedIndex

    I have a DataGridViewComboBoxColumn that I allow the user to add new items to by typing in the ComboBox and hitting the 'Enter' key. That triggers CellValidating and I do the adding there by the following: cmbColumn.Items.Add(e.FormattedValue) All this works well, except that it leaves the...
  11. Tim8w

    DataGridView Deleting Selected rows...

    As jwavila reminded me on another forum... For iIndex = dgvRecipe.RowCount - 1 To 0 Step -1 dgvRecipe.Rows.RemoveAt(iIndex) Next iIndex
  12. Tim8w

    DataGridView Deleting Selected rows...

    This is such a basic question, I'm almost emvbarassed to ask it. How do I loop through seleted rows in a DataGridView and remove the rows? I've tried this, but it doesn't work. After one row is removed, the index is all screwed up... iIndex = dgvRecipe.Rows.GetNextRow(-1...
  13. Tim8w

    Physically deleting row in OleDB

    Unhnd_Exception on another forum suggested I go directly to the DB instead of using Adapters... Here's the code I ended up using: Dim Connection As New OleDbConnection("...") Dim Command As New OleDbCommand Command.Connection = Connection Command.CommandText = "Delete From tblMasterRecipe...
  14. Tim8w

    Physically deleting row in OleDB

    I have the folloing code using OleDB to manipulate an Access database: Dim adpMasterRecipe As OleDb.OleDbDataAdapter Dim dsMasterRecipe As New System.Data.DataSet adpMasterRecipe = New OleDb.OleDbDataAdapter("SELECT * FROM tblMasterRecipe WHERE MasterID = @MasterID"...
  15. Tim8w

    RichTextBox Formatting

    I have a RichTextBox. I process all the formatting and everything works fine. There is an exception. When I have selected text that have two states of formatting in it, the SelectionFont member is set to Nothing. I notice that WordPad recognizes this condition and kindof greys out the affected...
  16. Tim8w

    RichTextBox.SelectAll() SelectionFont not set?

    Basically I found the answer here: http://msdn.microsoft.com/en-us/library/system.windows.forms.richtextbox.selectionfont.aspx It said: If the current text selection has more than one font specified, this property is Nothing
  17. Tim8w

    RichTextBox.SelectAll() SelectionFont not set?

    I have a RichTextBox where part of the RichTextBox is Bold and the rest is not. If I do a SelectAll, the SelectionFont member doesn't get set. Anyone know why? In WordPad, with the identical Font and bolding set on part of the text, the SelectionFont appears to get set to the first font it...
  18. Tim8w

    Need help building Query

    r937, That worked fine! Thanks for the help. Maybe I can finish this program for them tonight because of your help! Thanks again!
  19. Tim8w

    Need help building Query

    I am writing this program for a large group of non-profit seminary schools and anyway, I'll list the entire table if that helps although I doubt it will... I realize that to get the answer I need I only need the following tables: Table 1: ClassHeader ClassID ClassName Description Units Major...
  20. Tim8w

    Need help building Query

    I have the following three tables: ClassHeader ClassID Major TeacherClasses TeacherID ClassID StudentClasses TeacherID Major I want to select all TeacherClasses where the a given Major = ClassHeader.Major

Part and Inventory Search

Back
Top