Solved

Can you join Memo fields on a Continous form

Posted on 2015-01-12
16
128 Views
Last Modified: 2015-01-14
Can you join Memo fields on a continous form??
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
  • 2
  • +1
16 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40545446
You can join memo fields in a query which is the Source for continuous forms.
0
 

Author Comment

by:Jass Saini
ID: 40545454
How?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40545513
what do you mean by joining memo fields?
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:Jass Saini
ID: 40545592
Yes for all the records in the query results
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40545621
do you mean like this

select [memo1] & " " & [memo2]
from tablex
0
 

Author Comment

by:Jass Saini
ID: 40545748
Sorry Rey,

Maybe I am not clear enough...I have the continous form which if I have the memo field in the detail section..it will need a input in each record...I am trying to do the memo field in the header so it capture the memo for all the records and not each individual one...hope that is clear as to what I want.
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40546079
Make the textbox for the memo unbound.

Then run this code in the OnCurrent event of the form:
Dim rst As DAO.Recordset
Dim strMemo As String
Set rst = Me.RecordsetClone

While Not rst.EOF
    If strMemo <> "" Then
        strMemo = strMemo & vbNewLine
    End If
    strMemo = strMemo & rst!YourMemoField.Value
Wend
Me!txtMemoHeader.Value = strMemo

Set rst = Nothing

Open in new window

/gustav
0
 

Author Comment

by:Jass Saini
ID: 40546718
Hello Gustav,

How would the memo be stored??
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40546730
The parts of the concatenated memo are stored in the individual records.
The concatenated (joined) memo is for display only.

/gustav
0
 

Author Comment

by:Jass Saini
ID: 40546750
Ok...I will try it and also where am I suppose to place this event
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40546774
In the OnCurrent event.
If you are nitty-gritty, also in the AfterUpdate and Delete events.

/gustav
0
 

Author Comment

by:Jass Saini
ID: 40546890
That's wierd..it locks up the program
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40546897
No, the movenext is missing, sorry:

While Not rst.EOF
    If strMemo <> "" Then
        strMemo = strMemo & vbNewLine
    End If
    strMemo = strMemo & rst!YourMemoField.Value
    rst.MoveNext
Wend

/gustav
0
 

Author Comment

by:Jass Saini
ID: 40546927
Hello,

I tried this...but it is populating only the first record..In my query I have seventeen records.

Here is what I am using...I want to be able to use one memo box...enter in my comment and it populate the rest of the records.

Private Sub Remarks1_AfterUpdate()
    Dim strMsg As String, strQry As String, strRemark As String
    
    
    If vbYes = MsgBox(strMsg, vbYesNo, "IMPORTANT!!  Confirmation") Then
        strMsg = "Please enter the remark"
        
        strRemark = InputBox(strMsg, "Remark")
        
        If Len(strRemark) > 0 Then
            strQry = "Update Final_Table_AllotQ set UpdatedDate = now(), UpdatedBy = """ & htboLoginName & """, Remarks = Remarks &  '--" & strRemark & "'"
            QuickQry strQry, False
            Me.Requery
        End If
    Else
        MsgBox "Action cancelled."
    End If
    
End Sub

Open in new window

0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40546959
That's the other way around.
I think you need to rephrase what you are trying to do.

/gustav
0
 

Author Closing Comment

by:Jass Saini
ID: 40549147
Thanks
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linking Child/Parent fields between 2 subforms 15 61
Microsoft Access VBA - allocate a colour 3 74
Microsoft Access report help 4 38
View SQL Count Records 3 32
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question