Recent content by robert693

Hello, I have a Crystal Report with fields, Event, CancelDate, Designation, along with other data pertaining to the Event field. I would like for the user to choose which event that they would like to see in the report. There is a large number of events so I would like to narrow down the...

Hello, I am importing a CSV file into the Outlook Calendar to insert new appointments from an SQL database. The import happens every couple of hours since the appointments in the SQL database might change or be cancelled. One problem that has arisen is that when an appointment is cancelled or...

Hello, I created a column chart in a spreadsheet. The chart shows data that has names, dates, and amounts for each date. I would like to have each date under each name appear as a different color. The chart wizard will only let me make a chart with only one color. What am I doing wrong? Thank...

Hello, I have a database that is used by the managers of several departments of a company. The database stores information about the performance of the employees in each department. I have a query that computes averages from information about each employee entered by each manager. The managers...

Thank you!

Hello, I am creating a database with employee records. The database will be used by department managers. I want the database to show only those employee records that are in the department that pertains to the manager that has signed into the database. When a different manager signs in he or she...

Hello, I am creating a database with employee records. The database will be used by department managers. I want the database to show only those employee records that are in the department that pertains to the manager that has signed into the database. When a different manager signs in he or she...

Hello, I was wondering if there is a way to use a filter by query or the RunPermissions property so that a user will only see a certain set of the records in the database? For example, I am creating a database with employee records. The database will be used by department managers. I want the...

I have an Access table with a date field. The format is set to long date. The data in the field appears as: Wednesday, November 5, 2001 in the table but when I merge the table into a Word document it appears as 11/05/01. Is there any way I could spell it out in the merged document?

If an Access database has been converted from Access97 to Access 2000 can it be opened again in 97 at a later date?

I have a form that is based on a query. The query is based on a two tables, Contact and Survey. There is one more table called Institution. Institution has a primary key, who's value is a number and another field called Name. The primary key of Institution is a foriegn key in Survey table and is...

You are correct The reason it is many to many for contacts is that the contacts can work for different institutions at the same time and do move around alot from year to year. This is a multi year database. I did not want to put the contact in the survey table because we need their personal...

When I get to a field that pertains to the survey it does not allow me to and a message appears on the task bar below that says "cannot add record(s); join key of table 'Survey' not in recordset.

I accidentally posted in the Macro & Module forum by mistake first! Anyway, I have a form based on a query. The query is based on three tables. One table is called Institution, it holds information about universities, hospitals and other institutions. Another is called Contact, which holds...

I have a form based on a query. The query is based on three tables. One table is called Institution, it holds information about universities, hospitals and other institutions. Another is called Contact, which holds information about contacts from the institutions. A third table joins the two and...