Solved

MS Access 2013 Runtime not showing subform formatting

Posted on 2016-08-16
9
69 Views
Last Modified: 2016-08-30
Good morning,
I have a really strange problem that I just can't figure out.  I have a pretty large form that displays production data.  It runs as expected on my PC but when I run it on Access 2013 runtime all of the subform formatting disappears, as well as the dividing lines on the subforms and the alternate row color (5% darker)

I've disposed of all the conditional formatting and hardcoded the textbox background colors in the On Current events on each subform.  Even the font that I've permanently set to colors (Red, green, etc) appears as black.

So far I have:
Tried running the form as a popup and normally, no difference.
Resized the subforms and the controls
Repairing and then reinstalling the 2013 runtime
Running as .accdr, .accde, and .accdb
Rebuilding the subforms from scratch

There's more but I can't remember it all.

Can someone help me out with this?  I'm pretty certain it's eroding what little sanity I have left.

Thanks in advance for your help!
Jeff
0
Comment
Question by:jeff-h
9 Comments
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 125 total points
ID: 41757924
Usually when subforms disappear it is because there is no data to show and the allow additions property is set to No or the query is not updateable.
0
 

Author Comment

by:jeff-h
ID: 41757949
Thanks for the response Pat.  The subforms do show the data but none of the formatting.  Allow Additions is set to yes, and the querys do run as they should and update the data.  I just installed the 2016 runtime on the machine and am still having the same problem.
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 125 total points
ID: 41758025
Have you tried opening the application on your computer in runtime mode, or is this just on other another computer(s)?

you can run it on your computer with the /runtime command line argument, or copy the file and give it a .accdr extension.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:jeff-h
ID: 41758064
Thanks Dale, I did try that too.  It runs great on my PC with the runtime.  The computer I'm having trouble with is a Lenovo Ideacentre stick running Windows 10.  I'm wondering if Access don't like the chipset?

I think I'm going to try to install the full version of access on the Lenovo and see if that works.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 41758094
Lenovo Ideacentre stick
Could be the video subsystem in that pocket-sized PC cannot properly render. Those have the bare minimum necessary to run a program like Office, so it's not surprising that it would not be able to handle something like that.

Do other subforms with similar formatting show the same?
0
 

Author Comment

by:jeff-h
ID: 41758138
Yes they do.  I'm headed out soon to pick up another stick with higher specs.  I'll post what happens here when I try it.  I'm really hoping that's the issue.

We really want to use the sticks for this project because they're convenient and cheap.  All we have to do is worry about the LCD display mounts and the stick can be zip tied anywhere.  We'll be deploying 30 or so in the near future.  Boss is getting anxious.

Thanks for your help so far everyone, I'll see how this goes.
0
 
LVL 84
ID: 41776803
jeff-h,

Did you pick up new sticks and try them out?
0
 

Author Comment

by:jeff-h
ID: 41776967
Sorry I didn't get back sooner.  I tried an Intel Compute Stick which had the same problem.  Now here's the kicker:  I tried another IDENTICAL Lenovo stick running the same OS Windows 10 pro and same Access 2013 runtime.  It worked as it should except for one textbox in one subform wouldn't show the background color orange.  I double checked the code for the color and it was correct and also worked fine on my laptop.

I wish I had a definitive answer or workaround as to what's going on but I think I persuaded the boss man to spend a few more bucks per station and use a more powerful mini pc.  I have a AOPEN 3250 with about twice the specs on order I'm going to try out.

The sticks are cool but not quite suited for this application.  Thanks for your help guys.
0
 

Author Closing Comment

by:jeff-h
ID: 41776979
I appreciate all your help.  I'm leaning towards the graphics chip being a bit weak so I gave Scott the best solution points and assists Pat and Dale.  Have a good week!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Flowing down data to other tables 13 32
ERROR 3113 MODULEID NOT UPDATABLE 8 18
vba to flip column 14 17
vba copy paste previous line 3 13
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question