Reports: Access97 - Microsoft Access / VBA

Lumpierbritches

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", however, when I attempt to size
the report so that an individual record prints in each one, the sizing is all
off. Is there a secret for dividing up the report page with .50 footer and .50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated for
spacing also? If that's the case, you loose 3" in an 11" form????

Michael

Nov 13 '05 #1

Subscribe Reply

1400

Wayne Gillespie

On 04 Dec 2004 16:52:35 GMT, lu************* @aol.com (Lumpierbritche s)
wrote:

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", however, when I attempt to size
the report so that an individual record prints in each one, the sizing is all
off. Is there a secret for dividing up the report page with .50 footer and .50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated for
spacing also? If that's the case, you loose 3" in an 11" form????

Michael

Open the report in design view,. From the file menu select Page Setup
and then click on the Columns tab. Here you will be able to set the
margins etc for multi column reports.
Wayne Gillespie
Gosford NSW Australia

Nov 13 '05 #2

Lumpierbritches

Thank you for your reply. I have tried with the column setup and still no
success. Any assistance with this matter will be greatly appreciated.

I have a form with three up on a page preprinted and Iwant to fill in this form
with my data. The records are NOT lining up. I have measure with a ruler and
can manually make a report that will fill in all the fields on the form, with
ONE record. I wish to fill in the form with different records.

The sizing for some reason makes the first record fit, but subsequent records
are off by nearly an inch or more. This is my dilema.

CC: Newgroup

Michael

Nov 13 '05 #3

Wayne Gillespie

On 05 Dec 2004 01:31:43 GMT, lu************* @aol.com (Lumpierbritche s)
wrote:

Thank you for your reply. I have tried with the column setup and still no
success. Any assistance with this matter will be greatly appreciated.

I have a form with three up on a page preprinted and Iwant to fill in this form
with my data. The records are NOT lining up. I have measure with a ruler and
can manually make a report that will fill in all the fields on the form, with
ONE record. I wish to fill in the form with different records.

The sizing for some reason makes the first record fit, but subsequent records
are off by nearly an inch or more. This is my dilema.

CC: Newgroup

Michael

If you need to print 3 records per page on a pre-printed form, then
columns are not the answer.
Printing to a pre-printed form is usually a royal PITA.

You need to set the height of the detail section of the report to the
exact height of a SINGLE record on the pre-printed form. If your form
has 3 records per page (assuming A4), the detail section will be
around 3 - 3.5 inches in height.
Turn off headers and footers so that the detail section is the only
section in the report. Set your controls within the detail section to
match a single record on the pre-printed form.

When you preview the report 3 records should be printed per page with
each record immediately following the next. You then need to adjust
your top and bottom margins to line up with the pre-printed form.

HTH

Wayne Gillespie
Gosford NSW Australia

Nov 13 '05 #4

Similar topics

5728

AccessXP Reports Open Fit to Page

by: Steve | last post by:

Recently due to viruses I had to wipe my harddrive and reload everything. Now, in AccessXP(2000 and XP mode) all new reports and all reports in existing databases open in Fit to Page rather than 100% like they use to. I also have Access97 and 2000 installed and all reports in both of these open at 100%. In fact, any report that I open in Access2000 will open at 100% but when I open the same reports in AccessXP 2000 mode, they open Fit to...

Microsoft Access / VBA

1353

Seasoned Reports suddenly quit working

by: GSpiggle | last post by:

I have an Access97 database that is used solely for a series of monthend reports. It is quite old, probably dates back to 1999 and has worked flawlessly through last month and has not been touched since then. The database resides on a network drive and has for a year or so. Today I executed the macro that runs the reports and the first report cannot be found. A report by that name is under the reports tab, but when I try to open it...

Microsoft Access / VBA

1470

Payroll Hx Table and Reports

by: zexx | last post by:

Need some advise.... Payroll program Access97. Payroll is printed then posted to a hx table thro' a query with the payroll calculations that freeze that payroll's numbers for that period. The weekly payroll period reports are produced from the Payroll table by queries that are linked to the Employee details table...salary, base rate, lead rate, wh allowances, status etc...so this is real time data with the current information in the...

Microsoft Access / VBA

294

Forms and Reports

by: DCD | last post by:

I was wondering if anyone knew how to create a report from information that you select on a form. I have a few of the fields on the form linked to a table, however some of the other ones are not linked, and are totally separate. Thanks. DC

Microsoft Access / VBA

10782

Importing excel into Access: Reports primary key violation when there is not!

by: Bonnie R | last post by:

Hello! I am writing VBA code in Access 97 to import an Excel 2000 Spreadsheet. I had hoped to do this using ODBC, but that was not to be, for who knows what reason. The problem is that I import the excel file into a table in Access that I name X. Then I run an append query to import the data into another table. I get an error message that says it "can't append all the records" due

Microsoft Access / VBA

1160

Integrating Crystal Reports into Access97 form

by: cdownload | last post by:

I have some Crystal Reports I would like to have viewed and emailed by pressing a button in an Access97 form. I can open the report with the crystal report viewer, just need to know how to put in form with the active x control. Also, I would like to use the timer event to email this report every morning. Any suggestions?

Microsoft Access / VBA

2530

Can Crystal Reports be integrated in an Access97 runtime environment?

by: Tony Ciconte | last post by:

We are evaluating the prospect of integrating and/or using Crystal Reports with some of our current products. Some of these are still in Access 97 and are running well. Since we cannot include the report wizard in a runtime environment, we are looking at ad hoc report writers like Crystal. Can we include Crystal with our runtimes and/or is there another report writer that we should be looking at? Any and all help is greatly appreciated.

Microsoft Access / VBA

1548

Embbed pictures in Access reports

by: telim.albert | last post by:

I have a form and a database that display the pictures of personnel but it is not binding to the reports

Microsoft Access / VBA

1893

How to add pictures to reports ?

by: JDW | last post by:

Now I have a picture in a Form and each record has a different picture. How can I add this pictures in a Report ? JDW Belgium

Microsoft Access / VBA

2972

Task Manager 2007 crashes Word/Excel 2003 reports

by: Inbox.Mirror.Orbisoft | last post by:

In the last 1-3 weeks, we have had numerous users of Task Manager 2007 (www.orbisoft.com) complain that they can no longer export certain reports (Task Manager 2007 uses a Sagekey.com Access 97 runtime) to Excel 2003 or Word 2003 format. They say they get an error message then both Task Manager 2007 and Office 2003 shut down. Any ideas why this is happening?

Microsoft Access / VBA

9643

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10315

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

10147

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10085

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

9947

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

8968

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

5379

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

5511

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

3645

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