Recent content by KingSassa

  1. K

    Form Background - Transparent

    To my knowledge, not in Access. Access doesn't render with transparency. You might be able to do it by subclassing the window, but this would be a very involved project if you haven't worked with the Windows API before. if you use .NET this is possible and quite easy, but you would have to...
  2. K

    Remove the box surrounding form

    Sorry, not in Access. (Unless you want to do some very hefty windows subclassing, but I wouldn't recommend it.)
  3. K

    Remove the box surrounding form

    Change your Border Style to 'None'
  4. K

    Edit column of data to fixed series of sequential numbers.

    Here is one routine that would work with ADO: Sub SequenceADO() Dim rs As New ADODB.Recordset Dim N As Integer N = 0 rs.Open "SELECT [sngTime] FROM ttbl5GAS ORDER BY [sngTime]", CurrentProject.Connection, adOpenKeyset, adLockOptimistic rs.MoveFirst...
  5. K

    Edit column of data to fixed series of sequential numbers.

    Here is one solution. Version of Access and database type is assumed. Sub Sequence() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim RS As DAO.Recordset Dim N As Integer Set db = CurrentDb N = 0 Set RS = db.CreateQueryDef("", "SELECT * FROM...
Back
Top Bottom