ms access courses - Reports in access

The UK's most regular instructor-led training courses.
Training information: ms access courses · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Reports in access

Mandy has attended:
Access Intermediate course
Access Advanced course

by - delegate Mandy [3 posts] (2007 Mar 7 Wed, 09:38) Reply

How can I set the size of a report and its position on my users screen in access?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Reports in access

by - trainer Richard platinum contributer [818 posts] (2007 Mar 12 Mon, 16:35) Reply

Mandy,

You can do this my using the MOVESIZE function in a macro to open the report.
Normally you would need to run this macro from a switchboard button for it to be effective.

For full details on the MOVESIZE function, refer to the help menu (F1)

· Three Myths About Microsoft Access
· Take an Access Course to Learn About Relational Databases
· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· MS Access: Access your Personal Information with Ease

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips