Search results

actually when the user input a date in text18, the age (yr,mth,days) will be calculated upon user click "OK" button. the reason for storing the calculated age (yr,mth,days) is because if i don't store this info then it will be troublesome for the user to click "OK" button everytime he/she wants...

hi, refer to attachment (sample.zip): i have a table "tbl Data Entry". how can i update all the records in column "AgeYrsMthsDays" upon one click at the "OK" button? e.g: user input a reference date at "Text18"...let's say 01/04/2007 (dd/mm/yyyy) upon user click "OK" button, all the...

i have a form "A" with two textboxes called "txtName" & "txtResults" i have a table "tblA" with two columns "PersonName" & "PersonResults" upon the form is open the data "PersonName" & "PersonResults" is loaded into the textboxes respectively. upon clicking the "OK" button inside the form...

how shall i correct it?

Hi, I have a Public Sub in my modules: Public Sub CalcAge(vDate1 As Date, vdate2 As Date, ByRef vYears As Integer, ByRef vMonths As Integer, ByRef vDays As Integer) In my form upon cmd button "OK" is clicked, it will use the Public Sub CalcAge function: Private Sub cmdOK_Click() Dim...

thanks it works. however when i wanted to edit the data for some dates, it doesn't edit properly. e.g (for some dates): original value; 12 9 i edit the data at frmInputBox to: 16 11 then i clicked "ok" at frmInputBox, although the text field at the date (frmCalender) got update the change...

thank you. now i have added a textbox called "InputTextResult" in frmCalender. - the function of the "InputTextResult" is to display the (results of adding all the values in InputText of the month). e.g: 45 3 22 = 70 ( result of InputText) 21 1 16 = 38 (result of InputText2)...

thanks for your help. it doesn't work... e.g for a date whose datas are: 20 17 20 should be in InputText 17 should be in InputText2

yes its named InputText2 the calender textbox "Text1, Text2,..." properties (on click) in frmCalender has source code for it. but it doesn't seems to work with this added in (see attachment): With Forms!frmInputBox !InputText2 = f("Text" & mynum) 'this doesn't work !InputText2.SetFocus 'this...

hi, the delete button of the frmInputBox is unable to delete the data "InputText" and "InputText2" at the frmCalender. Refer to its Dec 2006 & Jan 2007 calender, the datas are unable to be deleted from (1st to 11th Dec '06) and (2nd to 12th Jan '07). Both months have the same number (11 days)...

thanks... now that the textbox (frmCalender) can display this way: 123 abc if i were to transfer the abv to textboxs of (frmInputBox) 123 -> InputText abc-> InputText2 how shall i write? With Forms!frmInputBox !InputDay = mynum !InputDate = f("Date" & mynum)...

Dim f As Form Dim g As Form Set f = Forms!frmInputBox Set g = Forms!frmCalendar g("Text" & f!InputDay) = f!InputText & vbCrLf& & f!InputText2 e.g: InputText is 123, InputText2 is abc I wanted to display the text inside textbox of frmCalendar as: 123 abc instead of 123abc. how shall i use...

did a modification to the frmInputBox by adding a new text box called InputText2. The data can be properly stored into tblInput (InputText & InputText2). However the data cannot be properly displayed into frmCalender (see attachment)

the calender form Input_2000.zip is quite useful. how can i modify its frmInputBox to have two text fields to enter numbers only? After entering numbers in the text fields, the two numbers will be shown inside frmCalender box. perhaps can enter the numbers directly into the calender instead of...

Hi, the file combos.zip give me some rough idea abt how t_Crews table is designed. i tried to modify the t_Crews table into a different application to have "Year","Month","Day"...however the table becomes to long and troublesome...ended up will have a long record. how shall i create an...