mikejs

I am using the following to store the X Y cords [CODE]Private Sub Timer1_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer1.Tick MyX = Me.Location.X MyY = Me.Location.Y My.Settings.Save() End Sub[/CODE] but the Me.Location.X or .Y are not detecting the forms position when I move it?

Hi I have a number of forms which have a common menu strip rather than copy the control onto each additional form is it possible to just call the menu from another form ?

Hi I have used the following code to populate a DataGrid based on the contents of a textbox. the users searches for a name which is populated into a combobox based on the name in the combobox several textboxes are populated with data based on the data in one of …

Hi how would I go about creating a payment schedule based on a date and a number of months 3 or 6 or 12 to then populate the database with reoccurring dates so lets say new user added on 31/10/2011 for 6 months I need the database to add all …

Hi I am using the following to auto search db [CODE] Dim connString As String = My.Settings.strConn Dim conn As New SqlConnection(connString) Dim cmd As New SqlCommand("select firstName, existing from tenant Where (existing = 1)", conn) Dim da As New SqlDataAdapter(cmd) Dim ds As New DataSet Try conn.Open() da.Fill(ds, "List") …

Gi I have a DataGridView which populates from an SQL query just fine in default mode using these table names [CODE][firstName] [varchar](20) NOT NULL, [lastName] [varchar](20) NOT NULL, [rentpaid] [decimal](18, 0) NOT NULL, [datePaid] [date] NOT NULL, [propRef] [varchar](10) NOT NULL, [rentDue] [decimal](18, 0) NULL,[/CODE] I have edited the column …

Hi I have a form which populates a TextBox I want to use the textBox.text to then load a gridView with the results something like [CODE]Private Sub TextBoxId_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBoxIdSearchExist.TextChanged Dim cmd As New SqlCommand("select * from pay Where t_id='" + tId.Text + …

Hi I need some help I have a variable stored in db which is created when a new person is added it takes the day of todaysDate on the day they register and stores only the day I would like to use this date as the same day of every …

Is it possible to store a document in a database and then be able to load it into VB and populate specific areas with data from textBoxes? like address or name details I suppose a bit like a mail merge ?

Hi I have several panels in my app is there a simple way to switch between the panels without dragging them off the screen so I can see the ones bellow if I need to edit the first panel I have to move 8 panels to see it :-( thanks …

Hi I am using the following to get the system sound question but it doesn't populate ? [CODE] Public Class SystemSoundItem Dim sound As SystemSound, soundName As String End Class Public Property SoundToPlay As SystemSound Set(ByVal value As SystemSound) End Set Get SoundToPlay = SystemSounds.Question End Get End Property[/CODE]

I seem to have broken something I get this error Unable to cast object of type 'System.EventArgs' to type 'System.Windows.Forms.KeyPressEventArgs'. my code: [CODE] Private Sub ListControl_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListControl.SelectedIndexChanged Dim connString As String = My.Settings.strConn Dim conn As New SqlConnection(connString) If ListControl.SelectedIndex > -1 …

I am going mad trying to sort this logic out lol [CODE] Public Sub Panels() If RadPanelSearchCur.Visible = True Then RadPanelTenant.Visible = False 'RadPanelProp.Visible = False RadPanelTenantEdit.Visible = False ElseIf RadPanelTenant.Visible = True Then RadPanelSearchCur.Visible = False 'RadPanelProp.Visible = False RadPanelTenantEdit.Visible = False ElseIf RadPanelAddTenant.Visible = True Then RadPanelSearchCur.Visible = …

Hi I am trying to save settings on close I have the following code [CODE] Private Sub MainSystem_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing My.Settings.firstRun = Me.RadCheckBoxFirstLoad.Checked = True End Sub[/CODE] and on form load [CODE] If My.Settings.firstRun = False Then RadPanelWelcome.Show() Else RadPanelWelcome.Hide() End If[/CODE] I …

Hi I am using this code to clear the contents of my panel [CODE] For Each c As Control In PanelEdit.Controls If TypeOf c Is RadTextBox Then DirectCast(c, TextBox).Text = String.Empty End If If TypeOf c Is MaskedEditBox Then DirectCast(c, MaskedEditBox).Text = String.Empty End If If TypeOf c Is ListBox …

Hi I am using the following code to populate text boxes based on a drop down list index change event [CODE] Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As WinControls.UI.Data.PositionChangedEventArgs) Handles DropDownList1.SelectedIndexChanged Dim connString As String = My.Settings.strConn Dim conn As New SqlConnection(connString) Try conn.Open() Dim qry As String …

Hi is it possible to fill a list box from two SQL tables firstname lastname thanks M

Hi I have set pane1.hide() and panel2.hide on form load however the panel still shows when I had only one panel it worked fine the new panel is exactly the same size placed directly over the other. Why does it still show? I know I could use multiple forms it …

Hi I have managed to sort out my date issue however although I have used the same code format on of my tables is not being updated and I am not getting any error msg so not sure why it will not work this is my code [CODE] cmd1 = …

Continuing on from my adding data to the db I am using the following to try and update the db [CODE] End If 'Refresh_Form() conn.Close() 'update property table Dim connUpString As String = My.Settings.strConn Dim connUp As New SqlConnection(connUpString) Dim cmdUp As New SqlCommand Try connUp.Open() cmdUp.Connection = connUp cmdUp.CommandText …

Hi I want to use an id reference that had just been created in a different table I have an insert query that adds a new user to the users table the t_id is auto generated I want to use the t_id value in a new query that runs after …

Hi I am trying to submit a date value from a DateTimePicker1 using short date format 05/02/2011 I get an error on submission .NetSqlClient Data Provider:conversion failed when converting date and/or time from charecter to string this is my insert [CODE]cmd1 = conn.CreateCommand cmd1.CommandText = "INSERT INTO tenant(firstName, lastName, Email, …