Search results

Well when i link a text field to the memo field on the table and view the form its cut the txt off. But when i look in the table i can see the full string of text.

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?

thank you for your help, i knew it was something with "

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

thanks man that worked. I was just overthinking it :)

does it need to be brackets when you are writing code in VBA?

ok now how would i write that in a if statement and the loan amount will not change... the value from the loan amount * .0104 will be in a text box called NPV ... to conclude, I need a if statement that goes like If Loan_Type = "HFS" Or Loan_Type = "FHA" And Final_Rating = "Defect" And...

so conclude, if all the if conditions are true, then take the loan amount in a text box and multiple by 0.0104

no not 4% but to multiply loan amount by 0.0104 and yes to be permanent in a table. For example, if loan amount is 72k * 0.0104 would equal 748.8 which is the NPV for the loan which would be the value in the text field labeled NPV on a specified form.

Yes in the if statememt once the calculation is completed then the calculation will be in a text field, so if that same form is open and there is a number in the text field i specified then i need the if statement to ignore and dont execute the statement...... here is the request i have that im...

Correct once the calc is done it will not be repeated again. Only if the if statements are true then multiply loan amount by .0104

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

obviously the And part is not correct. I want the if statement to say if target date is less than now then change status. But i dont want the status changed if the Final resolution date has a date in the text field.

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