me.visible = false not hiding the form

Hi friends,

Have any of you ever had a situation where me.visible = false would not hide the form. It seems to work fine on my workstation and when I connect remotely to my clients workstation but for some reason, when she runs it from her copy of Access 2003, it sporadically won't hide the form.

It seems to happen only if she goes outside of Access or does something else and then goes back to the form to run another report.

Any ideas???

Thanks,
E
LVL 5
eantarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Kind of vague here.  What is the code you are using and where ?

mx
0
GRayLCommented:
Me.Visible = False
Me.Refresh

??
0
eantarAuthor Commented:
DatabaseMX I'm not sure what else to tell you. It's a form that's used to gather criteria for a report. When the Run Report button is pressed there's a line of code (me.visible = false) set to hide the form before the report runs. It works fine when launched for any other workstation but hers.

Any ideas? Version issue, maybe? She's running Access 2003.

Thanks GRayL: doing a refresh was my next shot.

If anything else comes to mind let me know.

Thanks.
E
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
but Refresh only applies to data ...

Clearly some anomaly on that system ...!

mx
0
GRayLCommented:
Open the form.  Press Alt+F11 to get to the Immediate Pane.  Type:

Forms!frmName.Visible = False
                ^-- use your real form name here

Press Alt+F11 to get back to the Database window - the form should not be visible.  What do you see?
0
eantarAuthor Commented:
Hi guys,

I haven't had a chance to test this any further. Any other ideas? If not, I'll do a couple of test to see what I can accomplish.

Thanks again.
0
GRayLCommented:
Did you try my suggestion at http:#a24456107 ?
0
eantarAuthor Commented:
Once again. Here is the situation. I've got a form with a command button that runs a report. There is a line of come that makes the form invisible right before the report is run: me.visible = false. It works on all machines except one.

I still haven't gotten a satisfactory answer. GRayL, I tried that and it doesn't tell me why this is happening on this one machine.

E
0
GRayLCommented:
So when you tried it, the form remained visible?  If so, say it.
0
GRayLCommented:
BTW if you hide a form in the database window, the form name will still be highlighted.  Click open, and presto, there is the form.  Could anything like that be happening?  
0
eantarAuthor Commented:
This issue seems to have gone away on its own.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
0
eantarAuthor Commented:
No, DatabaseMX, with this one, the situation is as I've described it in my original message. I've got code that's quite simple and clear:

me.visible = false

it would work every where except on one machine, in one spot, running Access 2003. And it seemed to not work ONLY when she did something outside of the app and came back to it (nothing specific, it seems like ANYTHING). I don't know if that was an AC03 version issue or what. But since then, she's given up on it. And so had I.

E
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.