T tonijel Registered User. Local time Today, 02:08 Joined Mar 5, 2006 Messages 16 Apr 21, 2006 #1 Hi, How can I make command button on my DAP to use update query that I wrote?
Smart Registered User. Local time Today, 01:08 Joined Jun 6, 2005 Messages 436 Apr 21, 2006 #2 In the on click event of the button type DoCmd.SetWarnings False docmd.openquery "[YourQuery]" DoCmd.SetWarnings true
In the on click event of the button type DoCmd.SetWarnings False docmd.openquery "[YourQuery]" DoCmd.SetWarnings true
T tonijel Registered User. Local time Today, 02:08 Joined Mar 5, 2006 Messages 16 Apr 21, 2006 #3 thx for You're advice but it didn't help.... I go on script editor on that DAP in witch command button resides and after I chose that object and action onClick I paste You're code but button remained unfunctional.
thx for You're advice but it didn't help.... I go on script editor on that DAP in witch command button resides and after I chose that object and action onClick I paste You're code but button remained unfunctional.
Smart Registered User. Local time Today, 01:08 Joined Jun 6, 2005 Messages 436 Apr 21, 2006 #4 RE:RE:Command button Can you post a copy of your database ?