Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Database window is popping up with docmd.printout
Thanks PHV.... removing the True helped out!- rsippos
- Post #4
- Forum: Microsoft: Access Forms
-
Database window is popping up with docmd.printout
I built a database (mde) that this keeps happening to. I have the following code for a print button on a form. Just to print the contents of the form: Private Sub PrintForm_Click() On Error GoTo Err_PrintForm_Click Dim stDocName As String Dim MyForm As Form 'Make sure that...- rsippos
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
need help with a tough SQL problem
If you have three tables, EMPLOYEE (key: EMP_ID, fields: EMP_NAME, EMP_SALARY), DEPARTMENT (key: DPT_ID, fields: DPT_DESC, DPT_MGR_ID (FK to EMPLOYEE on EMP_ID)), and EMPLOYEE_DEPARTMENT (key:EMP_ID,DPT_ID), How can I write a single SQL statement that would give the average employee salary for...
