Search results

  1. J

    Freeze columns and rows in Form

    Does anyone know how to freeze both columns AND rows (like in Excel), on either continuous forms or datasheet? In datasheet one can freeze the column but not the row.
  2. J

    Had To Repost This - Need Help Urgently

    I have the following codes which works perfectly: Dim Db As Database Dim Rs As Recordset On Error GoTo ErrorControl Set Db = CurrentDb Set Rs = Db.OpenRecordset("Clients") Rs.Index = "PersonID" Rs.Seek "=", CLng(PersonID) However, after splitting the database, I get an error message on this...
  3. J

    Form in Datasheet view needs locking - How?

    I have a form in datasheet view. I would like to prevent users from dragging and modifying the column width. Please tell me how to do this. Why use a datasheet? because I need the freeze column ability not available in a continuous form.
  4. J

    Split Database would not recognise .Index

    I have the following codes which works perfectly: Dim Db As Database Dim Rs As Recordset On Error GoTo ErrorControl Set Db = CurrentDb Set Rs = Db.OpenRecordset("Clients") Rs.Index = "PersonID" Rs.Seek "=", CLng(PersonID) However, after splitting the database, I get an error message on this...
Back
Top Bottom