Search results for query: *

Hello, I need a little help. I need to create vba code that will print a report a report dependednt on value within field. If field "form" has a value of 1 , print report 1 if field "form" has a value of 2, print report 2, and so forth. There are 5 reports and the value in field form are listed...

I put the database out there. http://www.mediafire.com/?3gxim6xen1ifa Thanks again.... :-)

Thanks so much for your help. I tried the below and I get eoor 3265. I am not sure what I am doing wrong??? Private Sub ExportTimesheets() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strSQL2 As String Dim strFileName As String On Error GoTo...

@MazeWorX Hi, Thanks. I tried the below and I am getting a compile error. What am I doing wrong. Private Sub EportTimesheets() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String strSQL = "Select Distinct tbl_Distribution.DeptID From tbl_Distribution;" Set db = CurrentDb()...

@SkipVought Necessity is the mother to all invention… ? They produce a timesheet report from Reportsmith that is connected to the HR system and fax to each department. The departments fax back the time sheets and Payroll manually keys time into the HR System from faxed Time Sheets. While I...

Hello, ------------------------------------------------------------------ I have a database that produces timesheets for employees based on employee information and grouped by department information in tblDetail. I have a macro that exports the report Timesheets into excel. I need one Timesheet...