Search results

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...

the update to is blank....(in the update query) i also have tried this.. Dim reop_db As DAO.Recordset Dim update_fc As DAO.Recordset Dim sql As String Dim dbs As DAO.Database Set reop_db = CurrentDb.OpenRecordset("reop_fixed") reop_db.AddNew reop_db!date_reop = Me!reop_datetxt reop_db!series =...

i've tried and it's work but i have a little problem, i was adding a new record to table a, and at the same time with the same data, updating the data into table b,and the problem is the data update in the first row of table b. here's my code: Private Sub Command43_Click() Dim reop_db As...

I want to ask u guys.. can we input data into two tables by clicking only one button... in another word could we input data into one table and update that data into another table just by one singe event (event on click)... could we do that? thx

ok thx a alot.. i'll try it.. i'll let you know the result.... :)

i've tried to set "Dim reop_db As Recordset" at the top of the code and it works... thx anyway...