Search results

wonder why no value at BasicPremium after i change value at CC.. even i make command button, it not work either.. it work fine at NCD combobox.. help me plz...

as a title, how? coz i want make report based on value that calculated at form where data value is unbound.. i use ms access 2K i make calculation on my form.. and ofcoz the result is in unbound textbox.. but when i try to make report of the result, it need table or query to make it.. so i...

Help plz If Forms!f_Main.Coverage = "Comprehensive" Then If Forms!f_Main.CC = "0 - 1400 cc" Then Forms!f_Main.BasiPremium = (Forms!f_Main.SumInsured - 1000) * 0.026 + 225.2 ElseIf Forms!f_Main.CC = "1401 - 1650 cc" Then Forms!f_Main.BasicPremium = (Forms!f_Main.SumInsured...

how to make calculation in form accept null value when using Iif in query? like this Extra1: Iif([company]=-1,50) i use company as check box.. when i check it, 50 appear at texbox at form..then i click at calculate button (to calculate quotation) have no prob... but when check box not...

how do i make 2nd combobox list based on 1st combobox list, mean if i choose A at 1st combobox, only A1-A5 option appear, and when i select B at 1st combobox, only B1-B8 appear to select at 2nd combobox.. TQ

i need to update some textbox value when insert some value at another textbox.. like when i add 3 at 1st textbox, 2nd text box will calculate it auto matically wit this formula, 2ndtextbox = 1sttextbox - 1 ... so where should i type ? query? how? default value? if need to wrte code, which 1 i...

if i use Date() as default value at my field, can i save it? i mean it not change when next day come for some record. coz i want to use today's date as default date to some record. when next day come, date for that recoerd still at yesterday's date.. or there have any other way to do it? TQ

error, cant trace, how to fix it? Private Sub cmd_calculate_Click() Dim daoRS As DAO.Recordset Dim strRS As String strRS = _ "SELECT COUNT(*) AS [Counter], " & _ " AVG(NZ([A1-1],0)) AS [Aa11], AVG(NZ([A1-2],0)) AS [Aa12], AVG(NZ([A1-3],0)) AS [Aa13], AVG(NZ([A1-4],0)) AS...

any1 know how? to get value from each row record. instead of this: rsSurvey.Fields("SalesmanName").Value TQ

plz refer to this link... http://www.access-programmers.co.uk/forums/showthread.php?t=107692 TQ

hi there.. i make simple system to make calculation in the end of each month bout point that car salesman from customer bout our their service i make cmd button to calculate where criteria (by salesman name and month) based on combo box then the result (calculation) return to box.. i make 2...

as i know, i can import data from excel. but is it possible to make data permanently at excel? i mean Access as a system n excel as data storer.. if possible plz tell me how... thanks

i'm making form from query. but all i need to do is calculate days worked (TimeService) either worker still working or resigned. i want to know is it possible to make it condition like it to query? if not can u tell me the other way?

can i post link to give example that i get from other site? http://www.fonts....tm#accessvba

can i change date format that contain day, month, and year to month and year only.. i try change at fromat at porperties, but it change back into dd/mm/yy at combo box.. this is bcoz i want to filter up my subform that contain parts that purchased by customer by month.. thanks..

some 1 plz tell me how to write the code for change form view when cliking open form command button... i try setting at form to datasheet view but when i click at command button it show single form view.. thanks..

what is "your content here" for? at left hand side.. empty.. :confused: :eek:

does any1 here know what is System Volume Information folder for (in Windows XP)? coz it take huge disk space and i cant install new application coz from it.. can i deleted it content? and what happen then? thanks... :confused:

i installed new Win98 at my PC but after it done,i restart then my cd-rom gone..windows no longer detect my cd-rom... but BIOS detected cd-rom..only when in windows it gone..:mad: help me how to solve it..

hi... firstly, i created some report based on query. then in my form i create list and combox to list down all primary key that had in query.. what i want to do is open report, based on criteria that i selected from combobox or list box... i create both cbo and list box to compare which 1 is...