Recent content by Joseph Yeo

Try [Forms]![formname]![lstLOPID].Column(0) and play around with that.

Look at the number of lives you have saved Anauz. Please email me a copy too. I had racked my brains and spent countless hours developing two separate copies of my forms. Thanks in advance. My email is ozcljoe@aol.com

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.

Found it!! Thanks anyhow. For those who encountered the same problem, the answer can be found in: http://support.microsoft.com/support/kb/articles/Q131/8/29.ASP?LN=EN-AU&SD=gn&FR=0 "How to use the Seek method on linked tables"

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...

Thanks.

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.

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...