Search results

No need to have a real table, the result of the code above is in the line Me.topDate = TempRS.Fields(0).Value That example is tied to a field on the form I was testing with, you can just put the above code in the afterupdate event of the form, or make it a function and tie it to a button.

That or just change it to a TOP 1 query sorted DESC on that field.

You could load the date fields to an array, then transfer the array to a disconnected recordset and sort it. Dim TempRS As ADODB.Recordset Dim TempArray As Variant Set TempRS = New ADODB.Recordset With TempRS.Fields .Append "tempDate", adDBDate End With TempArray = Array(Me.Field1.Value...

Can you post the SQL version of the query?

You could make another table to hold the race(s) of the people and do a one-to-many relationship for each record.

Your user and password are stored in the connection string. DSNConnection = "ODBC;DSN=DSNNAME;UID=UserName;PWD=UserPassword;DATABASE=DatabaseName;Network=DBMSSOCN;Address=ServerNameOrAddress;Trusted_Connection=No"

Dim ctl As Control, MyLongString As String, MyLengthToTrim As Integer, MyLeftString As String, MyRightString As String, MyOriginaLength As Integer For Each ctl In Me.Detail.Controls Select Case ctl.ControlType Case acCheckBox If ctl.Value <> 0 Then...

When you changed it to top 5 in the query did you sort DESC by the scores field?

Glad to help :)

Ok this was a brain twister but it should work. Replace the code with this Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctl As Control, MyLongString As String, MyLengthToTrim As Integer, MyLeftString As String, MyRightString As String For Each ctl In Me.Detail.Controls Select Case...

Here ya go. :)

Why not just add 5 checkboxes to the record?

I use WIA to resize and crop images in a VWI database at work. WIA also has filters for rotate as well. I have added a rotate filter to my procedure here as an example ImageToSize is the path and file name of the original image, ImgFinal is the Path and image name of the final image Public Sub...

No problem. See attached.

No, the textbox on my test form is the one named LongStringField

Yes that will work on a continuous form.

I would do it this way, this loops through the detail section looking for check boxes. If it is a checkbox and it is checked, it adds the controls name to a long string in memory. At the end of the loop it sets a text field to the long string and the record saves. Private Sub...