Search results

I have tried that and it works. Is the form with the Sum textbox bound to the TABLE (consist of field profit) ? you can check this in the Form's Properties Record Source value. hope this help. mderby

Solved Thank you to two of you !!! it worked. thanks :D

Still error I added the code in it but I got this error message. Run-time error 94 Invalid use of Null How to go about it ? Thanks mderby:confused:

Hi guys, I have added a function to retrieve the last line no. from table TM0002 which has a link relationship with table TM0001 in field ProjectID. Below is the code : Public Function GetLastLineNo(ProjectID As Integer, _ Own As String) As Integer Dim rst2...

I thought this can be accomplish when you are using the wizard to create a form with subform. Regards

you should the built in date function to perform arithmetric process. try this A= Date - means today date. then use this B= DateDif(«interval», «date1», «date2», «firstweekday», «firstweek») If B >= 30 then update date. You could use the help to file up the parameter of the function. hope it...

A bit tricky Hi, It seems like the table structure needs some refinement. If you really want to display such high-level data, you might want to consider creating a master table Journey Header which consist of ELR, Track ID and Overall Start and Overall End Mile. The Overall Start field will be...

Hi fellow users, I got a main form(frmA) and a subform(frmB) which is based on 2 tbl with table relationship established Tbl1, Tbl2. the recordset update mode in frmB is disable cause all the add and update record is done in another form by just double-clicking the selected row in frmB...

Dear all, I got one table tblProject with this field: Project ProjectID Key Field Pro Name Owner got a form (frm1) with subform (frmsf1). The subform based on a query. qry1 is based on tblProject with this all the fields in it. There are one criteria for field Owner...

Hope it work Hi , I've encounter this problem before. The culprit behind this may lies in the Employee Info Form's DATA ENTRY properties. Change the DATA ENTRY property to "No" in the current form properties. The explanation behind this is if DATA ENTRY is "Yes" then the form will be in...

need more info Sorry guy, i don't guite catch what you are trying to achieve. you want to sum up a running number based on the record fetch is it ? and then display it in a text box in the form. mderby.

Mr.Bank is right and maybe can try use this to test whether there is any text in the textbox: IF ISNull(Me!Completed) then Me!CheckBox = False else Me!CheckBox = True end if Hope it works. Please let us know Cheers mderby;)

Hi Maybe you can put the code in the Completed textbox AfterUpdate event. This event will fire after user exit the textbox to another field or control. Hope it help.:D

Thank Rich, I have changed the subform to be based on a query. Thanks a lot. Mderby.

Hi guys, thanks for the help. I have tried those step but still cannot solve it. I couldn't make the subform to show the selected value of a combobox. is this code correct : Me.frmTM0002_Subform.Form.Filter = "[Project ID] = '" & Me!cmbProjectID2 & "'" Me.frmTM0002_Subform.Form.FilterOn =...

Hi all, I am working on a form(A) with subform(A1) based on a Project Master(TM0001) and Project Detail(TM0002) with parent/child relationship.The primary key is Project ID. This two form is created by using the wizard. In main Form A there is a combobox (PID) with this sql code SELECT...

Hi Ekta, After some testing , I find that to display the selected value of the combobox you need to assign it in the Report's TextBox's Control Source property. In the TextBox Control Source property it should look like this =[Forms]![Form1]![Com] If you more descriptive wording you may...

Hi guys, I had solve this issue by using parent/child forms Thanks a lot.

I suppose using subform will clear it but I just want to know how to retrieve back the Project ID (autonumber) value after an update to the form. I want to use it to link to another form. Correction to my original post. it should be "Some how I could not link the newly created Project ID in...

I think the code should be like this [Forms]![formName]![comboboxname] . But if your combobox consist of multi columns then you may have specified which columns to use i.e [comboboxname].column(n) where n is the numeric 0,1,2,3...... 0 mean first column. Another issue might lies with the...