Link to home
Start Free TrialLog in
Avatar of SweetingA
SweetingA

asked on

Graph Datasheet On Form

Anyone know how to stop a graphs datasheet from momentarily popping up when the graph is being updated on a form from a text box.

it just flashes up and goes off as soon as i change focus?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of jcrozier21
jcrozier21
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SweetingA
SweetingA

ASKER

No, that doesnt help, worth a try though

A soon as the graph gets focus for the update the datasheet just reactivates itself

Regards
Avatar of Jeffrey Coachman
I have never had this happen to me, so I could not replicate this issue.
Can you post a sample db that exhibits this issue?

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide any hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.

JeffCoachman
Hello Jeff,

Apologies for the long delay, i have been away on business.

I seem to have solved the problem, albeit accidentally.

I chnaged the enabled property of the graph after updating it to stop users clicking on it but strangely this alos stopped it popping up when its updating, maybe this is a timing issue.

If it happens again at any stage while i am finishing the program i will post it.

Thanks