asked on

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

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Kind of vague here. What is the code you are using and where ?

mx

GRayL

Me.Visible = False
Me.Refresh

??

Eddie Antar

ASKER

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

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

but Refresh only applies to data ...

Clearly some anomaly on that system ...!

mx

GRayL

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?

Eddie Antar

ASKER

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.

GRayL

Did you try my suggestion at http:#a24456107 ?

Eddie Antar

ASKER

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

GRayL

So when you tried it, the form remained visible? If so, say it.

GRayL

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?

ASKER CERTIFIED SOLUTION

Eddie Antar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Kind of like this one:

https://www.experts-exchange.com/questions/24540873/Database-window-Not-Visible-in-Access-97.html?anchorAnswerId=25695248#a25695248

:-(

Eddie Antar

ASKER

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