 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007form error
Help! I am using a command button from a subform to open form and I am getting an error. It says "the table tbleActivityNote is already opened exclusively by another user, or is already opened by the user interface and cannot be opened programically". I have this same concept on 3 other forms with now problems. THanks for any ideas. Did you bind your forms to tables or queries? You should be using queries. >Help! I am using a command button from a subform to open form and I am >getting an error. It says "the table tbleActivityNote is already opened >exclusively by another user, or is already opened by the user interface and >cannot be opened programically". I have this same concept on 3 other forms >with now problems. THanks for any ideas.  SignatureHTH - RuralGuy (RG for short) acXP WinXP Pro Please post back to this forum so all may benefit. I have tried both. I get the same error. > Did you bind your forms to tables or queries? You should be using queries. > [quoted text clipped - 3 lines] > >cannot be opened programically". I have this same concept on 3 other forms > >with now problems. THanks for any ideas. Are you trying to open the same table as the MainForm is bound to? What kind of Record Locks do you have set on the Data tab of both MainForm and SubForm. Use queries on both. >I have tried both. I get the same error. > [quoted text clipped - 3 lines] >> >cannot be opened programically". I have this same concept on 3 other forms >> >with now problems. THanks for any ideas. SignatureHTH - RuralGuy (RG for short) acXP WinXP Pro Please post back to this forum so all may benefit. I had a record lock somehow. Thank you very much. > Are you trying to open the same table as the MainForm is bound to? What kind > of Record Locks do you have set on the Data tab of both MainForm and SubForm. [quoted text clipped - 7 lines] > >> >cannot be opened programically". I have this same concept on 3 other forms > >> >with now problems. THanks for any ideas. Cool! Sounds like you got it resolved. Great news. >I had a record lock somehow. Thank you very much. > [quoted text clipped - 3 lines] >> >> >cannot be opened programically". I have this same concept on 3 other forms >> >> >with now problems. THanks for any ideas. SignatureHTH - RuralGuy (RG for short) acXP WinXP Pro Please post back to this forum so all may benefit. |
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
|
©2009 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.