Search results

  1. R

    Filter VBA code

    yes thats what im trying to do, but i need to know how do i add it to the code below Me.MSProductionSubform.Form.Filter = "[Status] = 'MLO Evaluation Completed' And [Assigned Analyst] = '" & Me.UserQueueSelected & "' And [Testing Month] = '" & Me.Testing_Month & "'"...
  2. R

    Filter VBA code

    For John doe, i have a button on a form the user can press to view Completed record. I need the above code, to filter the status column to "MLO Evaluation Completed, Final QC Completed, Final QC Incomplete". this will allow the user to see all records he completed.
  3. R

    Filter VBA code

    Oh ok, well in this case there are times when records will have the Status as Final QC Incomplete. See Below John Doe Has Record 1. He completes his work and flagged as MLO Evaluation Completed. Jane Doe see record 1 is completed based on the status. Jane doe does a review to make sure the...
  4. R

    Filter VBA code

    the below code only filters my form where the status is 'MLO Evaluation Completed' Me.MSProductionSubform.Form.Filter = "[Status] = 'MLO Evaluation Completed' And [Assigned Analyst] = '" & Me.UserQueueSelected & "' And [Testing Month] = '" & Me.Testing_Month & "'"...
  5. R

    Filter VBA code

    Hello All, I am needing help with adding an additional criteria to the below VBA language. Me.MSProductionSubform.Form.Filter = "[Status] = 'MLO Evaluation Completed' And [Assigned Analyst] = '" & Me.UserQueueSelected & "' And [Testing Month] = '" & Me.Testing_Month & "'"...
  6. R

    SQL Insert Into Line Continuation

    thanks that worked!
  7. R

    SQL Insert Into Line Continuation

    Hello All, I am needing help with the following SQL line continuation syntax. The issue is after Hire Date DoCmd.RunSQL "INSERT INTO PeerEvaluation (MysteryShopperID,[MLO Name],[MLO EID],[Assigned Analyst],[MLO Phone Number],State,District,ASM,[Call Attempt Status],[Call Scenario],[Name...
  8. R

    VBA to set subform textbox record source

    Hello All, I am needing help to set a subform textbox record source. So i have a subform that list 8 questions. Each question has its own questionID. I have another text box that is unbound, but i want to set the record source based on the questionID. For Example QuestionID = CC1 Question...
  9. R

    Dlookup with criteria as column in query

    Hello All, I am trying to build an query with a dlookup with the criteria being a column within the query. for example, I have a query that has following columns: Testing Month, Question, QuestionID, Total Fails: Dlookup(Column) example of current query dlookup: Total Fails...
  10. R

    VBA Error

    Hello All, the below code for some reason does not work correctly. Private Sub Form_Load() If Me.Remediation_Start_Date.Value = Me.Target_Response_Date.Value Then Aged_Loan.Value = "No" ElseIf Me.Remediation_Start_Date.Value >= Me.Target_Response_Date.Value Then Aged_Loan.Value = "Yes"...
  11. R

    Access Query to include null

    Hey one more question, with the above query my output is like this: Loan Number|Action Taken Date|Action Notes | Combined Field 12345465 5/1/2016 Hey im cool 5/1/2016-Hey Im cool 12345465 5/2/2016 Hey im cool 5/2/2016-Hey Im cool 12345465 5/3/2016...
  12. R

    Access Query to include null

    ok changing inner to Left seemed to work. Thanks Man!!!!!!!!!!!!!!!
  13. R

    Access Query to include null

    I have criteria on the Date of Request with a parameter to enter a date and criteria on Requestor Dept
  14. R

    Access Query to include null

    SELECT RTMasterTbl.[Date of Request], RTMasterTbl.[Requestor Dep], RTMasterTbl.[Loan Number], RTMasterTbl.[Borrower Name], RTMasterTbl.[Detailed Description of Issue], RTMasterTbl.Category, RTMasterTbl.[Sub Category], RTMasterTbl.[Team #], RTMasterTbl.Performer, RTMasterTbl.[RT Final Rating]...
  15. R

    Access Query to include null

    i believe i need to add in isNull[Action Taken].[Date] & "-" & [Action Taken].[Notes] so that the query will pull records that have null values in the Action Taken Date/Action Taken Notes
  16. R

    Access Query to include null

    Heres the issue, there are records missing from the query. The records that are missing from the query are records that have no text in the Action Taken Date/Notes field.
  17. R

    Access Query to include null

    Hello All, I have a query i created that pull notes for a record set. The issue i am having is for records that dont have any notes are not being pulled within the query. Action Taken Notes: [Action Taken].[Date] & "-" & [Action Taken].[Notes] I believe i need to add in the Isnull to the...
  18. R

    Display Memo field text in Access Form

    awesome... I removed the @ on the form field and table and now the full string of text displays
  19. R

    Display Memo field text in Access Form

    Please see attached. The box black box is the field on the form and i also ss the properties for the field box
  20. R

    Display Memo field text in Access Form

    Sorry, When you create a textbox on a form and you set the recordsource as the name of the field in the table which is set as a memo field on the table. So when a view the form in FORM view i see part of the text string which is cut off at 255 characters.
Back
Top Bottom