[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

MS Access 2013 Runtime not showing subform formatting

Posted on 2016-08-16
9
Medium Priority
?
128 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 39

Assisted Solution

by:PatHartman
PatHartman earned 500 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
Dale Fye earned 500 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
New style of hardware planning for Microsoft Exchange server.
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 …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

656 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