Copy Value Into Form

[access2010]

MS Access 2003
We would like to be able to click on K_01 or the other K Numbers and copy the text into the Memo field.

Ideally, If possible for only K_01,
Could we enter the = 1,038 (number of shares) and the number 0.346 (Dividend Value) into two separate fields and have their contents copied into the memo field as
#1,030 Shares @ $0.346?

Thank you for your assistance,
Nicole

 

[Gasman]

In the click event of K_01 you would have
Me.Memofield= "#" & Me.Number of Shares & " Shares @ " & Me.DividendValue

However I am struggling to see any benefit of doing this, and the general consensus is never to store data that can be calculated?

 

[access2010]

Thank you for your suggest.
Can you please advise us as to what will have done wrong
I have renamed K01 to K01_cmdCopy
===
Private Sub K01_cmdCopy_Click()
Me.Memofield= "#" & Me.Number of Shares & " Shares @ " & Me.DividendValue
End Sub
===
Our Volunteer Directors wants to the information that is going into the Memo Field
Thank you,
Nicole

 

[ypma]

Nicole, like Gasman i fail to follow what you end games is? I have added Gasman's formula to your database and it works as intended, however the questions i ask is why a memo field a text field can except 225 characters and will you have a different record for daily changes? Please supply more details if you require further assistance

Ypma

 

[Gasman]

I did not download your DB.
You need to replace my control names with yours.
If any control names have spaces like [Number of Shares] then enclose them in square brackets as I have done so here.

If he has to see it as a sentence, I'd be inclined to use a form with
NumberOfShares Control then a label with the centre text and then the DividendValue control and bring them as close together as you can.

HTH

Thank you for your suggest.
Can you please advise us as to what will have done wrong
I have renamed K01 to K01_cmdCopy
===
Private Sub K01_cmdCopy_Click()
Me.Memofield= "#" & Me.Number of Shares & " Shares @ " & Me.DividendValue
End Sub
===
Our Volunteer Directors wants to the information that is going into the Memo Field
Thank you,
Nicole

 

[access2010]

THANK YOU

The project that you have helped us on works and will save us lots of data entry time.

I appreciated everyone's help.

Nicole

 

[Gasman]

If the director needs to see that, then it could just as easy be an unbound control and put the value there. No need to store. Put the code in the current event of the form as well?.
You might need to use the NZ() function if any could be Null.

HTH

 

[access2010]

Thank you for your suggestion.

We are not programmers in this volunteer office and since your Data Base system W O R K S we will not change the program.

I DO appreciate your assistance and suggestion

Regards
Nicole

 

[Gasman]

Tony,
Even in Excel I would have put in a cell =A1 & A2 & A3 to concatenate the data for viewing. In fact I do that for someone in the office now who then just copies and pastes that column into an email.

Surely the same approach?

 

[Gasman]

Hi Tony,

It's Paul. I agree, and that is why I suggested the unbound control as a director wanted to see a sentence in one place and would not care as to how it was done?. I am actually in that predicament with a charity I volunteer for. As long as they get what is requested, they are not concerned as to how I go about it.
Fortunately for me, I have learnt a lot since joining this forum, so it makes my life a little easier when asked for such and such.

 

[access2010]

Thanks for all the interesting comments.

We had an Ms-Access data base built for us M A N Y YEARS ago which works with periodic adjustments, which we prefer to use instead of Excel.

Nicole