How to keep an Access form visible but in the background
So I’m upgrading my company’s software from Access 2003 to 2016. Programmatically everything is working fine. The only issue is that we will go blind staring at the bright white background that can not be changed in 2016.
So I created a new form with a dark gray background that fills the screen, does nothing, and will solve all our problems. Only problem, if you click on this form in the background it comes to the foreground and covers up the functional forms or reports that we need to use. I don't want to make other forms pop ups because I want to be able to have multiple forms open at the same time and go back an forth between them,
Is there some way of always keeping this form in the background, or making the entire form locked so that it can’t be clicked on? Or does anyone have any other solution to the bright white background that doesn’t require wearing sunglasses all day long? I don’t mind if the screen flickers for a second if it has to cycle thru all the open forms, I just need a solution.
So I created a new form with a dark gray background that fills the screen, does nothing, and will solve all our problems. Only problem, if you click on this form in the background it comes to the foreground and covers up the functional forms or reports that we need to use. I don't want to make other forms pop ups because I want to be able to have multiple forms open at the same time and go back an forth between them,
Is there some way of always keeping this form in the background, or making the entire form locked so that it can’t be clicked on? Or does anyone have any other solution to the bright white background that doesn’t require wearing sunglasses all day long? I don’t mind if the screen flickers for a second if it has to cycle thru all the open forms, I just need a solution.
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
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.
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
Thank you Gustav. Pop up forms aren't really an option for me as I need to be able to switch between forms. The tabbed view is interesting, I didn't know that option existed. While it does solve the problem, it doesn't allow me to view to forms side by side which isn't critical but is something that we often like to do.
I actually discovered this solution, http://access.mvps.org/access/api/api0035.htm
I really have no idea what an API is or how this works, but it does work. I'm just not sure if code like this could potentially lead to problems, but my application seems to be running just fine with this code, and I just created a solid gray bmp file to use as the background.
I actually discovered this solution, http://access.mvps.org/access/api/api0035.htm
I really have no idea what an API is or how this works, but it does work. I'm just not sure if code like this could potentially lead to problems, but my application seems to be running just fine with this code, and I just created a solid gray bmp file to use as the background.
This worked in A2016? I was under the impression that it died starting with A2007.
This is when Microsoft introduced the Office Themes and changed all the Access classes.
I played around with it for a bit trying to port it, but I could not get it to work and and never got back to it.
Jim.
This is when Microsoft introduced the Office Themes and changed all the Access classes.
I played around with it for a bit trying to port it, but I could not get it to work and and never got back to it.
Jim.
It is working. It has a few quirks such as when you close a form you wind up with a white box where the form used to be. That box then goes away when you drag another form. In fact, it seems like dragging forms is what makes the background refresh but occasionally you may see a little white next to a form in the direction it was dragged (perhaps it only refreshes at certain intervals). It may not be perfect, but certainly it is something we could live with, and so far it is our best option for moving forward.
I don't know if you can change backgrounds, I didn't use that part of the code with the button. I actually embedded the code into a different form that I load on startup and runs in the background.
The only serious issue I had was when I went to edit that form as it was already open when I went to design view. Upon saving the changes I closed it in design view, then I reopened it again which appeared to send it into an infinite loop that was so bad I couldn't even get ctrl-alt-delete to work! I wound up having to do a hard reset of the computer.
I don't know if you can change backgrounds, I didn't use that part of the code with the button. I actually embedded the code into a different form that I load on startup and runs in the background.
The only serious issue I had was when I went to edit that form as it was already open when I went to design view. Upon saving the changes I closed it in design view, then I reopened it again which appeared to send it into an infinite loop that was so bad I couldn't even get ctrl-alt-delete to work! I wound up having to do a hard reset of the computer.
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.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
Or switch to the tabbed form view in general.
/gustav