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

Excel Linking

P: n/a
Hi,
I've got a simple DB (Office Win XP Professional).
Basically, it's like a check book register - deposit, deduction and running
sum.
I'd like to somehow link it to an Excel spreadsheet that will do the
calculations and then keep the data updated in the form
and report in the DB. Apparently this isn't done in Access because
the "cell" where you enter the data is actually a field. I have a tabular
form that looks just like a checkbook register and I'd like each
individual record to show the change that occurs 'for that record'
in real time, as the data is entered.
I've tried Tools / Office Links / Analyze it with Excel, but without
a dynamic formula in the spreadsheet, nothing happens and there is
no link established to update the data.
Ideas? Tips?
Thank you!
Mark
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Mark,

Try basing your form on a query and in the query use calculated fields. You'll
get the effect you want this way. Linking to Excel won't give you the effect you
want!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Mark T." <tu********@verizon.net> wrote in message
news:bh*******************@nwrddc02.gnilink.net...
Hi,
I've got a simple DB (Office Win XP Professional).
Basically, it's like a check book register - deposit, deduction and running
sum.
I'd like to somehow link it to an Excel spreadsheet that will do the
calculations and then keep the data updated in the form
and report in the DB. Apparently this isn't done in Access because
the "cell" where you enter the data is actually a field. I have a tabular
form that looks just like a checkbook register and I'd like each
individual record to show the change that occurs 'for that record'
in real time, as the data is entered.
I've tried Tools / Office Links / Analyze it with Excel, but without
a dynamic formula in the spreadsheet, nothing happens and there is
no link established to update the data.
Ideas? Tips?
Thank you!
Mark

Nov 13 '05 #2

P: n/a
"Mark T." <tu********@verizon.net> wrote in message news:<bh*******************@nwrddc02.gnilink.net>. ..
Hi,
I've got a simple DB (Office Win XP Professional).
Basically, it's like a check book register - deposit, deduction and running
sum.
I'd like to somehow link it to an Excel spreadsheet that will do the
calculations and then keep the data updated in the form
and report in the DB. Apparently this isn't done in Access because
the "cell" where you enter the data is actually a field. I have a tabular
form that looks just like a checkbook register and I'd like each
individual record to show the change that occurs 'for that record'
in real time, as the data is entered.
I've tried Tools / Office Links / Analyze it with Excel, but without
a dynamic formula in the spreadsheet, nothing happens and there is
no link established to update the data.
Ideas? Tips?
Thank you!
Mark


It sounds like you only need Excel to do a calculation that Access can
also do. If you use a subform in datasheet view, you can have it
update your running sum whenever the user updates a value. The
running sum could be a text box on the main form. A nice touch is to
include a check box value that indicates when a check clears. You can
reconcile your bank statement by having another running sum that
subtracts all cleared checks from the sum of all deposits. If you
don't like waiting for the automatic calculations you can use a
command button to do the calculations when you are finished editing.

James A. Fortune
Nov 13 '05 #3

P: n/a
"Mark T." <tu********@verizon.net> wrote in message news:<bh*******************@nwrddc02.gnilink.net>. ..
Hi,
I've got a simple DB (Office Win XP Professional).
Basically, it's like a check book register - deposit, deduction and running
sum.
I'd like to somehow link it to an Excel spreadsheet that will do the
calculations and then keep the data updated in the form
and report in the DB. Apparently this isn't done in Access because
the "cell" where you enter the data is actually a field. I have a tabular
form that looks just like a checkbook register and I'd like each
individual record to show the change that occurs 'for that record'
in real time, as the data is entered.
I've tried Tools / Office Links / Analyze it with Excel, but without
a dynamic formula in the spreadsheet, nothing happens and there is
no link established to update the data.
Ideas? Tips?
Thank you!
Mark


It sounds like you only need Excel to do a calculation that Access can
also do. If you use a subform in datasheet view, you can have it
update your running sum whenever the user updates a value. The
running sum could be a text box on the main form. A nice touch is to
include a check box value that indicates when a check clears. You can
reconcile your bank statement by having another running sum that
subtracts all cleared checks from the sum of all deposits. If you
don't like waiting for the automatic calculations you can use a
command button to do the calculations when you are finished editing.

James A. Fortune
Nov 13 '05 #4

P: n/a
Hi,
Thank you for the input.
However, I'm obviously new at this,
so are there any examples of how to make
this particular calculated field or query?
I've tried to type into the zoom box,
running sum-deduction+deposit
and what I finally wind up with is a grand
total for the entire DB apperaring in the running
sum "cell" for each record. It updates, but only
shows the total, not the changes caused by the
individual entry - deposit or deduction.
Thank you,
Mark
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.