access report

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Change Excel row height from Access

How can I change the row height of Excel rows from Access. I need to do this for an Excel sheet that I am using as a back drop for an Access report. Based on the text length in the Access report. There will be instances where the text box...

Tags: Microsoft Office, sxviswan@..., Microsoft Access, Microsoft Excel, Access Report, Excel Sheet

Discussion threads 2007-07-01

Saving an access report as a PDF file

How can I save a n Access Report to a PDF file?Bill Gates won't let you, but...you can download the following :www.primopdf.com/.pdf making machine and, problem solved!

Tags: Microsoft Office, vikiius@..., Access Report, Microsoft Access, Adobe PDF

Discussion threads 2007-05-30

printing issue when access report is sent to queue

the application we use is access03 using vba. in printing batches, we use a 3step process: first, we print an Access instructions & rater reports; second, we print an Access prescreening report; lastly, we print application forms in pdf format using active pdf. Whenever we print in batches (1-15),...

Tags: prescreening, jlugar@..., software, hardware, access report, printing

Discussion threads 2007-01-31

Getting a Total amount in access report

I 'm having trouble getting a total amount to appear in the footer of my Access report. I've been through the Access help documentation, I've written the formula in various ways, I've tried pulling the data from a table and a query, but I always a "#Error". I can drag...

Tags: Microsoft Access

Q&A 2006-03-16

Create controls that grow with an access report's data

Fairly obvious feature.The feature described I would guess is well known. How about something similar but more complex like outputting reports not just with text but also with graphics of varying sizes for each record, without zooming/clipping and without blank space where graphics are smaller.Obvious, but not easy..I have tried...

Tags: Phil@..., Microsoft Access

Discussion threads 2005-05-11

Reduce access report margins to keep dat

Save paperIn the ideal world, field name width should closely match the width of the data below it. Unfortunately, overly long field names cause a lot of white space and wasted space and often forces many unnecessary pages in Access reports and printed tables. In addition to reducing...

Tags: Access Report, brucelloyd@..., hardware, Microsoft Access, printing, Reduce Access, save paper

Discussion threads 2005-10-26

Add page numbers to an access report

Nice tipI don't do a lot of Excel reports, but this could come in handy.

Tags: Access Report, Add, DougOfCNET, Microsoft Access, windows

Discussion threads 2005-04-21

Additional Resources

view MS access report via webpage

Hi,Is there any way I can view a MS Access report via an ASP web page ??I have tried recreating the webpage to look like my report but can't get it to match the exact look and feel that I can create with the Access report.Cheers,BrianTechnical Q & Ais where...

Tags: asp, brian.krisanski@..., ice69@..., Microsoft Access, Microsoft Corp., ms access, reports, software, webpage

Discussion threads 2006-02-09

view MS access report via webpage

Hi,Is there any way I can view a MS Access report via an ASP web page ??I have tried recreating the webpage to look like my report but can't get it to match the exact look and feel that I can create with the Access report.Cheers,Brian

Tags: asp, brian.krisanski@..., ice69@..., Microsoft Access, Microsoft Corp., ms access, programming, reports, webpage

Discussion threads 2006-02-12

Snap Shot viewer takes two pages

I have a new user that creates an Access 2002 report with the viewer & it looks fine when you do either a print preview or print out the report, but when she emails the report as an snp attachment, the receiver gets the report split between two pages. (In...

Tags: access, e-mail, feedback, networking, rmeier@..., Snap, snap shot viewer, software, windows

Discussion threads 2007-01-04

Access 2000 Report Printing Problem

I have a report that contains a Report Header. When I print, I want the Report Header to show on every page. How do I change the Property setting to do this?Put the text you want to print on every page in the Page Header section of your...

Tags: dkalynuk@..., Microsoft Access, printing, Report Header, windows

Q&A 2005-05-05

Add page numbers to an access report

When you create a report from scratch in Microsoft Access, sometimes you don't get to utilize all of the handy benefits of the report wizard. For instance, learn how to manually add the page number control to an Access report. Help users increase productivity by automatically signing up for...

Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, Add Page, page number, Microsoft Office Suite Access Tips Newsletter, TechRepublic Inc., Report, Databases, Office Suites, Software, Enterprise Software, Data Management

Technical articles 2005-04-20

access report multi +column conundrum

I have a multi column report in Access 97 that I need to go down and across, but also needs to be able to grow and span multiple pages. I have this as a nested subreport (a report in subreport, and that report is a subreport in another report,...

Tags: Microsoft Office, Databases, ironfist03, subreport

Q&A 2005-05-06

Quick tips for resizing access report labels

Text running over in an Access report label? Don't resize the text—resize the label! This Access tip from Mary Ann Richardson offers quick solutions to resizing report labels for a clean look. The are a number of possible reasons why the text no longer fits within your Access...

Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, report label, Microsoft Office Suite Access Tips Newsletter, Databases, Office Suites, Software, Enterprise Software, Data Management

Technical articles 2006-06-06

Report Advantage (exe)

Report Advantage puts you in control of your Access Reports. Quickly customize any Access Report in seconds with just a few mouse clicks. You do not have to know computer code or make or change queries. Use more of your existing Reports without having to change them or make new...

Tags: Microsoft Access, Report Advantage, Databases, Storage, Productivity, Microsoft Office, Enterprise Software, Software, Data Management, Hardware, Office Suites

Software downloads 2008-02-11

converting Crystal Reports to Access 2003

we want to convert CR8.5 reports to Access 2003 but have no idea on how to do that. We are using Pervasive for CR 8.5 to pull information from . is there a way that we can do this and how would we do this?Eeeww! Why?Crystal's...

Tags: Access 2003, Crystal Reports, crystal reports., luv2bike2, Microsoft Access, programming, software

Discussion threads 2006-10-20

Access 2000 Sample: Report Topics (exe)

The Access 2000 Sample: Report Topics database contains sample reports that demonstrate how to perform a variety of reporting tasks. The Access 2000 Sample: Report Topics database contains sample reports that demonstrate how to perform a variety of reporting tasks, including: Creating a Top 10 report. Printing a constant number...

Tags: Microsoft Access, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management

Software downloads 2007-09-20

MS Access 2000 Reports

I have a problem in Ms Access 2000 Reports when i generate a report on any query or table i always set all margins the report looks ok but when we open the report its margins automatically changes to 100mm on all sides top,bottom,left,right and its layout changes to portrate...

Tags: hamna_1999@..., Microsoft Access, Microsoft Corp., MS Access 2000, MS Access 2000 Reports, programming

Q&A 2004-11-05

New government report on Access security vulnerability

A new government report is warning about a security vulnerability in MS Access. The report was posted December 10 and is just beginning to hit major blogs. I won't repeat the information here, since there's nothing you can really do to prevent it other than this -- do not...

Tags: Microsoft Access, Security Vulnerability, Government, Microsoft Office, Databases, Security, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins

Blog posts 2007-12-14

Building a report in Access

Is there a way to get my details to display in horizontal fashion rather than having all details in vertical. I have a very ornate report that i am building and the original document that i am emulating is a spreadsheet printout that is very highly sectioned. Can someone help...

Tags: jim@..., windows, access, design, reports, Microsoft Access

Discussion threads 2007-02-28