Search results

I am aware of that, and also aware that a Stat package is just around the corner, the reason I am doing all this is that I wish to have full control over the calculation process and also may be I can bring this to VB ( which I never use but heard rumor that it is more or less the same as VB)...

Hey dude, You can easily be a very good buddy. :) I have survived the Variance and have done some other stuff too, like mean, SD, var, correlation, covariance. I also have a 2 distributions, normal and T (hence Gamma function too). and their inverse. So if you want we can share some codes...

Dude, I think it is a good idea... the reaseon I would like to keep the out come as a recordset is becase I can feed it into the another function that need a recordset... seems that I cannot refer to Sum afterall..:( ta anyway. JL cool hair do BTW

Young people of the universe, At the moment I am working on a piece of code to calculate Variance. The calculation procedure involve each member of the recordset minus the mean of the recordset (Xi - MnX, where Xi is the member of the Recordset and the MnX is the mean). Using Recordset.edit...

Dear young people of the universe... Last time I have made the basNormalDistribution: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=29798 this time I have the reverse of it, please give me the feed back, ta JL Option Compare Database Option Explicit Dim Area As...

Free for all... take 2 Dear all, following code is a revised version of the Normal curve, stick it into the VBA and run it, it shall work. I am thinking at the moment the reverse of it as in Confident interval, say 95%CI gives +/-1.96. will keep this tread updated... enjoy... JL Option...

Free for all Dude, Simply this will do Approximation for integration for all equations (finger cross, tested on X to the power of 1, 2, 3) it is working on the Normal curve too. at below look for the "a" and "b", this are the lower and upper limit of the equation respectively. These code is...

Dear all, I have tested the Normal curve and it is working, too happy. I cross checked with the Normal table and it matched. So this problem solved.

Possible Dear all young people of this universe, I am happy to let you know that I now manage to intergrate (well approx.) by using Simpson's Rule in VBA. I have tested it for Y=X to the powers of 1 and 2 and will test it on power 3 and more now. ultimately I think it is possible to calculate...

Dear Young people of this universe, Is there any one who can demonstrate to me how to do Integration in VBA / Access?? I have the formula but dun know how... it is the normal distribution equation... I need to have the area under curve... Option Compare Database Option Explicit Dim neK As...

Dudes, Do you think the following code will work?? Option Compare Database Option Explicit Dim SQLReportDate As String Dim tblName As String Dim repfield As String Public Sub SelectReportdate() tblName = YourForm.ControltblName '(i.e. the place that say the name of the table. Think of...

Dude, that was not what I asked, as indicated I know that option.... I need to know if, well, Access VBA codes can be splited to handle multi-tasking. and if so how. thanks nonetheless.

Shall you wish to have a quick go, I have tried this and it worked. Go to the Code, and then use the outputto method. high light it use F1 it tell you every thing you need to know. at the example below I exported a table "tblMemoField" to Excel... you would need to specify what to output...

I think you can look into the MSysObjects, go to tools options, and then unhide the System objects. a list of new table will be added. MSysObjects store information on the object created. so you have a list of things that is in the DB, tables, queries, form, and modules too. so you can play...

Is it possible to split a Access VBA programme to run 2 sets of codes in the same time. so that one will be the worker (display information) and one be the manager - ish ( constantly acknowedge the user's input and pass it to the Worker). think of the following situation... I have an interface...

I am not sure if this is what you would want, but you can gointo the design view of the Xtab queries and limit the "column head"s to your liking. Say at the table view you have column "a", "b" and "c". If you only want to have column a and b, you can limit it by putting ""a" and "b"" in the...

Hello all you wonderful people, I have got a issue that would need your help: I am working on a database where it is to export a query to Excel on press of a button in a form. The fields to be exported consists of anything from Number to text to memo. I have been testing the exportation...

Sad But True, it is possible. You could in fact have a few way to make this up. Say using Subform and Tab, Make the subform and use tab wizard. Otherwise, you can make a field bound to a different source by VBA, with the RowSource property.... By far I think the first option is easiler but...

Dude,Thanks!!!! It works very well! JL

Dear All, I have a report bounded to a query that has an expression called, say, Exp1. Exp1 is to be displayed in the Report. Exp1 consists of data that are composed by two fields, say Field1 and Field2, where: [Exp1]:[Field1]/[Field2], but for some data sets Field2 might have a value of...