Search results

  1. J

    access and charts

    What version are you using? They changed the way charts are handled in 2003. In 2003, charts are handled by pivotchart view of queryies or tables. Poor move in my opinion...
  2. J

    Rotate Type 90 degrees on Reports

    Use the vertical property under the "Other" Tab. The only problem is that it turns the text so it can be read from the left side of the page. I'm stumpted as far as turning it so it can be read from the right. Anyone have any ideas?
  3. J

    Adding criteria on the field being filled.

    You're right about the naming conventions. I'm working off some old tables (lots of flats, no relationships) and I guess I needed a good excuse to change it. Here is the new SQL from the query: SELECT DISTINCT Training_Completion_Dates.REC, [Last_Name] & ", " & [First_ Name] AS CAFULLNAME...
  4. J

    Adding criteria on the field being filled.

    Here is the SQL for the rowsource on the combo box: SELECT DISTINCT [TRAINING COMPLETION DATES].REC, [LAST NAME]+", "+[FIRST NAME] AS CAFULLNAME, [TRAINING COMPLETION DATES].[TNG NO], PEOPLE.POS, PEOPLE.AC, [RECURRENT TRAINING SESSIONS].CREW, [RECURRENT TRAINING SESSIONS].RECNO, PEOPLE.[PC...
  5. J

    Adding criteria on the field being filled.

    I am working on a scheduling form that uses 3 combo boxes to select the people being scheduled. The form is rowsourced to a table of training sessions with a field for each of three crew positions being trained. One combo box is used for each of those fields. The row source for each combo box...
Top Bottom