Recent content by Gurbo

yup , that's workin' right now .. Thnx

That works & rocks :) Thnx mate ,

Hi, I'm having the referencing problem.Cant figure out how to equate the textbox> txtResult1 on the my form with the Field > Hisse , from the Query > Select_MaxWgt . Here's my code for the Calc button: Private Sub cmdCalc_Click() Dim Bank As Variant DoCmd.RunCommand acCmdSaveRecord Dim...

ok , Thnx all for your interest and patience ... Problem is with Form > frmEnterLexio That should not work becouse i've broke Excel<-->Access link. Table > tblWgtFactors gets values from frmEnterLexio Queries > Max_Wght & Select_MaxWght refers to Table> Sheet3 , but i've deleted it ...

The variables are entered on a form which update tblWgtFactors. A cmd button activates the code which then initializes the table

Voila, no record. All 0s The code has an error for working with the recordsets i think , it clears the new data from the table (which contains the variable, that are needed for finding the Max value) ... it empties the table

Hi, In my form , there exits a Calculate Button. When user clicks , some calculations are made and outputs are recorded to a Table. I want to display that table/query as a Sub-form ,, but the problem is , Sub-form attached to my main form does not reflect the recent values ( updated values )...

Hi, I've got a project dealing with various Decision Making Algorithms. Wondering the VBA code of ; Selecting the MAX. value from a table that has 1 record, which has 12 user-input (integer) attributes . ex: Table tblWgtFactors > Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11...