hi,
i am a newbie in access and i created a database which is between client and job. the job fields consists of more than 100 fields. i could not split the fields as the relationship is 1-to1. between client and job, the relationship status is 1-to- many.
with large table created, i could enter values from Client form and Job form to the respective tables. so far, everything looks fine.
but when i attempt to create a report, i gotta message saying, "report could not be created because of too many fields"
i've read about normalization but i could not split the table further as the relationship is bit straight forward. my question is,
1. how can i create a report with too many fields?
2. can i create a report from a query? is it possible?...because i need to generate a print out based on my query results...
i would appreciate your help in this case.
thanks.
Kathy
6 2618
Hi Kathy
You can create multiple tables with one to one relationships. Just change the indexed property of the foreign key field to Yes (No Duplicates). Access really doesn't like tables this big.
Mary
thanks for the reply... i could create the 1-1 relationship between client , address and contact as u said.
but i wanted to create a form using fields from Client table, Address table and Contact Table. Using wizard, i tried to create a form using these 3 tables.
but what i get is an empty form and i could view the fields only in form design view.
Could you please tell me why the fields did not appear in a form view?
thanks,
Kathy
thanks for the reply... i could create the 1-1 relationship between client , address and contact as u said.
but i wanted to create a form using fields from Client table, Address table and Contact Table. Using wizard, i tried to create a form using these 3 tables.
but what i get is an empty form and i could view the fields only in form design view.
Could you please tell me why the fields did not appear in a form view?
thanks,
Kathy
there is no records being returned by the query and the query is not updateable.
Can you post the SQL of the query you are using.
thanks foru your reply..
PARAMETERS eJob Short;
SELECT *
FROM Job, client
WHERE Job.Job_No=eJob And Job.Cli_ABN=client.Cli_ABN;
i am using this query to display the result in the report.
the main problem i hav is, when i combine fields from Client table (foreign key Address_ID, Contact_ID), Address Table (foreign key Cli_ABN), Contact Table (foreign key Cli_ABN)..... to create a form, i get a blank form and i could only see all selected fields only in design view. why is this happening?
thanks in advance.
Kathy
Also, am trying to add records for the client table using Client form.
when i frrst open the form, i can enter , say for example, 3 records into the table.
but when i open the form again to enter the 4th record, the 1st record is getting deleted from the table and i could see only records 2nd, 3rd and 4th.
need your help.
thanks,
Kathy
HI,
i have done a silly mistake and now it is working perfectly..
thanks for ur help. i really appreciate your effort.
thanks a lot
Kathy
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Cady Steldyn |
last post by:
I need to run a data report that will query an Access_Table that has the
following Project info:
My Form has a command_button with the following code:
Private Sub Command1_Click()
Set db =...
|
by: PeterW |
last post by:
I have an xml file from which I want to generate an xsd schema and at a later
stage a cs class.
The xml file has a mix of defined namespaces and also an empty namespace.
These are defined as...
|
by: Robert Davis |
last post by:
I would like to be able to create a recordset in MS Access 2000 that
allows a macro to run and create a report for each ID that appears in the recordset. So I thought that I would use a
scheduling...
|
by: ward |
last post by:
Greetings.
Ok, I admit it, I bit off a bit more than I can chew.
I need to complete this "Generate Report" page for my employer and I'm
a little over my head. I could use some additional...
|
by: davidbennett |
last post by:
Hello,
I am new to MS Access. I have created a series of forms that users
access to perform data entry. I now need to build in reporting
functionality. I would like to create a form that has a...
|
by: ineedahelp |
last post by:
I have included a snip of my code. I am trying to output my results to a report or a query. Right now I can see my results in the immediate window due to my DEBUG command. how can I take these...
|
by: Coldfire |
last post by:
Problem background:
I am developing a windows application (in VisualStudio.Net 2005) that inserts an Institute Info and based on the query I need to generate a report featuring the Detailed...
|
by: Tarena |
last post by:
I have a report that is generated by a query. I have a form with a calendar control. I would like to use the form to force my date range to generate my report. Any suggestions? Do I need to give...
|
by: ammoos |
last post by:
Friends ..
I want to generate a report in the ASP.NET using C#. from Sybase database. There are two option to generate the report
1) Generate the Report on the Screen itself by using the...
|
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...
|
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"....
|
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...
|
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...
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
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...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
| |