Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Resolved · Low Priority · Version 2003
Kevin has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
When using an Access Form I select a value (in this case a University) from a dropdown list. This produces a Report of information about that University. I would like that report to be created into an Excel file and be saved as the name of the University.
Hi Kevin, thanks for your query. The best way to achieve what you need is to attach a macro to the OnChange event of the dropdown list. This would take the University name, generate the report and automatically export it to a named Excel file. Currently, there is no built-in feature to do this automatically in Access.
Hope this helps,
Anthony
Mon 15 Jun 2009: Automatically marked as resolved.
|
|
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
TrustScore
4.8
/ 5
2236 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
