report backend database
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Report from backend database

Report from backend database

· Medium Priority · Version 2007

replyReply Tue 6 Dec 2011, 09:34Delegate Nathaniel said...

Nathaniel has attended:
Access VBA course

Report from backend database

Hi,

I have a backend database with tables, queries and reports in it and a frontend databse with the forms and modules in it for updating the database etc. via recordsets and accessing the stored queries in the backend database.

The issue I have is trying to run a report that is stored in the backend database, is this possible?

I have no linked tables on the frontend so I cannot create the report this way.

Many Thanks,
Nathaniel

For upcoming training course dates see: Pricing & availability

replyReply Fri 9 Dec 2011, 15:31Trainer Simon said...

RE: Report from backend database

Hi Nathaniel,

Thank you for your question and welcome to the forum.

If your back-end database contains all the tables and queries, then creating reports from within there shouldn't be a problem.

Are you encountering a specific problem when you try and do this?

Regards

Simon

 

Please browse our web site to find out more about
advanced access training and other Microsoft training courses.

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard