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

    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?
  3. 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...
  4. 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...
  5. 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
  6. 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?
  7. 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.
  8. C

    Filter

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

    Check Box IIF Statement

    I have a check box (cbxPC) I want an iff statement when true, then [PremierCourseCredit]=[Award Amount] if false then [PremierCourseCredit]=0 Not sure how to write it or where to put the code. Thanks
  10. C

    Save reports sent out

    I have students who have applied for scholarships. When we send an approval letter, is there a way save it under their profile? Maybe a macro that uploads it as an attachment? Or any other ideas?
  11. C

    Update Query

    I am new to update queries and need some guidance. I have a form that I will filter by Invoice Number I have an unboud field that I can type in the check number. Sometimes I have over 50 records that need the check number added. I would like to type in the check number and it update the...
  12. C

    Solved Open Form Where Condition Text Field

    I have a student ID that looks like this AB123456 I want to open a form based on a form I have a combo box with a macro. I am stumpted on the where condition because it is a text field. =" [Student ID] =" & [Student ID]
  13. C

    #size error on print preview

    I have this in my report but when I go print preview I get the #size error. =[qryRequested Course_CrosstabFY23 subreport].[Report]![Text17] I have tried =NZ([qryRequested Course_CrosstabFY23 subreport].[Report]![Text17],0)) and still get it. Can somone guide me in what other options I have...
  14. C

    If statments

    I have a field [Remaining] I would like to do a macro where when [Remaining]=0, [Status], "Funds Exhausted" Or do I do a condional format?
  15. C

    Insert to Query

    I just came across insert query while trying to find out how to copy a filed in table Applications to a specific record/field in Requested Course. Here is what I am trying to do. I have a form with table/query Requested Course If the Student ID# is blank I have a pop up form people can search...
  16. C

    Filter on Load

    I have a form with a query that I want to filter on load between 10/1/22 and 9/30/23. I then want a check box that I can click to view all records. When checked- show all records Unchecked- between 10/1/22 and 9/30/23 I saw this on a demo access but can not figure it out. Need some guidance...
  17. C

    On Click add note to subform

    I have a check box that when I click on, I want to add a record in my notes subform that says emailed then also populate the date. So on the main form I have check box [email_approval] Subform- Contact Notes subform1 2 fields Notes NoteDate Thanks
  18. C

    New Record in subdata sheet

    I have a combo box that looks up value on my form. It results in a list of names I have a sub datasheet set to single form. I have two fields check in and date. I want when I select the drop down, and the names appear, I can go to a new record in the subform. This is my set up Main form...
  19. C

    Email PDF

    I have a report that I want to email as a pdf. The report looks great, however when I go to email it via pdf or print the 3 subreports are not being included. I have had reports work prior, and I added 1 more subreport to it and now it does not work.
  20. C

    Count on Report

    I have a query with 2 tables. Requested Course and the Status of the course When I run the report it shows perfectly, Only list the Provider and the Courses they offer are listed perfectly When I go to do the count. I only want the count of each course. Right now it includes the count for...
Top Bottom