Solved

How to Save a Memo box to Queried records

Posted on 2015-01-13
9
126 Views
Last Modified: 2015-01-14
Hello,

I have one memo box on my form for each change.  I need to save the memo comment to all my queried records.  How do I do that??
0
Comment
Question by:Jass Saini
  • 5
  • 3
9 Comments
 

Author Comment

by:Jass Saini
ID: 40547179
Here is my code..It updates everything and I just need to to update the queried records...

Private Sub Remarks1_Click()
    Dim strMsg As String, strQry As String, strRemark As String
    
    strMsg = "Update All Comments in the Current view.  IMPORTANT!!! Will update a the Viewed records."
    
    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 set Remarks1 = Remarks1 &  '--" & strRemark & "'"
            QuickQry strQry, False
            Me.Requery
        End If
    Else
        MsgBox "Action cancelled."
    End If
    
End Sub

Open in new window

0
 

Author Comment

by:Jass Saini
ID: 40547247
I am not asking how to combine it anymore..I figured out to into in to one..now I need to update and save to the other records.  Which is different than combining...
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40547559
If you are taking a memo field and applying it to multiple rows, you almost certainly have a design flaw.  The memo field probably belongs in the parent record.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:Jass Saini
ID: 40547599
Pat...what do you mean parent record.  Is my coding incorrect too??
0
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40547686
I didn't look at the coding.  I am questioning why you would want records to all have the same comment.  For example, in an order entry system we have tblOrder and tblOrderDetails.  If I wanted to put a note about the delivery of the order, I would not put it in the tblOrderDetails, I would put it tblOrder.  Why would I want the same note to appear on each line item when it could appear once on the order.  However, if the note was specific to a line item, then the note belongs on the line item.  In your case, you are saying that each line item should have the identical note as every other line item for a given order.  The problem may be the way your tables are structured.  If you don't have a "parent" table to group the rows where you can store information about ALL the rows, then perhaps you should.  Technically, you can create an order entry application with only tblOrderDetails.  The problem is that you would have the order number, client name, billing address, shipping address, tax, shipping cost, etc all repeated for each OrderDetail.
0
 

Author Comment

by:Jass Saini
ID: 40547703
That's is what I asked...But I have a set of records from a query and my boss wants all of them to have the same memo...

Don't ask me why...I was told to just say yes..anything can be done in access.. My boss doesn't know the limitation of access.  It's a great tool if you know how to use it???
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40547936
We are not talking about a limitation of Access.  We are talking about properly structuring your schema.   If you get the schema right, many things will simply fall into place and you won't have to struggle so much.  If you get the schema wrong (as you may be in this case), you'll have a nightmare on your hands.   The "boss" shouldn't be telling you how to store data, that is for you to decide.  You are the technical person.  What he is telling you is how he wants to "see" the data and that is a completely different topic.  To "see" the memo attached to each row, you only have to join to the table where it is stored and select it.  That satisfies the boss' request for how he wants to view data and doesn't cause any structural problem with the schema because you haven't stored duplicate data.

Once you manage to follow the directions the others will give you, you will have succeeded in committing the crime of the century from the perspective of proper database design.  Once you duplicate the data, do you have a plan for keeping all the separate copies in sync?
0
 

Author Comment

by:Jass Saini
ID: 40549157
Thanks Pat....I have been following directions...everything time I think I am at the end of my road..I end up at a crossroad.  Thanks for your help!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Combo Box with a control source is "locked" 10 16
Export to Excel 7 32
update query 4 22
How to get query to return one row for each unique part # 2 11
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

790 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