User Profile

Collapse

Profile Sidebar

Collapse
Teri B
Teri B
Last Activity: Oct 26 '23, 06:11 PM
Joined: Mar 31 '22
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Teri B
    started a topic Report value list
    in Access

    Report value list

    Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
    0ne-to-many. One course many roles.

    Then I created a report based on the Course form and role Sub form.

    I brought the sub=form into the report and it has the correct values, but it does not have the same look and feel as the other fields.

    I created a list box in the report for roles, but it...
    See more | Go to post
    • Teri B
      started a topic Expression
      in General

      Expression

      I am trying to write an expression and having trouble. I get the first part of my arguments correct but when I try to add the third I run into trouble. Here is the first part of the expression:
      Code:
      =IIf([completedate]>"",
   "Complete",
   IIf(
      IsNull([CompleteDate]) And ([DueDate]<Date()),
      "Overdue",
      ""
   )
)
      This works correctly....
      See more | Go to post
      Last edited by zmbd; Apr 16 '22, 06:27 PM. Reason: [z{placed required code tags and stepped the posted code}]
      • Teri B
        started a topic Form to SubForm
        in General

        Form to SubForm

        Guys I have a Parent form that links to my child form. My parent form is the user details the field I am working with is the Contact ID Field.
        So what I am doing is the user opens the form from a search window they select the contact and the contact ID field populates their details Name, address, phone etc. The sub for which is imbedded populates with assigned record information. The linking field is the Contact ID of the parent form and...
        See more | Go to post
        No activity results to display
        Show More
        Working...