Solved

Links and conditional formatting quit working in Access

Posted on 2014-04-16
2
462 Views
Last Modified: 2014-05-01
We have been using an .accdb file with linked tables for some time. The file opens in a 'Split Form'. In the list view each record contains a link to open that record in the form view.  Each record also has a field(cell) which uses conditional formatting to color the background yellow if the field is empty.

Recently, if we open the file in  MS-Access 2010 the link text and background color are missing. If I open the file in MS-Access 2013 everything looks normal.

Anyone have an idea of what to check or why the link text and background color have stopped showing up in Access 2010?
0
Comment
Question by:garysamuels
2 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 40004660
In a split form, you don't need links per se.  Just selecting a row in the datasheet portion will make that record's data appear in the form portion.  Where is the link text and the control with the background color that is having the problem?  In the form portion?  Can you post the database, or at least a screen shot of the split form?
0
 

Author Comment

by:garysamuels
ID: 40034378
Sorry for the slow response. I had forgotten the rule, ...reboot. After letting the SQL and Terminal Servers update I did a reboot and now everything is working normally.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now