Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Access links

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft access training - Access links

Resolved · Low Priority · Version Standard

Reply Thu 14 Jun 2007, 11:49Delegate Lucy said...

Lucy has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course

Access links

How do I link a field in Access to a cell in Excel? I want my access fields to link to totals in excel pages so that they update whenever I open the database, is that possible?

For upcoming training course dates see: Pricing & availability

Reply Thu 14 Jun 2007, 12:10Trainer Carlos said...

RE: Access links

Lucy

1. You cannot create a link to an Access database from within Excel.

2. You cannot link Excel data to an existing table in the database.

When you create a link, Access creates a new table. The table shows the data in the source worksheet or named range, but it doesn't actually store the data in the database.

3. Any change that you make to the data in Excel will be automatically reflected in the linked table.

Regards

Carlos

Reply Thu 14 Jun 2007, 13:13Delegate Ricardo said...

RE: Access links

I think perhaps Lucy meant the other way - such that if you have an Access database which feeds information into a spreadsheet, can you have it set such that when you update the database, it can refresh the spreadsheet?

Is this somethign that can be done by outputting the table/query to an excel spreadsheet, and overwriting the pre-existing spreadsheet each time or is there another way?

If it can be done by macro, then if you want it such that it'll happen when you open the database, name the macro AutoExec and it'll run it whenever you open your database.

Thanks

Ricardo

Reply Thu 14 Jun 2007, 14:23Delegate Lucy said...

RE: Access links

thank you I'll try that

Access articles

· Get More Out of MS Access Courses
· How Access Can Provide The Key To Successful Stock Management
· How To Show JPG Or GIF Images In Access 2003 Forms
· Microsoft Access, an Efficient Database Tool
· Microsoft Access: Unleash the True Potential Today

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips