Attendance database

U

UK EXCEL MAN

Hi

I'm somewhat new to this so please advise what more you need.

I have a database set up with a form that has the following fields from a
lookup query based on staff code, staffname;

Staff code (shows staffname)(combo box)
Teacher (T or F)
Absence reason (value list)(combo box)-data entry
Absence start date-data entry
Absence end date-data entry
AMPMFull Day (value list)(combo box)-data entry

A user asked me today if she could search for a past record that was input
and though I added a search command button, the past record(s) can not be
found. Is there a problem in the setup somewhere?

Any help appreciated.

Thanks
Steve
 
U

UK EXCEL MAN

Record source is qryAbsences and is a link of Staff Data (Staff Code,
FullName, Teacher, employment start and end dates) and tblAbsences
(ID(primary key) plus fields as listed below).

Code not altered;

Private Sub Command14_Click()
On Error GoTo Err_Command14_Click


Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command14_Click:
Exit Sub

Err_Command14_Click:
MsgBox Err.Description
Resume Exit_Command14_Click

End Sub

Thought that just had to add to form. Seeing the code says otherwise. Pls
advise.

Thanks again
Steve
 
U

UK EXCEL MAN

Thanks for that. I added the necessary. Works fine. Sometimes you just
need that swift kick to get you to think
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top