Search results for query: *

Good afternoon all - Background: I am using Crystal Reports 8.5 connecting to a SQL Server backend. I currently have several reports that were designed in Crystal and several that were designed in Access (all connect to the same database). This tends to confuse some of the users, they have a...

Good afternoon all - Does Access 2000 support using multiple bands for any sections of a report. What I need to do is have 2 text boxes in the details section, but one or the other will be hidden at various times throughout the report, and I need to not avoid the extra space that is displayed...

Hello - I am using automation in Office 2000 to control Outlook from Excel. I have a button on my worksheet to allow the user to email the workbook back to me directly from Excel. My problem is in determing if the e-mail was actually sent or if the user backed out and decided not to send it...

Is there a limit to the number of non-contiguous cells that can be included in a named range in Excel 2000? Twice I have highlighted the cells and named the range and both times when I check the range it only picks up about 1/3 of the original cells. Thanks -Gary

I am using CR 8.5 connecting to SQL Server via ODBC. The reports I create track employee completion of federal compliance training courses for a financial institution. SQL Server tables are set up as follows: Person emp_id - pk emp_status group region market cost_ctr auto_event - fk Event...

Hello all - Using Crystal 8.5, SQL Server, ODBC. I am working with a database that tracks employee training. In my event table there is a field (status) that records an employee's current status for a particular course. 'C' (Completed), 'E' (Enrolled), etc. I have been assigned to report on...

Hi all- I am using Access 2000. I have one table tblDailyTimeSheet that has 5 fields: pkeyTimeSheetID (AutoNumber), EmployeeID, TimeSheetDate, TimeIn, and TimeOut. This table stores daily time records for employees. I have a second table, tblEmployeeActivities that tracks what employees do...

Hello - Using Crystal 8.5, SQL Server, ODBC I have only one table - Courses. One field in the table is named competency. There are 15 choices for competency(Collaboration, Communications, etc.). My goal is to report on this field, i.e. show all courses that have a certian competency. The...