Copy Value Into Form

access2010 · Apr 15, 2018

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 · Apr 15, 2018

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 · Apr 15, 2018

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 · Apr 15, 2018

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 · Apr 16, 2018

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

access2010 said:
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 · Apr 16, 2018

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 · Apr 17, 2018

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 · Apr 18, 2018

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

Uncle Gizmo · Apr 18, 2018

access2010 said:
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 have done 3 or possibly 4 databases for charities.

In all cases, I set about changing the flat file structure provided to the correct multi table structure.

I now think this may have been a mistake!

People are used to Excel (flat file), and they understand it.

The changes I made, sort of lock the database, making it inaccessible to a competent excel user.

This might not be a good direction for a Charity to take.

Sent from my SM-G925F using Tapatalk

Gasman · Apr 18, 2018

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?

Uncle Gizmo · Apr 18, 2018

Hi Gasman, (Sorry, I don't have a record of your real name) I was making a general observation about charities using MS Access databases. If a charity was to use an MS Access database, then how they manage the data structures within it might be an important consideration. An MS Access programmer's Instinct would be to advise them to use the multi table structure and not use a flat file structure. However once you move away from the flat file structure, making changes to your database will requires someone with a reasonably good knowledge of how MS Access works. From the point of view of a charity, it may not be possible for them to pay for the services of a professional programmer. Hence the choice of a flat file structure might well be a sensible option.

Gasman · Apr 18, 2018

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 · Apr 19, 2018

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

Copy Value Into Form

access2010

Registered User.

Attachments

Gasman

Enthusiastic Amateur

access2010

Registered User.

ypma

Registered User.

Attachments

Gasman

Enthusiastic Amateur

access2010

Registered User.

Gasman

Enthusiastic Amateur

access2010

Registered User.

Uncle Gizmo

Nifty Access Guy

Gasman

Enthusiastic Amateur

Uncle Gizmo

Nifty Access Guy

Gasman

Enthusiastic Amateur

access2010

Registered User.

Similar threads

Users who are viewing this thread