Numbering Entries in a Report or Form
Thank you for taking the time to report an issue.
What's wrong... Please write below.
report has number 1- x
however I want to add a sub report that does not form part of the numbering (I will add manual numbering for this sub report)
how do I turn it off
Since the data aren't lost, I decided to make a new file, copying the entries. This worked well apart from following:
In the original database all entries in the tables were auto-numbered (= primary key), and those numbers were used to refer to other entries in other tables.
Now, in the new database I could only retain either the original numbering (but not as auto-numbered), or automatically renumber all entries (with catastrophical consequences for my database relations).
Is there a way to continue working the new database with the original data nd to let the computer continue the number-giving?
I know how to use sections.
the main problem is restarting the page numbering on the page footer.
tried to put the page numbering on sub_reports but it seems the page footer is ignored when in sub_report
I have a table that allows for unlimited entries, but it needs to have at least 2 entries per Person (already connected relationally in a one-to-many). I need a calculated control for the form that can state how many more entries the Person needs by counting the number of entries that are already in the table.
For example, PersonA has 1 entry and the control would state that 1 more is needed. However, Person B has 3 entries and the control would simply be blank.
I plan to use the control in both a form and also a report.
This code works fine when used as an unbound field on a form, but I keep getting an #Error when displaying it on a Report. My intent is to have the historical entries display on a report as well.
The report source is a query, so it is only returning the last entry made. Is there a better way to save historical entries with a date/time stamp for a record?
Relationships: Shows the three tables and how they relate
Report Layout: Shows how I have done up the report in design layout
Report Results: Shows the extra values that I do not want. Ex. This is the report for NCR 19 but I am getting information for NCR 20 and 21 in the Problem Section and NCR Employee Section
Data Entry Form: Just shows the data entry for that feeds entries into all three tables.
Where the first part is the fixed code
Part II on today's date as the manual described
The third part is automatic numbering which was increasing with the addition of each new record
With a very pertinent observation
Is that because the numbering of the beginning of (1), the first of each calendar year
Enclose with an illustration of the solution
On the picture I've attached I have the top of the form in the header and the bottom of the form in the footer for the report. The middle, lines 1 through 19 are in the Detail. I'd like to fill from the top down. I know it's possible, but for the life of me I can't seem to think of how to do it. Writer's block