Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

report backend database

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

Report from backend database

ResolvedVersion 2007

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

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

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 23 Nov 2012: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub


3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.