98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007
Access 2007
Resolved · Medium Priority · Version 2007
Wed 29 Sep 2010, 16:38Delegate Salima said...
Salima has attended:
Access Intermediate course
Excel VBA Intro Intermediate course
Access 2007
Is there a way to get the forms and reports to be dynamic? I use a database which refreshes daily...
Thu 30 Sep 2010, 11:41Trainer Newson said...
RE: Access 2007
Hi Salima
My first question is how does the database update itself dynamically?
What I would do in your situation is create a query which basically gets the information from the associated tables and use the query as the basis for your report and your form.
Please do not hesitate to reply to me if the above does not make sense
Thanks
Newson
Thu 30 Sep 2010, 11:41Trainer Newson said...
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.
Thu 30 Sep 2010, 11:50Delegate Salima said...
RE: Access 2007
Sorry, I should have been more clear..yes the information will come from a query which is updated daily, however when I refresh the query any forms/reports associated with the query do not seem to update.
Thu 30 Sep 2010, 14:55Trainer Newson said...
RE: Access 2007
Hi Salima
Salima is the query updated or run daily and if the former how is the update.
Have you checked that the control source of the report/form is the query? In layout view of the report/form ensure the design tab is selected and click on the Property sheet button (its should be the last button in that ribbon).
With the property sheet displayed select Report/form. Then go to the data tab and see what the Record Source property is. It should be the query.
Please don't hesitate to reply if that doesn't help
Thanks
Newson
Thu 30 Sep 2010, 15:22Trainer Newson said...
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.
Thu 7 Oct 2010: Automatically marked as resolved.
Training information:
See also:
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Insert The Current DateTo insert the current date into a Table field or Form Text box use: |
