Search results

  1. E

    problem to change form title

    Hi Gasman. Thanks for reply. When I code like Private Sub Form_Open(Cancel As Integer) Dim formArg as String FormArg = Split(Form.OpenArgs, ",") Me.Caption = FormArg(1) End Sub I'm getting error message: Compile error: Expected array How to fix the problem? Thanks
  2. E

    problem to change form title

    Hi All. I would like to open form with according title. For that I create following code: Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) FormArg = Split(Form.OpenArgs, ",") Me.Caption = FormArg(1) End Sub When I run the form I'm getting error message...
  3. E

    how to highlight new record in continuous subform

    Thanks a lot. Works amazing. Just can you explain or point me where I can read. The last statement in the Save event closes the form, but after that the logic goes to the Unload procedure instead of completing execution and passing control to the parent form. I would like to fully understand...
  4. E

    how to highlight new record in continuous subform

    Hi arnelgp. Thank you for your help with demo file. In your newRecordForm form I just insert Save button in order to have similar functionality as I have and copied and pasted your code to click button event after that I lost option to highlight and select new added record on subform. Here the...
  5. E

    how to highlight new record in continuous subform

    Hi CJ_London. Thanks for reply. In continuous form I created highlight current record. I would like highlight new added record. What I mean. When I create new record in the child form and when child form closed the control return back to the parent form where subform located in the page of Tab...
  6. E

    how to highlight new record in continuous subform

    In generally is it possible to highlight new added record in continuous form? If yes. How it to do? Thanks
  7. E

    how to highlight new record in continuous subform

    Hi theDBguy. Thanks for reply. I substitute DoMenuItem to DoCmd.RunCommand acCmdSaveRecord and when click Save button got the same error message. The control name is correct. When I used like DoCmd.RunCommand acCmdSaveRecord Forms!fInventory!fDeviceSubForm.Form.Requery DoCmd.Close acForm...
  8. E

    how to highlight new record in continuous subform

    Hi All. I would like to highlight new record added to continuous subform in the parent form. For that I used code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToControl "fDeviceSubForm" DoCmd.GoToRecord , , acLast Forms!fInventory!fDeviceSubForm.Form.Requery...
  9. E

    problem to requery subform data

    Thanks a lot
  10. E

    problem to requery subform data

    Hi All. The fInventory parent form has Tab Control where I located the fDeviceSubForm and button which call child form to create a new record. All controls located in detail section. When click Save button a new record successfully saved. But the code line...
  11. E

    delete record on continuous form

    I inserted On Error Resume Next in the code Private Sub cmdDelLocation_Click() On Error GoTo cmdDelLocation_Click_Error Dim rsL As Recordset Set rsL = Me.fLocationSubForm.Form.RecordsetClone If rsL.BOF And rsL.EOF Then Me.cmdDelLocation.Visible = False Else...
  12. E

    delete record on continuous form

    Hi MajP. Thanks for reply. Now, when I click the DELETE button and then in the first or second confirmation message I click button No, I get a popup like this. But if I clicked in the first and second confirmation the button YES to delete record, and in the third confirmation I click NO, no...
  13. E

    delete record on continuous form

    Could you show in a code what need to do? Thanks
  14. E

    delete record on continuous form

    Hi theDBguy. Thanks for reply. The attached file is last version of DB related to locations. When you unziped file run fInventory form. Thanks
  15. E

    delete record on continuous form

    Hi All. I met a new problem during delete record event. When I selected record in continuous SubForm and click Delete button I'm receiving one by one two confirmation to delete a record. The continuous SubForm and Delete button located in a page of Tab Control in the Detail Section. Private Sub...
  16. E

    delete record on continuous form

    Hi arnelgp. Thanks for reply. It works. Thanks a lot.
  17. E

    delete record on continuous form

    That is screenshot of fInventory form
  18. E

    delete record on continuous form

    The subform and button locating in the Form Detail. Thanks
  19. E

    delete record on continuous form

    Hi theDBguy. Thanks for reply. I have fInventoty form with Tab Control. In page Delivery of Tab Control I putted fReceiveSubForm that is continuous form and Delete button. Thanks
  20. E

    delete record on continuous form

    Hi All. To delete record on continuous form I created button with code Click event: Private Sub cmdDelDelivery_Click() If MsgBox("Do you wish to delete this record?", vbYesNo, "Delete Confirmation") = vbYes Then If MsgBox("Are you SURE you want to delete this record?" & vbCrLf & _...
Back
Top Bottom