Search results

Thanks, i need to warned the user before deleting the record...where do insert the msgbox, or do you sample vba code for delete button.

Hi Experts, i have a form and i need to create a button in a form to delete a record, do you have a sample form for this. thanks, Jon

Thank You...

Hi Experts, i have created a two textboxes (1) cboItemCode (2) txtItemName. The rowsource of the cboItemcode is a query (ItemCode , ItemName) and if i choose the specific itemcode, the itemname will also appear in txtItemName Textbox. how can i do this in AFTERUPDATE in cboItemCode. Thanks, Jon

thanks a lot....

Hi Sir, Primary Form Name : HeadRejectMachF SubForm Name : DetailRejectMachSF i have created a textbox (txtTotalQty2) in footer of DetailRejectMachSF, and need to link to textbox (txtTotalReject) in MainForm. Thanks, Jon

Thanks Sir, here's my database

No Sir, the Sum is not working in subform footer

i tried to remove the =sum in =sum(txtqty2) in subform footer textbox and it works... but if i used the SUM there the error "#ERROR" in mainform textbox.. :banghead:

Thanks i already fixed the error.. thanks a lot

i tried to remove the Form. the error is #Name? Thanks.. Jon

Hi Sir, I created a TextBox (txtTotalQty2) in SubForm footer and type a formula in Control Source Property. =Sum([txtqty2]) And also created a TextBox (txtRejectTotalQty) in Primary Form and type a formula in Control Source Property =[DetailRejectMachSF].[Form]![txtTotalQty2] But i...

Hi Experts, I created a Primary Form & a Sub Form (datasheet), the subform have a QTY Field and i need to sum this QTY Field and make it appear on a textbox in Primary Form. Please help. Thanks, Jon

This is the exact error if i load the Form. Run-Time error '2465': Reject Project can't find the field 'DetailRejectMachSF' referred to in your expression.

Hi Sir Alex, Still encounter error on Form Load, the txtpostingdate2 textbox is still visible.:banghead: This is my syntax: --------------------------- Private HeadRejectMachF_Load() Forms!HeadRejectMachF!DetailRejectMachSF!txtpostingdate2.Visible = False End Sub Please Help... Thanks, Jon

I tried the syntax below: I encountered error message.. Private Sub Form_Load() Forms!HeadRejectMachF!DetailRejectMachSF!txtpostingdate2.Visible = False End Sub ParentForm Name : HeadRejectMachF SubForm Name : DetailRejectMachSF

Hi Expert, I have created a ParentForm & a SubForm, And i need to hide some textbox in subform. i already change the Visible Properties of Subform Textbox. But still when i click the formview of ParentForm, the subform textbox is still visible. Please Help. Thanks, Jon

Thank You Sir John, it fixed my prob... Me.txtMachineNo2 = Me.Parent!cboMachineNo.Value Thanks a lot.. Jon

Sorry, this is my actual form & texbox name Main Form : HeadRejectMachF (Form) cboMachineNo (ComboBox) SubForm : DetailRejectMachSF (Form) txtMachineNo2 (TextBox) txtQty2 (TextBox) I need to update my subform (DetailRejectMachSF) txtMachineNo2...

Hi Expert, I have two forms (mainform&subform), i need to copy the textbox1.value from mainform to the subform textbox2. i tried the code below but still i encounter the code error. The txtqty2 is located in subform. Please help me. Private Sub txtqty2_AfterUpdate() Me.textbox2=...