Search results for query: *

  1. A

    Question Fixtures list

    Hi everyone. Thanks in anticipation for any help. I have ten teams and effectively need to create a fixture list in runtime in vb.net 2012. All the teams would play each other once (9 sets of matches) Each match would involve two teams and there would be 5 fixtures each week. I'm hoping to...
  2. A

    Question SQL dates - Nullreferenceexception was unhandled error

    thanks but its all working now. Whats the procedure when an issue is resolved? Many posts seem to have "new" titles beginning "resolved"
  3. A

    Question SQL dates - Nullreferenceexception was unhandled error

    Thanks so much for ALL the help on this one. :chuncky: SLPx - renamed the fieldname in sqlexpress, then used dd-MMMM-yyyy to put date in the correct format. I enclose finished code for reference. Public Class recentissues   Private Sub MonthCalendar1_DateSelected(ByVal sender AsObject, ByVal...
  4. A

    Question SQL dates - Nullreferenceexception was unhandled error

    I get no data at all when I know its there Public Class recentissues   Private Sub MonthCalendar1_DateSelected(ByVal sender AsObject, ByVal e As System.Windows.Forms.DateRangeEventArgs) Handles MonthCalendar1.DateSelected Dim rs3 As ADODB.Recordset = New ADODB.Recordset Dim Db As...
  5. A

    Question SQL dates - Nullreferenceexception was unhandled error

    Paszt - Thanks for the advice. Anything to improve is helpful
  6. A

    Question SQL dates - Nullreferenceexception was unhandled error

    Herman - huge thanks. Helped me get the whole lot looking better and was able to remove no end of what was indeed vomit. The issues remain however. The SQL query should remove all data from tbl_student_rss except where a date in the field "datetime" > the date chosen from Month calendar Public...
  7. A

    Question SQL dates - Nullreferenceexception was unhandled error

    Thanks for the notes. The basics from a book get you so far and its clear I'm still missing all sorts. I'll look through your notes at a later point. Thanks again. :confused:
  8. A

    Question SQL dates - Nullreferenceexception was unhandled error

    I have a Monthcalendar from which a date is chosen and a button is clicked. I can store this and have tried formatting it a number of ways so it can be used in an SQL statement to list all incidents which were recorded after that date. PrivateSub MonthCalendar1_DateSelected(ByVal sender...
  9. A

    Question Losing an array value

    Thank you so much. I felt a button for each student would be useful as they are colour coded to indicate %attendance. The front form is intended to give an overview of the group whilst allowing the user access further info on that pupil at the click of the button. Thanks again
  10. A

    Question Losing an array value

    Really new and would value any support. I have 308 buttons on Form1 (Pupilselectform) and each one has a separate textvariable (pupilID) attached to it. When I click on one of the buttons I'd like to open a second form (Pupilview) and run an SQL using the pupilID chosen from Form 1. Problem...
Back
Top