Search results

i'm sorry i have removed the brackets but still getting the same error message :variable not defined,actually VBA highlited this part of the code: "Set reop_db ="

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

i think the real problem is because i stored the new price and the old price on the same field, it will disturb the total value for my query that i use in my report.... so should i make another field to store the new price? or is there any idea? thx

could u give me any example of how update query being used?

is there any example to search the last date price? thx?

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

it works perfectly.... thank you so much.. :)

i think that the textbox can't be formatted.. because i've changed around the format a little bit in the textbox but still it has the same format value... and it's just not percent but the other valus also doesn't change like currency.... so is there a any idea?

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

i've found the solution buy changing the form's record source and set the list box control source... thx

Could you give a a bit of example on those two ways? thx

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?

you're so right... thanks... :)

sorry guys.. but after i restarted my project the tot_valtxt.value return with "0" value... i assumed that because access did not read value of listbox12 because the listbox12 has the value from row source that originally came from a query... so is there any suggestion? ps:it works fine when i...

Works perfectly... thank you.. btw could you tell me whyis my code doesn't working, so i can learn from my mistake?

nope it's not working, i got a message "invalid use of null".....

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

Okey i've changed to value property and it works... Thx a lot!