Search results

Hello all, I am trying to format a varchar column which as dates in the format of '09152016'. I would like to convert the text date to 09/15/2016.

Hello All, I am just try create a temp table from excel VBA. Below is the code i have which works for a select statement. But i want to create a temp table. 'Initializes variables Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim ConnectionString As String Dim StrQuery As...

I have a select query that pull records based on certain where criteria. I want the recordIDs that are returned to be used in another query to see if the ID exists? For example Select Query 1 pulls all records with a open status. I want to have another query run taking the IDs found open in...

Hello All, I am needing some help on a query i am trying to build. I am needing to select 10 random records by each Assigned Analyst. See below code SELECT TblEmailReview.[Assigned Analyst], TblEmailReview.ManagerAssigned, TblEmailReview.[Testing Month], TblEmailReview.Status FROM...

Hello All, I have the below code in a module to call outlook. The problem i am having is the .To part. The outlook dialogue does pop up but all of the emails located in the Query1 do not show up in the To box in outlook. The .CC shows all the emails for the manager but .to box only shows 1...

Hello All, Could someone help with the SQL query below. SELECT Tableau.*, "Pass" AS AccessVerification FROM (Tableau LEFT JOIN AAL_Matrix ON (Tableau.[Access] = AAL_Matrix.[PrimaryRole]) AND (Tableau.[AAL] = AAL_Matrix.[AAL])) INNER JOIN TblApprovedExceptions ON (Tableau.[Access] =...

Hello All, I am trying to Join the 2 Select Queries below and not sure on how to. What i would like the results to show is a Fail for any user who has unapproved access. The first Select statement checks the tbl named AAL_Matrix against the Tableau table and provides a "Fail" for anything...

Hello All, I am needing up with coming up with a macro/vba to lookup a value in a table and compare it to a record in a form. Example below Master Table/Parent Table ID AAL Access Level Allowed Access 1 AAL123 Level 1 Access Wire Transfer 1 AAL123 Level 1 Access...

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 & "'"...

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...

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...

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...

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"...

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...

Hello, I have a memo field in a table that has 500 characters. I want to display the text in a field on a form, but text fields are limited to 160 characters. How can i get the full string of text from the memo field in the access table to display on a form field?

Could anyone help with the code below, i get a error after the And, which im sure i have the syntax wrong Me.Filter = "[Assigned Analyst] = '" & Me.UserQueueSelected & "'" And "[Testing Month] = '" & Me.Testing_Month & "" Both combo boxes are text strings

Hello All, I am needing help displaying text that is in a memo field in a table on a textbox on a form. I am aware the textbox limits to 255, so i am needing help with displaying the text from the memofield in the data table. The form is bound to the table and the textbox is bound the the...

Hello i am having issues with a dlookup formula. The dlookup has 2 criteria which is a combo-box and text. Please see the forumla below Original code without combobox Nz(DLookUp("CountOfStatus","Analyst Summary","[Remediator] = 'John Doe' And [Status] = 'Aged'"),0) Name of combobox on form...

Hello, i am needing help with a if statement in access2010. Here is my formula which is incorrect, Private Sub Form_Load() If Loan_Type = "HFS" Or Loan_Type = "HFI" And Final_Rating = "Remediated" Then Loan_Amount.Value multiply(.0104 I am needing a if statement that meets the criteria and if...

Hello, I am needing helping with the if statement below in access 2010. Here is the code below Private Sub Form_Load() MsgBox "All Fields marked with a Asterisk* are required fields. Please make sure to answer all required fields before completing remediation review", vbOKOnly Or...