Search results

because i am inputing the month only and not the whole date. how can i use the month only?

i use the format function to display month, here is the code below: Format(MthInput, "mmmm") however, whatever MthInput value is used say 1,2,3... the month display will always either be december or january why is this so? i want it to be 1 -> january 2 -> feburary...

is it possible to have two colors for a textbox? e.g: a textbox named textbox1 upon form load the textbox1 will be filled with two colors, green at the top half and red at the bottom half

hi, i have a command button which is initially disabled. whenever i key in any data into a text field, the command button will be enabled. now my problem is how can i disable the command button after clicking it once? Private Sub CommandButton_Click CommandButton.Enabled = False End Sub...

i have already Dim C as Single, see above

i can't get two decimal place...anyone can advice me how to get two decimal places? e.g: Dim a As Integer Dim b As Integer Dim c As Single a = 18 b = 7 c = a / b f.Text138 = c the result i got in textbox "Text138" is 2.571429 the "Text138...

i use the code to sum up values and store into another table: Set Db = CurrentDb() sql = "Insert Into tblQPIYearly (Select InputYear, Sum([Monthly TotalPF]), Sum([Monthly Rejection]), Sum([Monthly TotalAvoid]) From tblQPIMonthly Group By InputYear)" Set rs = Db.OpenRecordset(sql) db.close...

how do i use a qurey?

how do i sum up all the values in a table with reference to the column mth/year e.g: yr 2007 and put the result in another table? refer the jpeg image.

i have a statement like this: rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100 how can i have two decimal place?

hi, whenever i key in some data into a form i will transfer the data into a table. whenever i want to change some data in the form i will delete all the records in the table and re-add all the data from form into the table. the abv method works. however, i find that it is not effiencent...

here is the function which i re-edited. the codes that were not affecting the program have been deleted. Public Sub PutInMonthlyRecords() Dim sql As String Dim Db As DAO.Database Dim rs As DAO.Recordset Dim f As Form Set f = Forms!frmQpi Set Db =...

i am using a textbox in the main form to transfer the Yr/Mth into the table. (refer to qp.zip) now my problem is, how do i prevent duplicate records into the table? e.g: currently whenever i scroll ard the months control in the form, i will get duplicate Mth/Yr into the table. how do i prevent...

with reference to qp.zip at the form "frmQpi", there are 3 textboxes at the left. the datas for the 3 textboxs are computed by some formulas in : Public Sub PutInData() how shall i store these data into table "tblQpiMonthly" respectively with reference to the Mth/Yr as mentioned in the...

i have a form with two combo boxes cboMth and cboYr i also have three text boxes in the same form with computed results: txtA,txtB,txtC. now how can i store txtA,txtB,txtC with reference to the (Mth and Yr) into a table? e.g: the table will looks this way (below) ===== ==== ==== ====...

how shall i do it? can show me how to do it which can produce the same result as i wanted? thank you.

i want to save the computed age. refer to sample1.zip the result only compute for "apple" i want to have result of all the persons ( banana, durian) as well.

sorry i forgotten to upload the sample1.zip Rich, i am new to ms access...can illistruste how to use that command?

thank you. however, i wanted something like this (below) the purpose of the "OK" button is to allow user to enter a reference date and "OK". What I needed is something like this: (refer to sample1.zip) 1. at the tab -B- 2. enter (a Ref. date) lets put in 01/04/2007 3. click "OK" 4. the...

upon a user enter a reference date and clicked "OK" once. all the calculated age for all persons will be updated in the "AgeYrsMthsDays" column of the table.