ACCESS FEED: Re: [MS_AccessPros] Help with VBA

Sabtu, 29 November 2014

Re: [MS_AccessPros] Help with VBA

Hi Crystal,

I've just watched your video about making a graph - it's very good. I too love graphs, and I noticed you didn't uncheck the evil little autoscale box when setting up the axes. I'm always being caught out by this - the slightest little resizing of the finished graph can mess up all your font adjustments, so I think it would be worth warning folks about this.

Regards,

Dave W

----- Original Message -----

From: Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]

To: MS_Access_Professionals@yahoogroups.com

Sent: Saturday, November 29, 2014 5:34 AM

Subject: Re: [MS_AccessPros] Help with VBA

Hi Kambiz,

perhaps the problem is that you cannot leave the form you are already on

is the focus even going to the other form? Press the TAB key to see where you are

if you could possibly have a dirty record, try this in the code behind the form where the code is:

'~~~~~~~~~~~~~~~~~~

if me.dirty then me.dirty = false'~~~~~~~~~~~~~~~~~~

Does the EVENT property on the property sheet say [Event Procedure]? Perhaps the code just needs to be hooked up again. Put a MsgBox in the code to see if it is executing.

do you have comboboxes or listboxes that have control references? I have seen that cause problems too. I personally do not do that -- prefer to replace the SQL instead of letting it use references to controls.

Warm Regards,

Crystal

Do you want to know how to make a graph in Access? Watch this 7-minute video.
How To Make a Graph with Microsoft Access (cc)

http://www.youtube.com/watch?v=YhgNX6BWWmk

*

(: have an awesome day :)

*

On Friday, November 28, 2014 5:18 PM, "Kambiz Afshartous kenaf42@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>