Search results

  1. R

    Using a parameter within another parameter

    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...
  2. R

    Importing csv file into Outlook on a regular basis

    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...
  3. R

    Excel column chart in more than one color

    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...
  4. R

    Function used in Combo box record source not working

    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...
  5. R

    Can I create user level security with queries

    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...
  6. R

    Access security issue

    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...
  7. R

    Use a filter by query or the RunPermissions property so that a user will only see a c

    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...
  8. R

    Merge document field format

    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?
  9. R

    Opening a 2000 DB in 97

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

    Can a combo box apply a value from one field but display another value?

    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...
  11. R

    Form based on query not working

    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...
  12. R

    Form based on query not working.

    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...
  13. R

    How can I test if multiple fields are null?

    I have a module that concatenates different fields from a table for mailing labels. The fields are First Name, Last Name, Address and so on. The problem is that if a field is null an error message appears that says "Invalid use of null". I tried several ways to test if the field is null first...
  14. R

    Help with a variable

    I converted a database from 97 to 2000 and I haven't been able to get a variable from the 97 database to work in 2000. It is: Dim Tb1 as Table. I have tried Dim Tb1 as DAO.Table and Dim Tb1 as ADOX.Table but nothing I have tried works. The module concatenates names and addresses from a table and...
  15. R

    Converting from 97 to 2000

    I am having trouble with a database I converted. I declared a variable as Dim TB1 as Table. Access 2000 does not allow this. I am not yet used to the DAO/ADO conversion. Any help with this would be greatly appreciated.
  16. R

    Converting 97 to 2000

    I am having trouble with a database I converted. I declared a variable as Dim TB1 as Table. Access 2000 does not allow this. I am not yet used to the DAO/ADO conversion. Any help with this would be greatly appreciated.
  17. R

    Check box

    I have a check box called FullTime in a form that one checks if an employee is full time. If an employee is not full time then a label and a text box appear with further information. They only are supposed to appear when the check box is not checked. I used this in the form current event...
  18. R

    Use Find in two forms

    I have one query and another query that is based on it. Both of these queries have forms that are based on them. The form based on the first query has a button that opens a form based on the second. The second form opens to the current record on the first. I would like to use the find button on...
  19. R

    Link records in two forms

    I have one query and another query that is based on it. Both of these queries have forms that are based on them. The form based on the first query has a button that opens a form based on the second. The second query performs calculations from information from the first. I would like to have the...
  20. R

    Are objects and methods the same from 97 to 2000?

    I have a module that concatenates names and addresses. I built it on Access 97. When I try to run it on Access 2000 certain objects such as "Table" are not recognized. Same with "index". I was wondering if this has to do with a difference between 97 and 2000 because the module works fine on 97...
Top Bottom