Search results

  1. E

    Type Mismatch

    I am getting a type mismatch error on this if statement. If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] And "[EvaluatorMgr] = " & txtRandomMgr) = 1 Then MsgBox ("This user has already evaluated a manager") End If This piece of code is placed on a command...
  2. E

    Reset controls in subform

    This thread is a follow-up that relates to the system of the my last. I have a main form with project id and a subform with financial data linked to the main form by project no and p_id. The subform itself has an autonumber primary key field for each transaction. The subform also has the fields...
  3. E

    Calculation in subform

    Here is the scenario: I have a table Finance with the following fields Table Finance Id ProjectNo Type Amount Commitments Expenditure Type is a combobox with the selections PR, PV, SR, PDN This information is displayed in a subform 'Financials' with linkage to the main form via projectno and...
  4. E

    Field Cannot Be Updated Error Message

    I have a main form with project information and subform with financial information for each related project. Every time I try to add a new record, I get the error message "field cannot be updated". I click ok and it appears again, this continues three times after and then disappears when I...
  5. E

    Hiding controls in a subform only when adding new records

    Hello, I have a main form, "frmProjects" and a subform, "subformFinancials". It is used to track project information. This form is to view, edit and add new records. The user is allowed to add new financial records on the subform. However, there is a purchase type field "cboType" which the...
  6. E

    Run-time Error "2450"

    Firstly, I must say thanks for the sample databases. I am using code from one of them to display project images in a database. However, I am getting the run-time error "2450" - Microsoft Access can't find the form "frmPictureExample" referred to in a macro expression or visual basic code. When I...
  7. E

    Populating a combo box in a sub-form

    Good day, I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular...
  8. E

    Displaying Image in Main Report Through Sub Report

    Good day, Problem: My image files are not being displayed in my report. I have a table that stores links to images in a folder. I have created two reports a main report and a sub report. The main report was built through the union of four tables. The subreport works fine,displaying each image...
Back
Top Bottom