473,243 Members | 1,578 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,243 software developers and data experts.

Homescreen form design

Just wanting some input on the best way to go about designing my homescreen form.

This database is mainly for case management. Right now I have it so that all my navigation buttons are on the left with multiple list boxes in the body of the form. Each list box represents different deadlines for when certain paperwork needs to be sent out/follow up on specific things/hearing dates.

I like that I can set the listboxes up to doubleclick on a specific record and go to their corresponding form and how clean they look, but I also want to be able to have specific things be highlighted to bring more attention to them. For instance, if we have a hearing coming up, I want that to be highlighed in RED. I would also like more control over the highlight color in general.

Any thoughts? Is there a way I can have all the things or will I have to pick and choose? I've also made up the same form, but with datasheet subforms just to get a sense for how they looked, but they're more bulky than the list boxes. If there are other options, I'm open to trying to them out as well.
Mar 20 '17 #1

✓ answered by jforbes

You might want to check out this Question: Set Colour for Current Record

ListBoxes are very clean, but the ListBox that ships with Access doesn't support what your are after. You could attempt to get a third part control that might do what your after, but that is a pretty huge undertaking and there is a cost associated with purchasing the control.

What I would recommend is checking out the link, it shows how colors of the background can be changed per record.

This is an example of how I use that technique:


2 854
jforbes
1,107 Expert 1GB
You might want to check out this Question: Set Colour for Current Record

ListBoxes are very clean, but the ListBox that ships with Access doesn't support what your are after. You could attempt to get a third part control that might do what your after, but that is a pretty huge undertaking and there is a cost associated with purchasing the control.

What I would recommend is checking out the link, it shows how colors of the background can be changed per record.

This is an example of how I use that technique:

Attached Images
File Type: jpg DashboardScreenshot.jpg (78.6 KB, 136 views)
Mar 21 '17 #2
Ah. Cool. I'll look into that.
Mar 21 '17 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Imran | last post by:
I m getting this error when i open asp.net Form Design View. "The file failed to load in the Web Form Designer. PLease Correct the following error, then load it again. The designer could not be...
2
by: Pete | last post by:
Before I get started with the question, does anyone have a (single) good book recommendation for database design? Not an Access-specific book, but something geared toward helping me figure out...
1
by: Bob Darlington | last post by:
Is there any shortcut key combination to switch focus between the property sheet and form design without using the mouse. -- Bob Darlington Brisbane
0
by: misscrf | last post by:
I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I workd for. My issue is with good form design. I have a main...
1
by: WJ | last post by:
I have a need to hire Web Designers who do nothing but design plain web forms in ASP.NET format. Unfortunately, most of these folks do not know how to use VS.Net 2003 to design Asp.Net forms....
4
by: yanjie.ma | last post by:
Hi, I've got a two part question on table and form design (sorry for the length but it takes a bit to explain). Our sales department uses a look-up table to help the them select the best...
18
by: Diogenes | last post by:
Hi All; I, like others, have been frustrated with designing forms that look and flow the same in both IE and Firefox. They simply did not scale the same. I have discovered, to my chagrin,...
2
by: Karl | last post by:
Using A2000 When I click the save icon in form design, Access closes immediately. No warning messges, nothing. This happens on only one form. I deleted the form and recreated it. I could save...
10
Jerry Maiapu
by: Jerry Maiapu | last post by:
Dear all, I have a simple but very important database fundamental question on table relations with fixed values and its form design problem I am facing for easy data entry. I have about 3 tables...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.