Recent content by mfuada

suppose i have a table like this: Table1 ------------------- Product | Price ------------------- A1 | 50 A2 | 10 A3 | 30 B1 | 20 B2 | 30 C1 | 20 C2 | 20 i'm thinking more of a grouping the field with value "A"...

Hi guys... i want to do sum query by selection, i have these datas on singel table: A1 = 50 A2 = 10 A3 = 30 B1 = 20 B2 = 30 C1 = 20 C2 = 20 and i would like to create a query that sum just "A","B",&"C" so the on the datasheet would be : Sum of A = 90 ; Sum of B = 50 ; Sum C = 40 is there anyway...

my first intention in using "format" is because if i just wrote this code:. coupon_bbtxt = listbuyback.Column(5) and suppose the listbuyback in column(5) has the value of 15,50% then the coupon_bbtxt will return the value "0,155" although i have change the format to percent and decimal to 5 of...

I have change my line to : Me!coupon_bbtxt = Format(daftarbuyback.Column(5), "0.00000%") but still get the error message "Data type conversion error"...... but when i'm removing the "format" and the "0.00000%" the code working just fine....

hi i want to ask u guys.. coupon_bbtxt = Format(listbuyback.Column(5), "0.00000%") --> my textbox that get its' value from a listbox Set buyadd_db = CurrentDb.OpenRecordset("buyback") buyadd_db.AddNew buyadd_db!coupon_bb = Me!coupon_bbtxt buyadd_db.Update the field "coupon_bb" has percent...

i've added the "debug.print sql" and remove the commas before where and i have s message error like this "syntax error(comma) in query expression '(0,05)' " and i also have a message on immediate windows : UPDATE var_coupon SET face_value_var = (2100000000000),coupon_var = (0,05) where...

Hey guys could anyone tell me whats worng with my sql startement... cause access keep telling me "Syntax Error in UPDATE statement" and i just can't find where my errors are... here's my code: sql = "UPDATE var_coupon SET face_value_var = " & outs_reoptxtvar.Value & ",coupon_var=" &...

Thank you so much guys for the replies.... But i think my problem is that the function read the "0.5" value and NOT the value that i entered on my access form.. so if i input 0.50 the the function will round down the value into "0" and if i input the value 0.51 the function will round up to...

Hi.. i have this code . my plan if i have value of x = 10,50 then it will round down into value x = 10, but if x = 10,51 then it will round up into x=11 so can anyone help me? this is my code : Function RoundPriceSPN(varNilai As Double) As Double Dim x As Double If varNilai <= 0.5 Then...

Hi.. i'm really sorry.. it took me along time before answering ur post.. i tried to post my db yesterday but it alwas failed.. so hope this day it will work.. i'm not an access expert so i hope you will understand my DB,because i know it's not structured correctly... the question that i want to...

Can you guy tell me how to publish access in access 2007? so that user who doesn't have a microsoft access program can open the application that was created in access... thx

Hi guys i've found a code that seems to me it's calling the excel function to be used in Access vba, i just want to ask u guys the explanation about the code below.... thx Function PRICEsun(settlement As Date, maturity As Date, rate As Double, yield As Double, principal As Double, freq As...

hey guys this is my code: Private Sub Command43_Click() Dim reop_dbvar As DAO.Recordset Dim dbs_var As DAO.Database, sql As String Dim dbs_var2 As DAO.Database, sql2 As String Dim strface As String strface = Me!series_reoptxtvar.Value Set reop_dbvar = CurrentDb.OpenRecordset("reop_var") Set...

for the update query.. i enter the query design mode.... show table_a and table b in fill this field :face_value_outs table :table_b and when i want to fill the "update to" there's no option to choose.. should i write it manually on that field that happen to with the ""criteria"...

okey.. i'll explain a little bit my first intention on this code... right now i have two tables: tables_a and tables_b tables_a : no,series,face_value tables_b : no,series,date,face_value_outs face_value is the initial value when user input the data for the very first time, but from time to time...