[AccessD] DataGrid control (cont.)

Stephen Bond stephen at bondsoftware.co.nz
Sun Feb 19 18:03:30 CST 2012


Here's the whole Sub if that helps:
================================================
Sub FillGridSpecificJobObservations(ByVal pk)
Dim strSQL As String
  Set rs = New ADOdb.Recordset
  Set rs.ActiveConnection = CurrentProject.Connection
  rs.CursorType = adOpenStatic
  rs.LockType = adLockReadOnly
  rs.CursorLocation = adUseClient
  strSQL = "SELECT qryEquipmentRegisterRHS.JobId, " & _
                   "qryEquipmentRegisterRHS.ObservationId AS ObsId, " &
_
                   "qryEquipmentRegisterRHS.ObserverName AS ObservName,
" & _
                   "qryEquipmentRegisterRHS.ObserverDate AS ObservDate,
" & _
                   "qryEquipmentRegisterRHS.ObserverTime AS ObsTime, " &
_
                   "qryEquipmentRegisterRHS.Shift, " & _
                   "qryEquipmentRegisterRHS.Id"
  strSQL = strSQL & " FROM qryEquipmentRegisterRHS "
  strSQL = strSQL & " WHERE qryEquipmentRegisterRHS.JobId = " & pk & ";"
  rs.Open strSQL
  rs.Sort = "ObsId Asc"
  SortAsc = True
  Set Me.DataGridSpecificJobObservations.DataSource = rs   '  <---
runtime error on this line
  
  Me.DataGridSpecificJobObservations.Refresh
  
  Set dg = Me.DataGridSpecificJobObservations
  dg.Font.Size = 8
  dg.RecordSelectors = False
  dg.Columns(0).Width = 0     ' JobId
  dg.Columns(1).Width = 500   ' ObservationId
  dg.Columns(2).Width = 1800  ' Name
  dg.Columns(3).Width = 1000  ' Date
  dg.Columns(4).Width = 800   ' Time
  dg.Columns(5).Width = 450   ' Shift (was S or U)
  dg.Columns(6).Width = 0     ' Id
 ' dg.Columns(5).NumberFormat = "currency"
  dg.Columns(3).NumberFormat = "dd/mm/yyyy"
  dg.Columns(4).NumberFormat = "hh:nn"
  dg.Columns(3).Alignment = 2
  dg.Columns(4).Alignment = 2
  dg.Columns(5).Alignment = 2
  dg.MarqueeStyle = 3
  If rs.RecordCount = 0 Then
 '   Me.Toolbar1.Buttons("Edit").Enabled = False
  Else
  '  Me.Toolbar1.Buttons("Edit").Enabled = True
  End If
End Sub

=================================



More information about the AccessD mailing list