Topics Search

Numbering Entries in a Report or Form

Numbering Entries in a Report or Form
Views: 100
How to display a sequential numbering sequence on forms and reports in a Microsoft Access database.
Sponsored Links:

Similar posts...


page numbering (with a twist)

page numbering (with a twist) Icon
Page numbering
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

Trouble recovering database : Auto numbering

Trouble recovering database : Auto numbering Icon
After an unorthodox shut down of my computer (good old Windows error), I found out that my database file got damaged. Though I still have got access to the data, the file is useless. (The back-up was overwritten as well..)
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?

2 parts report

2 parts report Icon
I need a report that will be cut into 2 parts. it need to look like two different reports.
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

Calculating the missing number

Calculating the missing number Icon
I searched the archives and can't quite obtain the answer I am looking for.

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.

How to make Numbering in a Query

How to make Numbering in a Query Icon
How can I make a separate row were there will be numbering of each query result? I need it for my Report

How to customize the numbering in a query?

How to customize the numbering in a query? Icon
I want to customize the numbering in a query. In other word, I want to make customized numbering in a column in query but as formatted below: 001

ColumnHistory to display on report

ColumnHistory to display on report Icon
I am using this code to track and display historical entries entered into a "Comments" field everytime a user adds comments to a record. The field is a memo field with Append Only property set to Yes.

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?

Code used:

Report filling prebuilt paper form

Report filling prebuilt paper form Icon
I have a paper form I scanned into Access and created a report for. I'm looking to use Access to populate the fields on the form. The name, social, etc. are all easy enough to populate but I'm having trouble coming up with a way to populate the middle of the form. There's 19 lines I need to populate with 19 possible entries to be input. The issue is trying to condense all entries to the top of the form.

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

Reporting Issue: Combine query

Reporting Issue: Combine query Icon
I have a report that combines 3 queries based on three tables which have one primary key in common (NCR Num). The only issue is that when I combine them together and run the report, I am getting ALL the entries from the tables, instead of just the entries that are associated with that one common primarykey value (NCR Num).

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.

Subfrom without records prevents Main From record results

Subfrom without records prevents Main From record results Icon
As you will see if the subform has no entry then the report will not display any results for that record.
I have a DB with a two subform form and entries are likely to be in one or the other but not both.
Unless there are entries in both nothing shows on the report