Solved

MS Access 2013 Runtime not showing subform formatting

Posted on 2016-08-16
9
103 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 37

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 48

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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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 85

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 85
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

690 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