Linking To Access Databases

Neilw · Apr 10th, 2002, 08:53 AM

Is it possible, using a formula, to insert a value into a cell that comes from a particular field on a form in an access database? I realise that the database must be open for this to work.

Thanks,

Neil.

dhoffman · Apr 10th, 2002, 09:10 AM

why would you want link to a form rather than a table?

Neilw · Apr 10th, 2002, 09:21 AM

Because I need to take the data of the open record, i.e. the one that is currently being viewed.

Neilw · Apr 10th, 2002, 09:33 AM

I guess an easier way would be to export the data from the form to the spreadsheet using a macro or expression from within Access. Is this possible?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 08:53 AM	#1
Neilw New Member Join Date: Apr 2002 Posts: 3	Is it possible, using a formula, to insert a value into a cell that comes from a particular field on a form in an access database? I realise that the database must be open for this to work. Thanks, Neil.

Apr 10th, 2002, 09:10 AM	#2
dhoffman New Member Join Date: Apr 2002 Location: Lawrence, KS Posts: 29	why would you want link to a form rather than a table?

Apr 10th, 2002, 09:21 AM	#3
Neilw New Member Join Date: Apr 2002 Posts: 3	Because I need to take the data of the open record, i.e. the one that is currently being viewed.

Apr 10th, 2002, 09:33 AM	#4
Neilw New Member Join Date: Apr 2002 Posts: 3	I guess an easier way would be to export the data from the form to the spreadsheet using a macro or expression from within Access. Is this possible?