Search results

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

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

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=" &...

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

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

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

hi guys i get a error message like this: "Compile error:variable not defined" and here's my code: Private Sub Command36_Click() Set reop_db = CurrentDb().OpenRecordset("reop_fixed") ->highlited by VBA reop_db.AddNew reop_db!date_reop = Me!reop_datetxt reop_db!series = Me!series_reoptxt...

Hi right now i have a table that has these fields: No;series;payment_date;price the problem is when a user input the data for the first time on a form,the payment_date is automatically generated by a function based on a certain date that the user wanted to, and if a series has the payment_date...

hi guys i need some suggestion.... right now i have a table that store a price, the structure is like this: table : values fields: date_purchase,item,price And i also have a report that shows total sum of all item's price, i make it by building a query to sum all the price of every item... the...

Hi.. i have textboxes in a form that look up its value to a listbox. and i have the code like this: Private Sub List18_AfterUpdate() series_fc = List18.Column(1) maturity_fc = List18.Column(2) coupon_fc = List18.Column(3) face_value_fc = List18.Column(4) End Sub the problem is the format...

Hi, right now i have a report with this view: year :1999 price: 20$ item : box a year : 2000 price : 30$ item : box a i would like to change the position of those field so my report will have this view: year :1999 year:2000 price: 20$ price:30$ item: box a item ...

Hi... can i display a value from query to an unbound textbox? such as if i want to display a data from a query to a textbox that placed in another form.. can i do that? i've tried by building an expression but i get the error message "#name", can anybody give me an idea?

Hi this is my script : Private Sub Command45_Click() tot_valtxt.Value = currency_ratetxt.Value * Listbox12.Value End Sub if i click the button, the textbox tot_valtxt.Value is blank... the listbox12.value is a listbox with a row source from a query. So what i would like to do is to add a...

Hi.. i have a question Could we manipulate data in the table? such as if we do some mathematical operation with the data on the table.. maybe we add or subtract, the data with some value of a textbox in another from.. could we do that?? thx

Hi guys i need some help... Right now i want to multiplying values from a textbox and a listbox into a new textbox,the condition are: 1. the listbox has a row source from a query,so the data that displayed in that listbox is based on a result of a query that sum value from a table. 2. user...

Hi guys Need ur help...I want use Excel worksheet functions COUPNCD in my VBA code for Access.. do i have to elaborate the function into mathematical operation? cos i didn't find any function in access equivalent with that function.... thanks...

Hey guys is there anyway i could put Excel function in Access? like function for financial like:YEARFRAC, COUPNCD,etc could anyone give me a suggestion? Thanks

Hi guys... is it possible to save the result of the query into a new table? i have a query of total sum of field in some table.. and I'm going to display that query into a report and then save the result of the total sum query(the value) into a new table, so that i have a documentation of the...