473,382 Members | 1,369 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,382 software developers and data experts.

Item not shown in form if related data not created

2
I have 2 tables, 1 table containing a list of items and a second with list of documents related to the items and the status of those documents. It is valid to have no documents related to a particular item so there may be no record created in the documents table that relates to that item.

I also have a form that display the item and the status of some of the related documents, the trouble is if there are no related documents and hence no related record in the documents table the item is not displayed in the form either.

How can I make the form show the item even when there are no documents?
Nov 17 '06 #1
3 1303
NeoPa
32,556 Expert Mod 16PB
Somewhere you have a record source associated with the form.
If it is a QueryDef (named query) then edit this query and change the link between the tables to a type 2 (LEFT JOIN).
If it is SQL code then change the part of it that says 'INNER JOIN' to say 'LEFT JOIN' instead.
If you still have problems after that, explain them here and we'll help if we can.
Nov 17 '06 #2
stair
2
Somewhere you have a record source associated with the form.
If it is a QueryDef (named query) then edit this query and change the link between the tables to a type 2 (LEFT JOIN).
If it is SQL code then change the part of it that says 'INNER JOIN' to say 'LEFT JOIN' instead.
If you still have problems after that, explain them here and we'll help if we can.

Sorted, Thanks
Nov 17 '06 #3
NeoPa
32,556 Expert Mod 16PB
No problem.
Pleased to be able to help.
Nov 17 '06 #4

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

Similar topics

9
by: Frances | last post by:
Hi All, * PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
6
by: skgolden | last post by:
My husband and I own a small temporary labor company and deal with 4 major clients (A,B,C & D), each of which has about 2 dozen units in our tristate area that we deal with (ie, Company A, units...
7
by: Grant Schenck | last post by:
Hello, I have a ListBox control on a form. I add members of a class to the Items collection. They show up and I can select them. The text shown is from my classes ToString override. Now,...
7
by: localhost | last post by:
A DataGrid with shows a label in one of the columns when in view mode. When in edit mode, I want to show a dropdown, and have the default selection set to what the textbox used to be. Right now...
8
by: BD | last post by:
Moving from MS Access to .Net using C# languag. Problem trying to duplicate form with structure as follows: 1. Main form 'Work Order' displayed as textboxes 2. subform 'Customers' textboxes...
2
by: moondaddy | last post by:
I had to repost this because I had to update and change my msdn alias. I will re-ask the question and clarify a few things that were not clear before. This code is all executed on my dev...
1
by: amitrai | last post by:
SUPPOSE THAT WE WANT TO PURCHASE A ITEM,(SPARE) ,THEN WE SHOULD FULLFILL ALL CRITRIEA OF THAT ITEM, FOR EXAMPLE, ITEM DESCRIPTION (FOR THAT WE HAV 30 FIELDS) UMC NO-(UNIQUE MACHINE CODE)...
5
by: Bart Steur | last post by:
Hi, What's the best way to programmaticly select (click) another listview Item after removing the selected/focused one. using VB2005 Express. Thanks Bart
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

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.