Re: [MS_AccessPros] Win98 "The object is locked" message

Hi Dave,

try this code for the CLOSE button on your form:

DoCmd.Close acForm, me.Name, acSaveNo

Warm Regards,
Crystal

How To Make a Graph with Microsoft Access (cc)
http://www.youtube.com/watch?v=YhgNX6BWWmk&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0
- Create chart, change what data is displayed including formatting,
chart type, titles and legend

~ have an awesome day ~

On 6/17/2015 8:18 AM, 'Dave W' davewi11@yahoo.co.uk
[MS_Access_Professionals] wrote:
> I have a form containing a graph and text-boxes. I have code for various
> mouse events on the graph, which is an "OLEunbound" object. When I close the
> form without even touching the graph, I get the warning message:
> "The object is locked, so any changes you make will be discarded when the
> form is closed."
>
> If I have operated the mouse events, or even just set the focus on the
> graph, the form exits without the message. However I don't want to set the
> focus on the graph because it gets a black border, and the grid lines
> display on top of buttons that are normally on top of the graph.
>
> I can avoid the message by setting the graph properties to disabled and
> locked, but then I can't operate the mouse events.
>
> I've tried adding code to the form's close-event but to no avail.
>
> The warning occurs in Access 97 on Windows 98 but does not occur on XP, with
> or without converting to Access 2003 format. I have trawled the forums;
> others have had the same message but nobody has any suggestions other than
> disabling the graph or giving it the focus.
>
> Can anyone suggest a way of preventing the warning?



------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/