Search results

  1. C

    Conditional Formating based on another field

    I have a field on a subform [frmApproveApplication].Form![KnikTribeMember] if the field is "Yes" Then I want [ProfileName] to have red text. I tried conditional formatting, but not exactly sure on the expression.
  2. C

    Filter on Load

    I used this example and it worked great. Now that I am in FY24 how do I make the default (filter) year 2024?
  3. C

    Emailing a report

    Is there a way to change that? If so, how? I did a quick search and looks like all my forms, reports, say NO.
  4. C

    Emailing a report

    When I email a report and outlook opens, I am unable to click back and look at the report and or form I was working in. Is there a work aroud to this?
  5. C

    Open Form Tab

    I have a button to open a form. I want the form to open to a specific tab I copied this from my macro that opens perfectly. Form: frmApproveApplication1 View: Form Where: "[Requested Course.ID]=" & [ID] Mode: Dialog I want it to open to tab 2, Tab name: tbApproveCourse Thanks for any...
  6. C

    Percentage

    I have a query with list of students and and field that they pick yes or no. I want to create a query/report to where I have a list of student and the course they sigend up for, and ther number of yes over the total of participants. Example Course 55 (yes)/150 (no) How would I go about...
  7. C

    Combo box-Hyperlink

    Perfect. I got it to work. I changed it to (!)
  8. C

    Combo box-Hyperlink

    This is what I put and it does not work Private Sub cboInvoices_AfterUpdate() Application.FollowHyperlink Me.cboInvoices.Column(2) End Sub My combo box has 2 fields File name and the hyerlink field (not as a hyperlink datatype) I get an error Invalid use of Null
  9. C

    Combo box-Hyperlink

    No. Could you guide me a little more on that? Right now have the combo box with 2 fields and when I select the form, the hyperlink shows. I then click on it. I want to stream line that process.
  10. C

    Combo box-Hyperlink

    Is there a way to have a combo box and when click on the option it opens a hyperlink? I have a table with the list of forms and then I have a webpage to get the form Table fields File Name File link
  11. C

    Combo box

    I have a table with fields NotApproved Details On my form I have a combo box, people can select the not approved reason I would like a text box to display details and have it editable. Is this possible?
  12. C

    Form Search

    I used this tutorial Create a Search Button on your Form in Microsoft Access. Find Button. Filter, FilterOn Properties - Bing video When I search for a course it filters in a list box. (This works) I want to double click on the course I want and in a subform it list all the students registered...
  13. C

    Form Search

    My subform is BSA _Invoice_Roster_Subform Both have a have course ID in the query. If that helps.
  14. C

    Form Search

    I was able to do the search and filter how I want. I have a list box. When I double click on the course I want the subform display the students enrolled. I have a subform on my main form. Thanks for everyones guidance.
  15. C

    Form Search

    All I have is a form. Nothing started. I know how to do it from a combo box and I select the course and it filters the names in a subform. For this I want to type in the box and hit go, then filter the courses associated with it.
  16. C

    Form Search

    I would like to have a search box that if I type in a word it list out all courses that contain that word. Example Search: Miller List of courses with the word miller. My next step is to select the course to view the roster. Any guidance would be great.
  17. C

    Filter

    I would like to create a filter button. I want it to click the button and [active_closed] filter the blanks.
  18. C

    Check Box IIF Statement

    Got it to work. Had to add me.refresh at the end. Thanks for all your help!
  19. C

    Check Box IIF Statement

    Thank you for this. Is it okay to have an _? I updated the field to Award_Amount However the code is not working.
  20. C

    Check Box IIF Statement

    so =IIF([cbxPC],[PremierCourseCredit]=[Award Amount], "0") The code turns red.
Top Bottom