Hi,
I am very much a beginner to Access, but learn software very quickly. I made a simple project with a table, a form to enter the data and a report to view/print the data. I added all the data in manually on the table and in my form. When I go to the report print view, some of the textfields have the values in them like in the table, but others are missing the value. I don't see how this is possible seeing as some values are there and others are missing. I am using Access 2007 with Windows Vista. Can someone explain this to me?
thank you.
-Chris
5 4152 nico5038 3,080
Recognized Expert Specialist
Hard to diagnose from a distance, but first verify that the fields missing are "bound" to the tablefields. In the textbox of a bound field you'll see the name of the field as defined in the table.
Another option could be that the forecolor property of the reportfield is set to white.
Nic;o)
NeoPa 32,557
Recognized Expert Moderator MVP
As Nico says, without any information related to what's missing we are working in the dark somewhat. I suggest you take the following steps and, if they don't enable you to see the problem for yourself, describe the results in here and we'll see where we can get to. - Open the underlying table and check that the data entered is indeed stored in your table.
- Open your report and note which fields are missing and which are displayed.
- Find one of the controls in your report which is NOT displayed and examine the Control Source property.
Also helpful, should you need further help, would be the definition of the fields in the table (known as Table Meta-data). Here is an example of how to post table MetaData : Table Name=tblStudent - Field; Type; IndexInfo
-
StudentID; AutoNumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time
I understand it is probably hard to see what i'm asking so let me see if I can clarify. I have a table of data such as names numbers and addresses. In my report I have three textfields: 1. Name 2. Number 3. Address. These textfields shoot out all the details of the entries I have so say I have 5 entries in my table. For some reason the report will only show about 2 out of the 5 numbers in the Number category. I checked the control source for the textfield that shoots out the numbers detail and it is referred correctly like i thought. If it displays 3, it should display the other 2. I hope this gives everyone a better idea of my problem. thank you.
NeoPa 32,557
Recognized Expert Moderator MVP
Soccery, please read my post again carefully. There are instructions in there of both what you should check and, if that fails to help, what you need to provide in the way of information for us to be able to help you. We may be able to make some further progress if you don't provide this information, but if you were helping someone else and they failed to provide the information requested - would you go the difficult route to try to help them?
Please A - Let us know you're still stuck, confirming that you've followed the suggestions provided already.
And B - Provide all the information requested.
nico5038 3,080
Recognized Expert Specialist
Please open the table and copy/paste the five rows here.
Open the report's properties and goto the Controlsource (First entry under Data tab).
Open the controlsource query and switch to the SQL mode to copy/paste the SQLtext and finally switch to the view mode to see the rows and copy/paste those too.
Nic;o)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Rob Freundlich |
last post by:
I have some servlet-generated tabular data that I need to present, so I'm
using an HTML Table. In some cases, it can be quite large. I'm flushing
the servlet output every N lines to push the data...
|
by: mark |
last post by:
How do I get all fields on one page of a report?
I have a report that has a column for each day of the week and 6 records for
each day. I need each weekday's records returned on only one detail...
|
by: Glenn P. |
last post by:
Sorry, CDMA, I searched this NG on several combinations of words, but
I didn't find a relevant hit, so here's my newbie question:
I have an Access 2002 table which contains data extracted from...
|
by: Chris |
last post by:
I finally got my report to be recongized, that login issue is terrible. Using
VS.NET 2003, created report inside of it. Now when I attempt to display the
report is blank (missing data, though I can...
|
by: www.ttdown.com |
last post by:
Each day a user is supposed to import a list of information into a
database table. The user only has 30 days to import this information.
After 30 days the information is lost. I need to be able...
| |
by: Beowulf |
last post by:
I have a report laid out in Design View as shown at the end of this message.
I have code that performs the following steps:
1. In main report's Report_Open(), DELETE any old rows in tblTOC for...
|
by: slitvinov |
last post by:
I am learning Relax NG. The problem is that I cannot figure
out how to make a schema for a table.
In my case I would like to make a table with any name of child
elements (columns) but columns...
|
by: anubis2k7 |
last post by:
Hi,
I am having a problem with dynamically sorting/grouping data in my report at runtime. My problem is that when the report is run using sorting/grouping I am missing data.
Specifically, my...
|
by: arpan209 |
last post by:
I am preparing a crystal report for library system...
two tables..
1)BookIssueDetail:
fields : grno ,bookno,issuedat
2)studentMaster
fileds: grno,stdename,(and lots more)..only these...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
| |
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,...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
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 ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |