System messages

[Rachael]

How do I turn system messages off when a form is closed? I know about the setwarnings macro , are there other ways? Any suggestions would be appreciated.

Thankyou in advance, Rachael

 

[Jack Cowley]

What message are you getting when you close a form? I generally do not get messages when I close a form....

[This message has been edited by Jack Cowley (edited 11-06-2000).]

 

[Rachael]

Thanks for your reply Jack,
I have charts embedded on the form and when I close the form I get 'The Object is locked and changes wont be saved unless......etc etc', I don't care about this because I want the charts to be locked and not be changed but I don't want the message. Because I have three charts, I get the same message three times, it's annoying!

 

[Jack Cowley]

Rachael -

Through a rather circuitous route I will try and assist you. I know zip about graphs but a friend in Sydney does and these are her questions to you....

"It's a bit out of context so even guessing is tricky. Do you know whether the charts are dynamic or static - ie do the charts change as data is changed?

"I presume they are probably dynamic but she does not want users tinkering with what is displayed.

"If my presumption is correct, then she has a problem with the underlying chart - but without actually seeing it in context, it's a little tough to know what to advise."

If you will put up your answers I will give her this address and tell her to look here tomorrow for your reply and I will let the two of you try to sort it out.....

HTH,
Jack

 

[Rachael]

Thanks Jack, your help is appreciated.

The graphs are generated using the chart wizard in access (Microsoft Graph 2000). I have linked the charts to data on a form so yes, the charts are dynamic, as the user navigates through the form records the chart changes to reflect the current record on the form. All this works very well but when I close the form I get the message

"The object is locked, so any changes you make will be discarded when the form is closed. Click Save as/Export on the File menu and save the object under a different name"
(OK button and the Information symbol)

The form has three different charts on a tab control and when I close the form I get the above message anywhere from 1 to 3 times (depending on whether I've opened their tab control or not I think).

The message occurs after the form is closed (which returns to the menu) and appears over the menu. I also get it when I go to design view of the form.

It doesn't affect the program apart from the fact that it's very annoying.

Thankyou Jack and your friend in Sydney

Rachael

 

[Jack Cowley]

Rachael -

It is all Greek to me but Catherine has this message link and she just said that she will look at it tomorrow as she is off for home just now....

Jack, The Go-Between

 

[Jack Cowley]

Rachael -

Here is Catherine's reply, in toto, to your problem.....

"The first thing I note is that Rachel is running Office 2000. That means MS Graph 2000 – something I’ve yet to play with, but after MS Graph 97, it must be bliss.

"I tried emulating her problem, and eventually I managed it with some test data I use for graphing. The problem Rachel has lies in the property sheet for the embedded graph. My bet is that she has both enabled and locked set to “Yes”. This combination gives Access the excuse to assume that even just looking at the graph may have produced some change – technically it is possible for a user to break into the graph and make changes with this combination of properties even though the changes will be discarded.

"So the probable solution for Rachel is to set the graphs properties thus: Enabled: No and Locked: Yes. I say “probable” because I have no clear idea as to whether 2000 will behave in the same manner as 97."

HTH
Catherine

[This message has been edited by Jack Cowley (edited 11-08-2000).]

 

[Rachael]

Thanyou very, very much Jack for your help, and Catherine you are a genius, such a simple fix, the messages no longer appear. My database is now at a stage I'm happy with and is ready for some else to test for me.
Once again, this forum and your help has been very much appreciated. THANK YOU

Rachael

 

[Jack Cowley]

Rachael -

Catherine has asked me to thank you for your kind works. So from Catherine and I, thank you and continued success with Access and your programme.

Jack and Catherine