Theodore- RunCommand acCmdDeleteRecord
You sure you don't want any confirmation? If so, open the form in Design View and with the form object selected, find the Before Del Confirm property, change it to [Event Procedure] and then click the Build button (...) next to the property. Insert the one line of code I gave you before to set Response = acDataErrContinue John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of tyki9799 > Sent: Thursday, June 23, 2005 1:05 PM > To: [email protected] > Subject: [ms_access] Re: Moving records between tables > > > John- > I see. I did so and it works fine! > > Now, what command should I use to delete the current record? And how > to associate it with Sub Form_BeforeDelConfirm event procedure so I > don't get a message? > > Theodore > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Theodore- > > > > Use my code instead. DoMenuItem is an obsolete command supported > only for > > backwards compatibility with Access 95 (hence the acMenuVer70). > > > > As I told you, add a BefofeDelConfirm event procedure to > the form. Like > > this: > > > > Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As > Integer) > > ' Tell Access to not display the confirm message > > Response = acDataErrContinue > > End Sub > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] On Behalf Of tyki9799 > > > Sent: Thursday, June 23, 2005 11:51 AM > > > To: [email protected] > > > > Subject: [ms_access] Re: Moving records between tables > > > > > > > > > John- > > > > > > No, field1 doesn't always have an Offer value. It's only needed in > > > Orders. Normally (99% of cases) it remains blank and it's > assigned a > > > value only when the Offer is accepted by the Customer and > the Offer is > > > proceeded to an Order. But I came to a solution: I put > the following > > > code in the start of the segment and I got it right: > > > > > > DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, > , acMenuVer70 > > > > > > The only thing left to do is to make the current record be deleted > > > without getting any messages. How would I? > > > > > > Theodore > > > > > > --- In [email protected], "John Viescas" > <[EMAIL PROTECTED]> wrote: > > > > Theodore- > > > > > > > > I don't understand what you mean by "when field1 value > is already > > > there I > > > > get no trouble." Is "field1" a value saved in > tblOffers? If the > > > field is > > > > missing in an Offer, you must set it *and save the > record* before > > > running > > > > your code. Perhaps you need: > > > > > > > > ' Check to see record is saved > > > > If Me.Dirty Then > > > > ' Nope, save it > > > > Me.Dirty = False > > > > End If > > > > > > > > .. before all your other code. > > > > > > > > You can throw away the confirmation for a delete in the form's > > > > BeforeDelConfirm event. > > > > > > > > John Viescas, author > > > > "Building Microsoft Access Applications" > > > > "Microsoft Office Access 2003 Inside Out" > > > > "Running Microsoft Access 2000" > > > > "SQL Queries for Mere Mortals" > > > > http://www.viescas.com/ > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > > > > [mailto:[EMAIL PROTECTED] On Behalf Of tyki9799 > > > > > Sent: Thursday, June 23, 2005 11:15 AM > > > > > To: [email protected] > > > > > Subject: [ms_access] Re: Moving records between tables > > > > > > > > > > > > > > > Hi John. I do just that. I go to an existing offer > (in frmOffers), > > > > > modify/add some data. I have a field field1 that is > > > Required in Orders > > > > > but not Required in Offers. So when in frmOffers I > give it a value > > > > > through a combobox. Then I hit the "Turn Offer to Order" > > > button so it > > > > > will run all the code you helped me to do. Then I get a > > > message that > > > > > field1 is required to proceed. In the other case, when > > > field1 value is > > > > > already there I get no trouble. > > > > > > > > > > Another thing that troubles me is what code to write so I > > > would delete > > > > > the current offer without getting a message. > > > > > > > > > > You're really proved quite patient with me!!! > > > > > > > > > > Cheers, > > > > > > > > > > Theodore > > > > > > > > > > --- In [email protected], "John Viescas" > > > <[EMAIL PROTECTED]> wrote: > > > > > > Theodore- > > > > > > > > > > > > Don't you have a form to edit Offers and Offer Details? > > > Modify the > > > > > offer > > > > > > first, then do the copy. If you already have the offer > > > displayed, > > > > > change > > > > > > and save it before copying it. > > > > > > > > > > > > John Viescas, author > > > > > > "Building Microsoft Access Applications" > > > > > > "Microsoft Office Access 2003 Inside Out" > > > > > > "Running Microsoft Access 2000" > > > > > > "SQL Queries for Mere Mortals" > > > > > > http://www.viescas.com/ > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: [email protected] > > > > > > > [mailto:[EMAIL PROTECTED] On Behalf Of tyki9799 > > > > > > > Sent: Thursday, June 23, 2005 9:36 AM > > > > > > > To: [email protected] > > > > > > > Subject: [ms_access] Re: Moving records between tables > > > > > > > > > > > > > > > > > > > > > I see. What could I do if change some data on the > > > current record > > > > > > > (current Offer) before I amend it to an Order so I would > > > > > pass the new > > > > > > > data to the Order? That is, how do I update the current > > > > > Offer record > > > > > > > before make it an Order? > > > > > > > > > > > > > > Theodore > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
