Ms Access You Cancelled The Previous Operation Error
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 19:09:38 GMT by s_wx1085 (squid/3.5.20)
VBA Code & Other Help Access Help Solved: you canceled the previous operation If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 of 12 Thread: Solved: you canceled the previous operation Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-29-2009,01:58 PM #1 mpearce View http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/runtime-error-2001-you-canceled-the-previous/ceb7a65e-82db-4082-b2f7-08bd0fac9672 Profile View Forum Posts View Blog Entries View Articles VBAX Contributor Joined Feb 2009 Posts 107 Location Solved: you canceled the previous operation Sorry for the length of this code, but when the below code runs everything up to the export routine is run. when the export routine is run i get: run-time error '2001' you canceled the previous operation. I am not sure why i http://www.vbaexpress.com/forum/showthread.php?26484-Solved-you-canceled-the-previous-operation am getting that error. Here is my code: Option Compare Database Option Explicit Private Sub btnImport_Click() Dim objdialog As Variant Dim objdialog2 As Variant Dim intresult As Integer Dim yestreferral As String Dim todayreferral As String Dim intresult2 As Integer Dim refdate As String Dim ech_records As Integer Dim ermc_records As Integer Dim mmc_records As Integer Dim mhh_records As Integer Dim stbhc_records As Integer Set objdialog = CreateObject("UserAccounts.CommonDialog") Set objdialog2 = CreateObject("UserAccounts.CommonDialog") Call open_(objdialog, objdialog2, intresult, yestreferral, todayreferral, intresult2) Call deleteReferrals Call import(yestreferral, todayreferral) Call export(refdate, ech_records, ermc_records, mmc_records, mhh_records, stbhc_records) End Sub Sub open_(objdialog As Variant, objdialog2 As Variant, intresult As Integer, ByRef yestreferral As String, ByRef todayreferral As String, intresult2 As Integer) objdialog.Filter = "Text Files|*.txt|All Files|*.*" objdialog.InitialDir = "x:\uhs south tx\referrals" objdialog2.Filter = "Text Files|*.txt|All Files|*.*" objdialog2.InitialDir = "x:\uhs south tx\referrals" Do While intresult = 0 intresult = objdialog.ShowOpen MsgBox "Select a file to continue", vbCritical, "!!ERROR!!" Loop yestreferral = objdialog.FileName MsgBox yestreferral Do While intresult2 = 0 intresult2 = objdialog2.ShowOpen MsgBox "Select a file to continue", vbCritical, "!!ERROR!!" Loop todayreferral = objdialog2.FileName MsgBox todayreferral End Sub Sub deleteReferrals() DoCmd.RunSQL "DELETE UHS Referrals Yesterday.* FROM [UHS Referrals Yesterday];" DoCmd.RunSQL "DELETE UHS Referrals To
Unanswered Topics Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access Corrupt DB - You cancelled the previous http://p2p.wrox.com/access/36874-corrupt-db-you-cancelled-previous-operation.html operation User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to ms access Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own ms access you programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) January 6th, 2006, 07:43 AM timmaher Authorized User Join Date: Jun 2003 Location: Swansea, , United Kingdom. Posts: 42 Thanks: 0 Thanked 0 Times in 0 Posts Corrupt DB - You cancelled the previous operation Hi, I have an access database (ver 2000). When I open the database, i get an error message "You cancelled the previous operation" Also, when I try and open and compile a for, I get another error message : "The form name Form1 is mispelled or refers to a form that doesn't exist". The second error is a bit strange as I havent had any forms called "Form1" or any macros etc. PLEASE HELP!!! Ta! Tim Tim __________________ Tim #2 (permalink) January 6th, 2006, 10:26 AM SerranoG Friend of Wrox Points: 3,947, Level: 26 Activity: 0%