Microsoft Access

We have a databaes with several reports, all ending with a Chart object in
the Report Footer (last object). Back in December when we printed all of the
reports, if the Report Footer items would spread over the "next" page,
specifically the graph, it would print the entire graph on the next page.

Now when printing, a portion of the chart/graph appears on the first page at
the bottom, spreading over the margin, and then also appears in its entirety
on the second page (correctly). A page break is not an option because there
are cases where the report is small enough to fit the data tables and the
chart on one page--don't want another page where not needed. Also, there are
other data items in the Report Footer that need to stay on the first page, so
I cannot use Keep Together or Force New Page.

I have a sample database if that would help. Thanks!

jerry (jcrosby@wc.com)

PS: We have a mixture of Windows 7 and XP machines that were fine in
December, but now show the incorrect behavior. The only thing that might
have changed would be several Microsoft Office updates since December.

hi

Offers tips and applications for spreadsheets; learn how to use excel effectively to make your job easier.

Explore in Sites

Can some body help me with the procedure of calculating stock aging in access

i have a table with 10 user names & want to create individual tables in the name of each user using vb codes. pls help

Have any gone through the Northwind Sample database the qtrly report is not showng the 3rd qtr report it is showing 0 values, can any 1 help me with this, if possible pls mail the solution for the same at bijuplavila@gmail.com, will be thankful for the solution.

I am interested in creating a form in Microsoft Access 2000 that allows the user to select an employee name from a combo box which in turn populates all the employee's projects into the form for editing/data update. Is this possible?

A more detailed offshoot of Accessory, this is a whole site devoted to Access. Tips, techniques and tools, all free and open source.

Explore in Sites

Is screen resolution involved in picture viewing problem? problem viewing pictures in bound control at actual size. Pictures are jpeg, 300 ppi. different sizes (from 3/4 - 1 1/2 inches). Picture Size set to Clip. In form and report views the images are much larger than actual size, some clipped by control which is 2 inches square. BUT in Report Print Preview and when actually printed the images are the correct sizes. But on screen viewing is not, very annoying. New Think Pad viewing on 23 inch Viewsonic with secreen resolution 1920 x 1080.
Also, any way to get dynamic resizing (can grow can shrink) for bound control with picture attachment?

Business Office Explorer is a Knowledge Management, Navigation and Collaboration system build with MS Access. Create a model of your business, project or process and share access to information from databases, files, directories, Outlook, Share Point and internet web sites with your entire team within a single dynamic modeling and navigation structure.

Explore in Sites

Free utilities, tutorials and tips for Microsoft Access database developers. Tutorials and tips written by expert Microsoft Access MVP's. Custom Microsoft Access database development for your database projects. Experienced in Oracle and SQL Server, too.

Explore in Sites

Supporting tools and libraries for the MsAccess or iFix developer, all aimed to create and support professional applications. They contain effective utilities, including a VBA Code Wizard, Picture Clipboard w Editor & Library Manager, Full Search & Replace, etc. And support easy development by keen functions for error/form/report/record handling and much more. All publish

Explore in Sites

N-Sight Consulting, located in Atlanta, Georgia, is a developer of Microsoft Access solutions that have been implemented in a wide variety of industries and organizations.

Explore in Sites

Access 2010 will crash when copying an entire record. It doesn't matter if the database is on the network or on my desktop. I have turned of our LANDesk security. I am running Win XP - any suggestions?

MS Access
how to remove unwanted data elements?
how does it retrieve specific data records for printing or display an screen?
how does it manage data correction s or supplementary?