By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Access97 How to have a visible cell reference from another DB or SS

P: n/a
cor
In Access(97) I am able to have a cell to be a hyperlink referencing a spreadsheet,
a cell, a column or a database's table or query. When I click on it It opens
on such reference program. The content of such cell is not the content of the reference
but a 'display text' value that I assign. Since the database does not see the
referenced value it can not be used as a query value.

My question is is there a way to have a visible cell reference from another DB
or a Spread Sheet cell?
Would a Macro do the job? What macro command should I use?

Another somewhat related question: can I have a query based on calculations over a column(s)?
Mar 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.