Search results for query: *

Hi, thanks for that suggestion - for some reason the acCmdUndo wouldnt work, but taking it out and leaving the DoCmd does work. I have finally solved my inital problems by using SQL = [SQL Code] me.recordsource = SQL me.requery ..rather than using different recordsets at once, for anyone who...

Hi, thanks for the speedy replies! I put your suggested code into the Private Sub Form_Close() DoCmd.RunCommand (acCmdUndo) A runtime error occurs '2046' 'The command or action 'undo' is not available now' I put a code break at this method, and the message box saying about duplicate values...

Yes i do have warnings set to false in one the of the search buttons - but if they are set to false would it then mean it wouldnt display the message? I commented them out and tried it there and it still comes up with the same message..

Hi, my problem is that i have an Access database which makes use of the command buttons assocaited with docmd eg. DoCmd.GoToRecord , , acNext. I've come to realise that any changes made to the records displayed on my form will be automatically saved. I have been asked to put in 2 search buttons...

Thank you Soooo much! I'll try it out on monday when im back in at work *crosses fingers it will work* :) Dorinda

Hi there, i was wondering if anyone could possibly help me. I am working on a macro in excel which automatically sends an email when saved. The email has to be sent to a group, and the code i have is : Dim objSession As Object Dim objMessage As Object Dim objRecipient As Object...