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
4  3224 
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
"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
"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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: c duden |
last post by:
Excel won't allow documents to be linked to a worksheet in office 2000 when
using C# to create an add-in.
The following code snippets are what was used in the attempts
(there are more permutations of parameters, but for brevity...):
// one - based on code from Matt Reynolds' website
Excel.Worksheet active =...
|
by: Nick M |
last post by:
Hello All,
Excellent info here Thanks!
I am very new to using access in general and I am on a learning curve.
I'm trying to import an excel workbook (with worksheets) into an access db
via a macro. (I'll get to using VB later on).
What I would like to do is import a single workbook w/three seperate
worksheets into three seperate access...
|
by: Grip |
last post by:
Hi,
I have gone throught the group and Microsoft's online help and have
seen many suggestions but I am still seeking clarity:
1. I have an excel spreadsheet. Column A contains text that may be
greater than 255 characters.
2. I have an access database. I link (not import) to the contents of
the excel spreadsheet. In the design view in...
|
by: oyk |
last post by:
I hope someone could help me on this. I have linked an excel worksheet to
access but the some data shown in the access table has the #Num errors.
Presumably,
this must be because the data in the particular column in excel are of mixed
data-type. For example, there are numbers as well as texts like "abcd" etc.
in the same columns
I tried...
|
by: jalmar |
last post by:
Hello again:
My second question is:
I am linking an excel spreadsheet into Access, I have it linked and at first had problems getting the information imported into Access-it wasn't importing-I had a msg in the populated fields which read #NUM- I was told to use quotations before and after the numbers in Excel and it would import correctly,...
| | |
by: Sajit |
last post by:
I am trying to use an Excel file as a
template for an Access report. I Linked
the Excel file through an unbound frame as
an OLE object with the properties set as
follows:
Source Doc : C:\sajit\test.xls
|
by: afr0ninja |
last post by:
Hello!
I'm having an issue with the OutputTo function of Access. I have a few queries that I export to excel (by way of the OutputTo function) This works fine.
I then take an excel sheet and link some data from these exported sheets with other data from other excel sheets. I can create a link to one of the exported sheets. It will...
|
by: karthik28 |
last post by:
I tried linking an excel spreadsheet to an access database. It shows me a window with the data but the header row in missing. However, when I open the excel file, save it without making any changes and try linking it again, it works fine.
Please suggest a solution so that I dont have keep saving the excel file before linking it.
Thanks
KS
|
by: agarwasa2008 |
last post by:
Hi,
I have a perfect file called "Products.xls" that I link to my MS
Access 2003 database and everytthing looks good in that file.
When I view the same file after linking in my database the data values
of records in "tblProducts" are incorrect. For example the tblProducts
has a field called "PackageSize" as listed below. THe problem is...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
