Selasa, 25 Juli 2017

Re: [MS_AccessPros] Close form question

 

John,

The macro is running a query that is a make table query and then an update query on the table . I am assuming that the table is not built and updated yet before the form closes. But the unload event did not work.

Jim Wagner



On Tue Jul 25 2017 10:26:16 GMT-0700 (US Mountain Standard Time), John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

Jim-


Try using the Unload event instead.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Jul 25, 2017, at 7:20 PM, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:




Hello all,


First, Thank You for everyone's help that I have received from this forum's members. I appreciate it very much. 


I have found a form on a database that we support that has a macro that runs from the On Close event. There is a macro that runs 2 queries and then a Function. When I try to put the form in design view, I receive an error message stating that a table is locked by another user. I am supposing that the table is behind the queries that are being run. How do I stop this message from appearing? the form previously was on a tabbed form and we are moving the form off of the tabbed form. I am assuming that because it was on a tabbed form, it never gave that message box. How can I suppress the message? Is there another event to put the macro or converted vba on?


Thank You

Jim Wagner




__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar