Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: azalealee
  • Content: Threads
  • Order by date
  1. azalealee

    Generating a consecutive date for calendar report

    Hi I'm trying to design a calendar report for a Work Scheduling Access 97 database, but I'm having some difficulties. I would like the report to have a separtate row for each day, the name of the people doing the work as columns and the work descriptions as entries. The user inputs the date...
  2. azalealee

    SendObject problem sending reports in RTF

    Hi! I am using Access 97 with Lotus Notes R5 as my mail server. I have been trying to automate the attaching of reports in RTF for users through the SendObject method. I have the following code on the onClick event for a button: Private Sub cmdEmail_Click() Dim WorkID As String Dim...
  3. azalealee

    Send Object problem sending reports in RTF format

    Hi! I am using Access 97 with Lotus Notes R5 as my mail server. I have been trying to automate the attaching of reports in RTF for my clients through the SendObject method. I have the following code on the onClick event for a button: Private Sub cmdEmail_Click() Dim WorkID As String...
  4. azalealee

    Switchboard manager error after splitting - Access 97

    Hi. I've just split my database, with the back end residing on a shared network drive. Since I split the database, I'm not able to access the Switchboard Manager with an error message of: "The Microsoft Jet Database Engine cannot find the input table of query 'Switchboard Items'. Make...
  5. azalealee

    Actions between pop up and main forms

    Hi there! I have a continuous form that lists work orders (F_List_WOs). This form has an option group (opStatus) for each work order record with three choices, Complete, Incomplete or Not Required. When the user selects Not Required, a pop-up form (PUF_Incomplete) opens with three command...
  6. azalealee

    Select query - recordset not updatable

    Hi I have a very frustrating select query based on 3 tables. The basic content of the tables are: M_Work M_WO JT_Section_Work *Work_ID *WO_ID *Section_Work_ID Work_ID Section_ID Work_ID...
  7. azalealee

    Sorting 3 field from option group selection

    Hello I have a select query that has fields - Policy_ID Policy_Name Rev_Due_Date I would like to sort these fields depending on a user selection from an option group on a form with ID and Name in ascending order and Date in decending order. I have tried using something like this...
  8. azalealee

    Adding frequency of revision to last date revised

    Hello! I'm developing a query for a document management system that uses tables with some of the following fields: Tbl_Revision (stores revision details): Policy_ID Revision_Number (0,1,2,3rd revision) Date_Revised.... Tbl_Policy (stores policy details): Policy_ID Revision_Frequency_ID...
  9. azalealee

    inserting new fields into related tables

    Hi I'm having troubles designing the tables for an organisational database. I have 3 tables Division, Dept and Section, in a hierarchy order. ie, there are 7 Divisions, multiple departments in a division and multiple sections in a department. I have added these relationships by including the...
  10. azalealee

    ..Expression too complex to be evaluated error in SQL

    Hi I'm having troubles with this query. Everything works fine with the option group selecting the right records from the table. However, I get the error "..expression too complex to be evaluated" when I include the criteria after the final AND. This criteria checks to see if the first...
  11. azalealee

    Hide controls based on selection from Option Group

    Hi! I have a form with 4 options in an option group. I would like 2 textboxes and their labels to appear only when option 4 is selected. I have written the following code, but the error "..only comments may appear after End Sub, End Function..." occurs. I have also tried a Select Case...
  12. azalealee

    Hi. I'm relatively new to reports i

    Hi. I'm relatively new to reports in access. So please be patient. I have a report based on a query. Depending on a selection a user makes from an option group on a form, I would like a group header to be created that reflects their selection. Eg Sort by Leader or Sort By Category I have tried...
  13. azalealee

    IIF and IsNull for Date Completed Query

    Hi! I'm having problems with designing a query in design view. I have a Date_Completed field from a table that will have a value when a task is complete, and have no value if the task is outstanding. I want the query to show all Completed tasks when the option group on my form =1 and show all...
  14. azalealee

    Generating report from multiple options

    I need help. I hope I can explain my problems adequately. I'm developing reports for a hazard database. I have a form with 2 option groups and the following options: Filter_Op_Group Sort_Op_Group - Completed Tasks - Manager Responsible - Uncompleted Tasks - Task...
  15. azalealee

    validating date field on form with multiple users

    Hello I have a "Hazard Alert" database that requires data entry from both administrators and managers. Administrators enter a hazard into a form then notify the relevant manager to update the database and take necessary actions. Managers view the same form and update their section...

Part and Inventory Search

Back
Top