I am using a microsoft access 2002 (10.6771.6845) SP3 program and recently linked new table to one I have been using a long time, with a one (new table) to many (old table) relationship, which worked fine when I created 22 forms linked to the original table and form.
However, I wanted to have the pirmary key numbers posted in both tables at the same time. So, I opened the original table's query, linked the two tables in it, and dragged the new table's ID number into the query.
Because an ID is required, I went into the old table and changed the "not required" to "required."
When I re-opened the original form, instead of getting the 1500 records usually found, I got only 22, which corresponded to the number previously entered in the new table.
I deleted the "required" condition I had put into the original table's ID, I deleted the new table's ID from the original table's query, and I deleted the link I had created between the original and the new tables.
Problems:
Instead of getting the 1500-plus records I used to have, I now have over 34,000, basically 15 copies or so of each original form. When I filter to work with a form, it reduces to one form which accepts all data just fine. None of the other forms I have developed based on the same table show this duplication, and the underlying table has only the original data, so everything else except this one form is fine.
The other problem is that to print this form yields only the heading, not the detail.
I tried database compact and repair, with no results.
2 2456 ChipR 1,287
Recognized Expert Top Contributor
If you delete the link in the query, you create a default JOIN with a line for each record from one table paired with each record from the other table. If both your tables have the same structures, you can create a UNION of both tables, which is what you want.
As for the printing, check the properties of the detail section, and make sure Display When is set to Always?
Thanks for helping clear up the no-print problem, ChipR. As for the multiplicity of records, I'm going to try re-establish the link between the tables, and if that doesn't work, find out about doing a union.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: William Bradley |
last post by:
On the form which contains the record, I can print a single report from that
form. What I would like to do now is do the same thing but select the report
from any one of a dozen choices of report. This is due to the variables in
the manufacturing process that this database records.
When I print the single report, it is simply a bin label that goes with the
product.
The quality control section needs more detail and that is where the...
|
by: bruce |
last post by:
Hello,
I have a small form that pops up when a user moves off the current
record of a rather sizeable data entry form. The purpose of this form
is to list warnings about various fields on the entry form that may be
incomplete or inconsistent before the user exits the record. These
warnings take the form of items in a listbox. The underlying rowsource
of the listbox is a delimited string (value list). I would like to be
able to let...
|
by: Salad |
last post by:
Hi:
I have a Bill of Lading template from the printer that I saved as a BMP.
I created a new report and in the report's picture property told it
the BMP file name. It brought the image in just fine. I then placed
the fields in the report. Then I previewed the report. The picture
resized or something and all of my nice fields were no longer in the
same position. It didn't make any difference if I selected Crop, Zoom,
or...
|
by: Stephen Muecke |
last post by:
The startup form of my application is used to open other forms containing
detail information on projects, organisations, employees etc (similar to
Outlook)
Each detail form has a print method (creates a PrintDocument and prints the
object)
The data prints as intended, however, when printing is completed, the
startup form then receives focus (the form I printed from gets hidden behing
the startup form)
I have worked around this by adding...
|
by: Mal Reeve |
last post by:
Hello,
I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.
I am finding that on some occasions the report errors and generates hundreds
(perhaps even an infinite loop...I have to break the system to stop the
report generating) of pages.
While I'm not 100% I think this may have something to do with the detail
| |
by: fonzie |
last post by:
Is it possible to have a data entry form where the information is
stored in several different tables (5 or 6)? I have an inventory
database where Table1 stores all of the data common to all entries,
Table2 stores only the extra info relevant to items that are TYPEA,
Table3 stores only the extra info relevant to items that are TYPEB, and
so on. All relationships are setup (one-to-one) between the main table
(Table1) and all the other...
|
by: NeoPa |
last post by:
CHAPTER 1 - TABLE OF CONTENTS (Including attached database)
CHAPTER 2 - INTRODUCTION
CHAPTER 3 - TABLE LAYOUT
CHAPTER 4 - FORM LAYOUT
CHAPTER 5 - FORM MODULE
CHAPTER 6 - CODE DISCUSSION (FILTER CONTROLS)
CHAPTER 7 - CODE DISCUSSION (THE REST)
--------------------------------------------------------------------------------
|
by: Jerim79 |
last post by:
I need to create a form that takes a number that the user enters, and
duplicates a question the number of times the user entered. For
instance, if the customer enters 5 on the first page, when they press
next the form generates "How old are you?" 5 times on the page. The
customer will answer all 5 questions then press next. Finally, all the
local variables get dynamically created and written to a database.
I have already taken care of...
|
by: ccmanc68 |
last post by:
I'm needing to print reports by the record detail, Meaning if I had five records on the detail subform, I could click print and would get five reports with the same headers "Parent RecordID" but the first report would have the first record in the detail and the next report would print the second record in the detail and so on.
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |