Search results

Arnelgp Thanks again for the help. I don't quite get what the NZ thing is. If you have time can you translate that to English so I can look it up? Also, why do you set db to nothing?

JHB Thanks for pointing that out. I should have picked up on it myself. I did declare strCur when I defined the function but there was a typo so it showed curCur. I have edited that.

Hi I apologize if I sound a little incoherent but I have scrambled my thought processes somewhat; working on this the last few hours. The following is a simplification of what I am trying to accomplish but will stand to the question without over complicating it. I do business from Canada...

Sneuberg Thanks for the comments. I get the RGB problem and when I can understand the code that Arnelgp provided I will apply your comment re color.

Arnelgp Thanks for that. It's a little complicated for me but I am wading through it. So I am assuming that there is no universal way to define the forecolor in a form the same way as one can with a control?

Hi and thanks for taking the time I am writing a new database and am setting up some templates. In order to make changing the color of elements in forms and reports easy I would like to define them when the form loads. I have created a module to define the colors by using public variables...

Steve Will have a browse over this thanks again. A/R

CJ The date is required to determine the order of the transactions, not sure how I managed to omit that--sorry. Return of Capital does not have to be calculated. It is a lump sum of money, that receives from the company, that is applied against the total cost to date. e.g., if you had paid a...

Steve Yes Return of Capital is like a dividend in that it is a payment only and you receive no shares. The difference is that a dividend is income, which is taxable in the year it was earned. A ROC is a partial repayment of what you originally paid for the shares. Thus it is applied to...

Thanks for that Paul. It's an interesting angle that I'm going to think about. One problem,however, would be that the product would not show up in inventory if I did that. A/R

I have to calculate the Adjusted Cost Base (ACB) of a stock, shares of which have been purchased and sold over a period of time. One must also account for a Return of Capital (ROC) which is when the company pays you money without issueing shares. The ACB is the Average price payed and is used...

Hi I have been slowly plodding away at the process of learning Access and VBA. I have come to the point that I think I will have learn how to use Recordsets and was wondering if someone could confirm this before I embark on the somewhat daunting (to me) task. In order to arrive at the...

Hi Alex and thanks for the reply For the record what I have decided to do is: Create a series of pop up forms that are used to input transaction data. That way I can tailor the required data to the specific type of transaction. I then added fields to tblChemicals that store option specific...

Hi As usual I have to say thanks in advance for all the help I receive here. Without it I would be so much more confused than I am. I have an interesting sort of problem that I will explain with an analogy...

Thanks in advance for even reading through this. I am still quite new to Access but have managed to build a few databases. I have used a bit of VBA, primarily to open and close forms and reports. I am quite confused as to how to approach my next task. I suspect I may have to take on...

Galaxiom Thanks a lot for this. It explains a lot on many different levels. I have been distracted for a few days and will now dive into this again. Really appreciate your help AJR

Thanks for the suggestion. I had not thought of that approach and it will probably be a more suitable solution. Still do not understand why the linked subform does not work though.

Hi This is a pretty bonehead question but I'm at the point where it needs to be asked. I could do this as a split form (I seem to loose control over the font size that way) but the real problem is that I just don't understand the workings of the Master and Child link on a form so now seems like...

Hi Just in case someone else is trying to do the same thing I thought I should include a more detailed explanation of how I solved this. 1. For each different way I wish to view the form copy and paste the Query used as the form's record source, giving it a new name 2. Apply the criteria...

Hello Again Funny thing is that the idea of putting the record source in a VBA procedure just came to me while I was writing. A quick Google revealed that I can in fact set the record source, using VBA, when I open the form from the Nav Form. Any other ideas would be appreciated but I think...