Error Copying Field Data use =Sum([])

[access2010]

Gasman
I appreciate your 6 cents Canadian.
Because our Volunteers get worn out in the Environment that our Clients have, we made arrangements that we work, one month on and one month off.
===
Fabiola

 

[Gasman]

I would have to ask, why does the 'Access person' have to take on the responsibilities of a caseworker/volunteer.?

Why not have one person removed from NGO work, who looks after your database for you.? That is their contribution and he/she is not exposed to 'the Environment'.

 

[isladogs]

I'd also support Gasman's comments even if you do have a monthly 'shift pattern'. Many of us have tried to guide/lead /assist various people in your organisation. We are always told none of you are programmers. That's fine. Nor are many other forum members. But most want to improve their skills and understanding.
However, the expectation from the various people that use the Access2010 name is always that other forum members will do all the work. And up until now that has generally been the case. The fact that we are told you are a charity isn't relevant. It really is time that one or more volunteers were given some basic training in order to get some real understanding of database concepts and hence to move forward.

This isn't meant be a rant at you personally and indeed I don't think you have posted before today. Apologies that you are getting the brunt of this.

The forum should be used as a search tool and a place to get advice. Not as the place to get the complete solution done for you.

 

[essaytee]

essaytee
Drip (Dividend Reinvestment Plan) = www.investopedia.com/terms/d/dividendreinvestmentplan.asp
Our NGO finds that using Drips increases our Endowment's growth by not having to pay brokerage commission for new share purchases.

Understood

===
Our Volunteers sign on for Monthly intervals.
The people who had been working with you on this project have now left.
Could you please place your queries into the forms that you have in our uploaded database as I/we are not a programmers and upload the edited Data Base?
===

Did you run the SQL query I posted? It is just a simple matter of opening the query at your end, go into SQL View and paste over what is there. Then you run it, check the results. Are the results as you expected?

Yes, correct the query and thank you for your suggestion=
restrict entries where the TransactionQuantity > 0 (must be either Bought or Drip (what ever Drip is)).
===
Fabiola

Try this yourself, if you have problems, by all means, raise a question, show what you have done and we can point you in the right direction.

 

[essaytee]

What does a Non-Government Organisation do? I know you must be keeping track of share investments but what is the high-stress nature of the core business where volunteers are only rostered every other month? I'm curious.

Speaking about volunteers, you do realise that in this forum we are all volunteers, nobody has to help anybody. We all come from different walks of life, different parts of the world and not all are professional programmers; I'm not.

From what I can gather, there appears to be no continuity at the NGO regarding ownership of the share investment tracking database. For what it's worth, any accounting package and that includes share trading is not for the faint of heart. It is complex.

I believe the etiquette of this forum is to help people, guide people in the right direction. From my experience, most users asking questions are here because they are keen to learn, are interested in Access/VBA. In relation to this particular thread, I assisted and explained the process of creating three queries, each query based upon the preceding query. If that is not understood, questions can be asked during the process to seek clarification, I have no issues with that. Who knows, I might not be correct and I'm sure others would chime in.

Something I have noticed in this and other threads is that the personnel of your account, Access2010, always reference that the director wants this, the director wants that. It appears they may not be true volunteers or that the database task is not what they want, they would prefer to do something else.

As you can gather I echo the sentiments of others. I like helping (teaching) people and that is different to simply doing it for people.

"give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime"
Update/EditGasman Didn't realize, but I used your link/tagline

 

[access2010]

Gasman
Thank you for your note and we did have a person who was responsible for our databases for M.A.N.Y years, but she has been unable to assist us for a while.
We are looking for a new database person and hopefully will have success soon.
Paul

 

[access2010]

essaytee
Thank you for all of your assistance(s) and we will try and get your suggestions to work.

Paul

 

[access2010]

isladogs
Thank you for your suggestion and we will try and improve our skills.

Paul

 

[access2010]

essaytee
Thank you for your assistance and the following code has proved VERY helpful in many of our forms.
===
Private Sub Replicator_B_Click()
If Not Me.NewRecord Then
Me.Net_Share_Quantity = Me.SubSharesOwned
' Into = From
' Above copies the FROM {SubSharesOwned} INTO {Net_Share_Quantity}
Me.Net_Share_Cost = Me.SubAverageShareCost
' Into = From
' Above copies the FROM {SubAverageShareCost} INTO {Net_Share_Cost}
If Not IsNull(Me.Symbol_Stock) Then
End If
Else
MsgBox "Can not perform this function, we are at a New Record"
End If
DoCmd.Close acForm, Me.Name
' Close Form
End Sub
===
Thank you, again
Paul

 

[essaytee]

essaytee
Thank you for your assistance and the following code has proved VERY helpful in many of our forms
... snip
Paul

Hi Paul,

No worries.

I am still curious though, what do you guys actually do or what is your core business?

 

[access2010]

essaytee
Thank you for your note.
I/We are volunteers at a charity.
The group I work with helps in deciding which equities should be kept, sold or bought.
===
In December we receive the most equities as a donation and in return the donar receives a tax receipt, for the fair market value of the donation. These funds are placed into an Endowment fund which is used to cover expenses.
===
The database we are updating was created by a lady who spent about 10 years working on database programs. This person has left to spend her time with her young family.
===
Regards,
Paul

 

[isladogs]

The question that has been asked repeatedly is what is the purpose of the charity itself. All we are ever told is that the volunteers use a database to assist with buying and selling equities. But to what end? What does the charity actually do?

 

[access2010]

isladogs
Thank you for your note, I volunteer for a group of Women & Children Shelters and will be retiring from my position at the end of April after starting 30_Sept_2010 and nearly accomplishing, what I was asked to do.
The Endowment funds are used to pay the operating costs of the organization.
===
If you wish to help a Shelter in your area, please send a donation to the link below.
www.shelter.org.uk
===
Paul

 

[isladogs]

Thanks for clearing that up. I gave you the opportunity to plug the charity as well.
Hadn't realised you were all UK based. I've raised money for Shelter several times over many years.

 

[Gasman]

Why did I think they were Canadian?

 

[access2010]

isladogs
Sorry for my error.
I am in Canada and the work that I am doing is being Shared between all the Charities, that have endowments.
Are you near Surbiton. UK and if yes, I can have you join us for a beer on my next visit.
Paul

 

[access2010]

Gasman
Since my visit to the Colliers Cheese factory, I keep on buying their great product.

Regards,
Paul

 

[isladogs]

isladogs
Sorry for my error.
I am in Canada and the work that I am doing is being Shared between all the Charities, that have endowments.
Are you near Surbiton. UK and if yes, I can have you join us for a beer on my next visit.
Paul

Thanks but I'm a long way from Surbiton!