H
Hwalker
All,
Here is the situation. We have a great clinical
tracking database that captures almost all of the
information we need, however, in some instances users need
to capture a couple of additional pieces of information.
The design of the database is on lockdown, so I am not
permitted to add these additional fields to the tables,
update the forms, etc. Someone told me that I could link
an Excel spreadsheet to the database(specifically a query)
then add the extra columns of information I need to
track. In other words, I enter most of my info into
Access, but the information it does not capture, I can
capture in this linked spreadsheet. My question is as
follows, mind you these extra columns are NOT formulas:
what do I do to keep the data from the query in line with
the extra columns' data I added in Excel? When the Excel
sheet refreshes and the page requeries, new data is
inserted into the database, but the data in the extra
columns of Excel does not adjust accordingly. Adjacent
cells with formulas adjust appropiately, how do I make
adjacent cells WITHOUT formulas adjust correctly? Any
help you gurus could provide would be greatly
appreciated. Thanks in advance.
Here is the situation. We have a great clinical
tracking database that captures almost all of the
information we need, however, in some instances users need
to capture a couple of additional pieces of information.
The design of the database is on lockdown, so I am not
permitted to add these additional fields to the tables,
update the forms, etc. Someone told me that I could link
an Excel spreadsheet to the database(specifically a query)
then add the extra columns of information I need to
track. In other words, I enter most of my info into
Access, but the information it does not capture, I can
capture in this linked spreadsheet. My question is as
follows, mind you these extra columns are NOT formulas:
what do I do to keep the data from the query in line with
the extra columns' data I added in Excel? When the Excel
sheet refreshes and the page requeries, new data is
inserted into the database, but the data in the extra
columns of Excel does not adjust accordingly. Adjacent
cells with formulas adjust appropiately, how do I make
adjacent cells WITHOUT formulas adjust correctly? Any
help you gurus could provide would be greatly
appreciated. Thanks in advance.