Autonumber rows in reports - Microsoft Access / VBA

Denbo

Does anyone know how I can print a report that autonumbers each row/record
it prints. Nothing complicated, just from 1 upwards.
TIA
Denis

Nov 12 '05 #1

Subscribe Reply

16327

Rick Brandt

"Denbo" <de*****@optush ome.com.au> wrote in message
news:3f******** *************** @news.optusnet. com.au...

Does anyone know how I can print a report that autonumbers each row/record
it prints. Nothing complicated, just from 1 upwards.

Put a control on the report with =1 as the ControlSource and then set the RunningSum
property to "Over All".

Nov 12 '05 #2

Denbo

Thank you.
"Rick Brandt" <RB*****@Hunter .Com> wrote in message
news:bk******** ****@ID-98015.news.uni-berlin.de...

"Denbo" <de*****@optush ome.com.au> wrote in message
news:3f******** *************** @news.optusnet. com.au...
Does anyone know how I can print a report that autonumbers each row/record it prints. Nothing complicated, just from 1 upwards.
Put a control on the report with =1 as the ControlSource and then set the

RunningSum property to "Over All".

Nov 12 '05 #3

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Use the running sum property of a TextBox. E.g.:

1. Set up a TextBox where you want the line (autonumbers) to appear
(usually in the Detail section).
2. Set the RunningSum property = OverAll
3. Set the ControlSource = "=1" without the quotes.

Each time the detail (or whatever section you selected) prints the
number will appear. The next line will increment the number by 1.

See the Access help topic on Running Sum.

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP2pciYechKq OuFEgEQIpBgCg2r lxfQe/gIkHqO9wuPRny6h oy2kAoI60
R/f+X6U0SaqASWxRs 1BiA20d
=qFR8
-----END PGP SIGNATURE-----
Denbo wrote:

Does anyone know how I can print a report that autonumbers each row/record
it prints. Nothing complicated, just from 1 upwards.

TIA

Denis

Nov 12 '05 #4

Similar topics

3067

AutoNumber vs. Key

by: Tom | last post by:

Hi, I am always confused about what to use as the key for a table. Let's say I have a company-employee table. ---* My co-worker likes to use an AutoNumber or Counter as the key for the table (and everything).

Microsoft SQL Server

1629

Dynamic reports PTII

by: SharkSYA | last post by:

After canvassing ideas it appears that the way I need to do it is not possible.There are 126 rooms, more to be added, and it needs to print a report or reports showing 76 days of bookings. There are two queries involved: Here's the code(Thanks Bob Q!) SELECT Calendar.Date, Bookings.room FROM Calendar, Bookings

Microsoft Access / VBA

4760

Autonumber foreign keys and subforms

by: Ed Havelaar | last post by:

Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. Subtab has this id column as a foreign key. There is a one-to-many relationship defined on MainTab and Subtab using the id column. The join type is include all from MainTab and only rows with matching value from SubTab. Referential integrity enforced; cascading

Microsoft Access / VBA

6229

add a record for access with an AutoNumber field

by: HS1 | last post by:

Hello I have a table in Access Database. This table has a AutoNumber field. I use a DataGrid to show that table When I insert a new record in for this table using a DataGrid, there is a message that asks me to enter the value for this AutoNumber field. Why I have to do that? Could you please help

Visual Basic .NET

2521

Printing reports - w/ one button - multiple copies

by: bmdavis | last post by:

Hello, Currently I have a form that I want to print, 5 times for each AUTONUMBER I specify (i.e. print #654 5 times). I have created 5 reports, each with a different header/footer according to my needs. How do I create a button/macro/command to print ALL 5 according to the Autonumber I select? In other words, for each record I want to print 5 reports, the same basic data but different headers/footers. Thanks!!

Microsoft Access / VBA

1415

Make query2 contain same rows as query1?

by: Andy | last post by:

Hi, I've been using this newsgroup heaps recently but after vigorous searching I can't find quite what I'm looking for: I have a DB where there are employees who have their skills reviewed. ie. Employee 1 Review 1: Skill1=2

Microsoft Access / VBA

1468

Serial number instead of Autonumber

by: sidheeq | last post by:

Dears I want to creat a table with starting serial number from 1000 pls help me

Microsoft Access / VBA

2026

Create a Sequencing PK without using AutoNumber field

by: rdemyan | last post by:

I have a table that is imported from another system. I have no choice but to use the data as is; they will not change it. The records are not unique. For reasons I don't want to get into, I can't use an AutoNumber field. Also, there is no combination of fields that will provide a unique key. So, I could assign a number in my import code. My thought would be to just select the highest number currently existing in the table and...

Microsoft Access / VBA

1245

Autonumber SQL database null problems

by: SenileOwl | last post by:

I'm working in VB.net 2005. I am trying to write some rows from one table onto a second table. The ID field in the original table is an autonumber, the field in the second table is just a regular integer. The code I've written copies all of the information over including the value of the ID field. When I display the new table in datagridview, I can see that for all nine rows of the new field there is a value in the ID field. ...

.NET Framework

8310

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8826

Problem With Comparison Operator <=> in G++

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...

C / C++

8503

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7330

AI Job Threat for Devs

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...

Career Advice

4155

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4306

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1955

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General