473,326 Members | 2,128 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,326 software developers and data experts.

Hiding a textbox that is "NULL"

I am extremely new to Access overall and am using Access 2010 to build queries and forms, so the easier explained the better. I do not have a clue on writing code and am trying to learn as I go.
What I have is several tables that each contain specific data that will be tied to one form in the end. The problem with this is there are 83 columns titled "References", each respectively named correctly (Reference 1, Reference 2, Reference 3, etc...). These are to be tied to a another table through a common title. The problem is many of these "References" are empty (NULL). I may have one "Common Title" that has no "References" what so ever and another that may have up to 83 "References".
I would like to be able to build the forms to show each "Common Title" individually with its respective "References". I have looked at several ideas and ways of doing this with no answer as of yet.
If there is any help it would be greatly appreciated.

Attached Images
File Type: jpg 12-30-2013 2-55-51 PM.jpg (59.0 KB, 278 views)
Dec 30 '13 #1
2 970
Rabbit
12,516 Expert Mod 8TB
Your tables are designed incorrectly, in that they are not normalized, please read this article on normalization: http://bytes.com/topic/access/insigh...ble-structures.

That way, you can begin with correctly designed tables and you won't have this null issue in the first place.
Dec 30 '13 #2
NeoPa
32,556 Expert Mod 16PB
Rabbit is quite right when he explains that the difficulty stems directly from a poor understanding of how such a structure can best be handled within a database.

If you consider that you can have separate tables such that one handles the core concept (The title you referred to) while another handles any references that may be required to that core concept. That way, you can list through a query of each of the references tied to the core concept with a join that allows the concept records to be included even when there are no matching references, and have a resulting record for each reference found. These, and only these, are included in your report. There need be no requirement to exclude any that don't exist as they are never included in the first place.

For a fuller understanding of this and many of the concepts that underpin this way of approaching database structure please check out the link provided in post #2.
Dec 30 '13 #3

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

Similar topics

1
by: wk6pack | last post by:
Hi, I would like to know if this is possible. I'm using ASP with JSCRIPT. I have a dropdown box that when the use selects a particular value, I would like the textbox to become visible....
0
by: Paul | last post by:
Hi I have a hidden Panel (DIV, style.visibility='hidden') control containing a hidden TextBox. If I make the Panel visible, then make the TextBox visible and then re-hide the Panel the...
3
by: MDB | last post by:
This may sound like a naive question, but that's only because I'm naive about most things ASP.NET, as my background is primarily Lotus Notes Development, and before that, DOS-based FoxPro. Is...
1
by: Wanda | last post by:
I would like to get a lostfocus even in aspnet, I know I can do something like that: txtBox.Attributes.Add("onblur", "javascript:RunMe()") But then the scirpt, RunMe has to be written in the...
7
by: Sandy | last post by:
Hello - I have a form that when submitted checks the database and if the username is already taken, a label shows indicating same. I need to make that label NOT visible after the user clicks...
2
by: darrel | last post by:
When showing/hiding items on the front end via codebehind, one normally just sets the object to runat='server' and then set's its visibility to false. This works fine. However, when I have a...
9
by: davidr | last post by:
Hi, I've researched this a lot and have a well understanding but still can't get the darn textbox in the javascript. I have a textbox that is set to runat="server" and I have a client...
1
by: Pieter | last post by:
Hi, Is there a way to link the Hidden-property of a Textbox on a Reporting Services Report to it's Value? When the Value is empty (""), then I want the TextBox be Hidden. In case you don't...
10
by: moondaddy | last post by:
I have a textbox on a webform and based on certain conditions I wanted to prevent a user from editing its text. I dont like the look of the texbox when its disabled and was wondering if there is a...
10
daoxx
by: daoxx | last post by:
Hello I've searched, posted and solved this (Thanks for helping!), but now it came back to bite me in the *ss. I have a Yes/No field that is represented by a check box in my form1. I want to...
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...
1
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.