Search results

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

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