Recent content by leebop

Can anyone tell me why my combo box does not display all the reords from the record source??? The box is bound. The are 207 records in th source, but it only shows to record 98. If however i type the first letter of a record, it will let me select this record, although it is not in the list...

Help Can someone help me with this code please: Private Sub cmdImport_Click() Dim db As Database Dim rec As Recordset Dim sqlstr As String sqlstr = "tblAttendance" Set db = CurrentDb Set rec = db.OpenRecordset(sqlstr) rec.Index = "StudentID"...

I have a query which is executed and makes a table. As i want the table to be deleted each time i re-run it, how cn i set the Primary Key each time???

Thanks Wayne. Should i be getting pop-up menu's though????

Wayne, i want to addbuttons to the form. the buttons will only be active if there are records in the table tblStudentDetails. i therefore wanted the form to open, look in the tbalementioned above, ani if the recordcount > 0 enable the buttons. however i thought that pop up boxes would help ie...

Wayne, I attach the DB. It is on the on open property of the from frmStudentMenu, that i'm trying to do this

Thanks Wayne. Havedone as u sugested but the pop up boxes still don't appear.

Option Compare Database Private Sub Form_Open(Cancel As Integer) Dim rec As Recordset set rec = db. End Sub I don't understand why the pop up box with OpenRecordSet is not appearing

Can anyone tell me why this key does not run the code, but open the macro box?? I also cannot seem to get code to work when i eneter set rec = db. (there are no pop up boxes) Help please