2000 access microsoft training - how do i live
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 Training and help » 2000 access microsoft training - How do I live link data from Access to Excel?

2000 access microsoft training - How do I live link data from Access to Excel?

resolvedResolved · Low Priority · Version Standard

replyReply Thu 18 Oct 2007, 16:36Delegate Maxime said...

Maxime has attended:
Access Intermediate course
Excel Advanced course

How do I live link data from Access to Excel?

How do I live link data from Access to Excel?

For upcoming training course dates see: Pricing & availability

replyReply Mon 22 Oct 2007, 16:22Trainer Richard said...

RE: How do I live link data from Access to Excel?

FILE > GET EXTERNAL DATA > LINK

Step througth the Link wizard.

 

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



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