Recent content by scheeps

Thanks a lot Nigel, looks like that solved my problem! Appreciate everyones help.

It then returns True.

It returns False. In saying that, the previous line of code is 'If Me.Dirty Then Me.Dirty = False' as you've previously asking to me do. Should I remove this and run it again? Got the code as follow: Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click If Me.Dirty Then...

Same story, I can add a record in the Contacts table...that is in ADE.

I've added a record to the ADP Contacts table without a problem, is saves and I can move away from the record.

No luck, I still get same error. I just don't get it, how can the adp project work, but once I export to ADE I get the error?

Hi Nigel, I've made the change according your recommendation but is still get the "The command or action 'Save' isn't available now." error in ADE, in ADP it works 100%. The fact that it still fails on 'Save' and not 'SaveRecord' indicates that the ADE almost does initialized the...

Just a bit of background; the specific form saves a Contact person which is not found in the Contact Person combo box. If the contact is not found, the user double click the combo box and this frmContact modal form appears. User adds the missing contact, hit the Save & Close button and the new...

Yes, this modal form does have a record source and I'm trying to Save to the Contacts table. Is there a way to Save a record from a modal form in ADE?

I've put a breakpoint on 'DoCmd.RunCommand acCmdSaveRecord' in the adp project, I then get the "The command or action 'SaveRecord' isn't available now." error. If the breakpoint is removed, the code executes without a problem. But the ADE saved project still gives me the "The command or...

I can confirm that the code now looks as follow: Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click DoCmd.RunCommand acCmdSaveRecord DoCmd.Close Exit_cmdSave_Click: Exit Sub Err_cmdSave_Click: MsgBox Err.Description Resume Exit_cmdSave_Click End Sub and if...

Thanks for the quick responses guys, but I've made the change, saved as ADE but I still get the same error. Anything else that might cause the error?

I've got a functional ADP project which compiles and works seamlessly. But once I save and compile the project as an ADE file the only modal form's save button return the following error: "The command or action 'Save' isn't available now." The Save button's code is as follow: Private Sub...

No way!! I can't believe this, everything's working 100% after I've made the change you've recommended. I can kick myself for over-complicating things right from the start. lagbolt initially helped me creating the function, but even before that I've complicated things for myself...you probably...

I've made the recommend change and it worked...but yet again only for majority of the Returns. If I search for "MED-EGM", it works up to a point and then again starts to to return Return_id 49 (first record in the recordset) as if it doesn't refresh/reset the recordset after every search...