Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Dec 4 23:10:20 CST 2003
So I took the usual route to solving an access problem - fiddle around at random until you get the behavior you're looking for (kind of like raising kids). Turns out that after the save command, DoCmd.DoMenuItem, etc., I had a Me.Requery. I commented that out and everything began to work OK. Does anyone know why? Trying to close the app or various objects in the app,like forms that were still open, I got other messages implying that code was still running. Did this Me.Requery set up some kind of loop? Thanks for any insight, Rocky Smolin Beach Access Software ----- Original Message ----- From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> To: <AccessD at databaseadvisors.com> Sent: Thursday, December 04, 2003 8:57 PM Subject: [AccessD] You Can't Carry Out This Action At This Time Dear List: Suddenly, without warning, a (bound) (dang) form begins to give me this message: You Can't Carry Out This Action At This Time when I try to save the record (using:DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70), for the second time. First time works OK. After the first save I also get it when I try to close the form - DoCmd.Close. Before the first save everything's OK. I also can't navigate - next record, previous record, etc. all tell me You Can't Carry Out This Action At This Time. At this point I have to close the entire app. Any idea why this is happening? It's making me nutz. MTIA, Rocky Smolin Beach Access Software _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com