Search results

30+ years? wow.... well until this day i have reach my +14 days on being access programmer... hehehe.. Ok guys i have a another question related to my previous question, right now i have table with these fields: no; series;maturity_date;and nextdate_coupon_payment; maturity_date is table to...

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

This is what COUPNCD does, it's a semi-annual coupon bond pricing, It determines the next coupon/interest date after the settlement date. If the maturity date is 15-Jul-08 and the coupon is paid semi-annually, then the coupon dates are 15-Jan and 15-Jul (6 month difference) ignoring the year. If...

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

Thx a lot Richard.. i have tried the code on the different line and it works.. and also i have marked Require Variable Declaration on my VBA editor... Thanks for sharing this with me.... :)

Okey i see.... Could you guys give me any example of how to use it in access...

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

wow thx alot.. i'll try it for sure.... thx again!!:)

Thanks a lot... :)

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

hi.. my first plan with the code is when i click the "save" button then it will check the empty textbox first, and then if all field is filled the code it will save the data in the textbox to the table... that's why i use the IF statement first to check the empty textbox.. and then use open...

I've tried your code but it still input the data into the table and the validation message box did not appear....... here's my code i copy it straight from the VBA :)..... could u tell me the faults?? Private Sub Command15_Click() If IsNull(Me.series_valtxt) Then MsgBox "write the series!!"...

I've added the END IF but still getting Message error "Else without If" ... do i write the validation code wrong or maybe i'm using the IF statement falsely.. could u give me any suggestion or maybe u could give me an example of how to write the correct script... Thanks...

Hey guys.. i'm newbie in access, i just want to ask how to make validation data entry from the form entry using a VBA script. so what i want to do is when i click the save button, if one of the textbox is empty.. the program will notify the user that the one of the field entry is empty and...

Hi guys i would like to ask for your favor... right now i'm creating a table with a field named Number, with data type = autonumber, and i did not put a primary key into it. My problem is when i insert data, such as a,b,c.... the autonumber order the numbering of the data automatically, but...

Okey thanks... that help a lot... thx :)

i'm very2 sorry.. :( but i can't find the "mode" on the form properties... could you be more specific where i can set the mode to adding?? thanks!

Okey, So is there anyway when i open the form, the textbox automatically sets into new(blank) record? or i have to just make the textbox unbound with the fields in the table,which means i can't make the form, from the wizard menu.is that correct? :confused: Thx....

Hey guys, here's my problem, i have a form to input data into tabe, and i want the form to display a blank textbox which we put the input data in there... i've tried Private Sub Form_Load() inputname.text = " " End Sub and Private Sub Form_Load() inputname.text = null End Sub the...