Search results

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...

Is there no way I can convert the code to a robust version of ADO? Why is ADO so unstable, if I can put it like that? I don't think there is a good chance that I'll get DAO working on a Win7 Access 2010 .adp project.

I'm now getting a Type Mismatch error (when using your second set of code); not sure if this error relates to your type mismatch comment earlier. Can't think why this is working on your side and not on mine. I've actually got my project in an ADP file; I've just sent the sample database in an...

No luck...got the "Object doesn't support this property or method." error on .FindFirst "Return_ID = " & formid. Do I need to reference the DAO Object Library? I've actually tried that but got the "Error in loading DLL" error.

Thanks, that would be awesome. But as I've prepared this copy I've ran into another problem...for some reason I get "Object doesn't support this property or method." on the following line of code: .Find "Return_ID = " & formid I've added the necessary references but that doesn't seem to solve...

The formid (Return_id) is a numeric value. The "MED-EGM" forms part of the description of the return but the Return_id is used to drive the search criteria. I've tested the problematic records which form part of the "MED-EGM" (the sql actually seach for "%MED-EGM%" results and I could not see...