 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2008You cancelled the previous operation error
I am getting this error and I tried Compacting and decompiling the database and all that jazz and I still get this error. Its a 1 table database, nothing complex going on here. I have a form that I do a search on so information gets updated in my sub form. In my sub form I have more search criteria that should update to my sub sub form. Right when I update the combo box in my sub form I am getting this error message on this line: Me("frm_OffsetWells_sub2").Form.RecordSource = LSQL This line is in my After_Update Event on the combo box being updated. frm_OffsetWells_sub2 is the name of my sub sub form. Here is the entire code for this Event: Dim LSQL As String If Forms!frm_OffsetWells!Combo12 = "" Then LSQL = "select * from dbo_DDXLMO" LSQL = LSQL & " where WellType = '" & combo17 & "'" Me("frm_OffsetWells_sub2").Form.RecordSource = LSQL End If Please help or let me know if you need more info! Thanks! Ok I found out why the problem is arising, but I still need help. The WellType's datatype is a Number. If I change it to a Text than I don't get the error. But I need it as a number so is there a workaround so it can still do the SQL statement with the datatype being a number? >I am getting this error and I tried Compacting and decompiling the database >and all that jazz and I still get this error. Its a 1 table database, nothing [quoted text clipped - 21 lines] >Please help or let me know if you need more info! >Thanks! Remove the single quotes in the criteria part of your SQL statement. It should be; LSQL = LSQL & " where WellType = " & combo17 for a number data type  Signature_________ Sean Bailey > Ok I found out why the problem is arising, but I still need help. > The WellType's datatype is a Number. If I change it to a Text than I don't [quoted text clipped - 27 lines] > >Please help or let me know if you need more info! > >Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.